Application EngineerApex Clean Energy seeks an Application Engineer to join a technologically advanced team, focusing on innovation and delivery of critical applications and dashboards to foster business solutions and solve specific business challenges.Reporting to the Manager of Analytics and Systems Engineering within our Technology and Energy Team, you will be the main developer responsible for designing, developing, and implementing applications and programs that interface with the data warehouse. You will work closely with project teams and stakeholders across Apex in support of development and implementations activities including requirements gathering, system design and architecture, and deployment of applications. You will be responsible for then providing applications and dashboards using a combination of tools and programming languages that perform data extraction and data modeling. Ongoing operational support of ETL and data integration jobs are also an important task of this position comprised of scheduling, monitoring and troubleshooting to maintain optimal health of the environments.The Application Engineer serves as diagnostician and solution provider for data, information and business process-related analysis. We look to this role for technical expertise in specific data domains and incorporating data governance into daily activities. This role is responsible for providing expertise in the integration of data, insights, trends and solution recommendations. You will enable data driven decisions for your respective domain and partner with other analysts to extract, interpret, and perform advanced analytics.We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas at this time.ResponsibilitiesDesign and develop applications interfacing with the data warehouse (e.g., Power Apps and Power BI dashboards) that effectively accomplish objectives and needsCollaborate with stakeholders to define business logic for source-to-target mappings and integration workflows.Design and develop data extraction SQL queries that are highly optimized for very large data setsAnalyze and edit existing applications to improve functionalityRemodel and adapt applications as needed to optimize performanceAssisting in production support by resolving source data issues and refining transformation rules when neededTest applications extensively to ensure they are error and bug freeMaintain application databaseSupport the maintenance of the existing data warehouses and facilitate aggregation, slicing and dicing of data using dbtCreating and maintaining the company data dictionary as well as technical documentation for source-to-target mappingSupport the management and maintenance of ETL processesFollow current trends, their impact on business strategies, and their implications for creating sustainable data warehouse architectureAnalyze the needs and the environment to make sure the solution you're developing considers the current architecture and operating environment as well as future functionality and enhancementsWork closely and collaborate with various cross functional teams to identify, troubleshoot and fix data issues, and resolve data gaps that impact the fulfillment of the business's functional requirementsWork collaboratively with team members and customers to gather and validate requirements as well as deliver features/enhancementsCollaborate with architects, team leads and team members to architect and design solutions to meet functional and technical requirementsTroubleshoot issues, identify resolutionsQualificationsAt least two years of related experience with complex/large data managementAt least two years of relevant application engineering or development experienceAt least two years of working collaboratively across interdisciplinary teams with an end goal of solving business challengesExtensive knowledge of Python and SQLDemonstrable project management skills; highly organized and detail-orientedStrong quantitative skillsCritical, analytical, and drivenThrives in a fast-paced rapidly evolving work environment, adapting quickly to new information and re-prioritizing as neededEnjoys complex problem-solving and collaborationFamiliar with ETL tools for database / warehouse development.
Experience with Azure, preferredExperience in all aspects of project development life cycle such as identifying requirements, design, feasibility analysis, allocating timelines, task prioritization, development, performance, best practices and testingExperience supporting a data warehouse environment, reporting, data integration jobs and job schedulesExperience performing analysis and reporting from the data warehouse, ideally using PowerBIExperience setting up data access and visualization tools and systems for non-technical usersPrior experience with renewable energy and/or SCADA a plusInterest/passion for renewable energy required