Systems Administrator (Data Integration Engineer)

About Apex

Founded in 2009, Apex Clean Energy is an independent renewable energy company focused on bringing utility-scale generation facilities to market, from site origination and financing to turnkey construction and long-term asset management. With a team of over 200 professionals and the nation’s largest wind energy project portfolio, Apex is a leader in the transition to a clean energy future. For more information, visit www.apexcleanenergy.com.

Apex aims to excel in every phase of project realization. Our mission-driven team seeks determined, resolute individuals who strive to innovate and go above the call of duty, and who will relentlessly do their part to help accelerate the shift to America’s clean energy future.

Role Overview

Apex Clean Energy seeks a Systems Administrator to join a technologically advanced team, focusing on innovation and delivery of critical analytics to foster business solutions. This role is responsible for the management of the cloud data warehouse system, ETL processes, systems integration, analytics and reporting, as well as assisting with complex business intelligence solutions.

In addition, this position requires working with project teams in support of development and implementation activities including requirements gathering, system design and architecture, and deployment of ETL and data integration jobs. Ongoing operational support of ETL and data integration jobs are also a critical task of this position comprised of scheduling, monitoring and troubleshooting to maintain optimal health of the environments. You will need to follow current trends, their impact on business strategies, and their implications for managing sustainable data warehouse architecture.

The Systems Administrator serves as diagnostician and solution provider for data, information and business process-related analysis. They are responsible for providing technical expertise in specific data domains and incorporating data governance into daily activities. They provide expertise in the integration of data, insights and trends and solution recommendations. They enable data driven decisions for their respective domain. They partner with other analysts to extract, interpret, and perform advanced analytics.

Our ideal candidate is an action-oriented, hard-working team player who can jump in and support projects from a variety of angles. This position requires excellent communication and writing skills as well as the ability to balance priorities and shift needs on the go. A passion for renewable energy is a must.

Primary Responsibilities

Your primary responsibilities as a Systems Administrator include:

Build and maintain the ETL processes
Develop ETL packages, ensuring that best practices are implemented for data governance, data quality, data cleansing.
Development of scalable and robust ETL routines, using ETL tools and external programming and/or scripting languages as necessary.
Manage the day-to-day support and maintenance of the data warehouse environment, reports, data integration jobs and job schedules.
Collaborate with stakeholders to define business logic for source-to-target mappings and integration workflows.
Assisting in production support by resolving source data issues and refining transformation rules when needed.
Maintain the existing data warehouses and facilitate aggregation, slicing and dicing of data using dbt.
Design and develop data extraction SQL queries that are highly optimized for very large data sets.
Creating and maintaining the company data dictionary as well as technical documentation for source-to-target mapping.
Follow current trends, their impact on business strategies, and their implications for creating sustainable data warehouse architecture.
Analyze 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 enhancements
Work 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 requirements
Work collaboratively with team members and customers to gather and validate requirements as well as deliver features/enhancements
Collaborate with architects, team leads and team members to architect and design solutions to meet functional and technical requirements
Troubleshoot issues, identify resolutions
Responsible for writing complex SQL queries for mining of operational data

Success Profile

To succeed as a Systems Administrator at Apex Clean Energy, you’ll need to excel within the following criteria:

At least two years of experience with complex/large data management and systems integration.
Familiar with ETL tools for database / warehouse development. Experience with Azure, preferred.
Experience developing ETL packages, ensuring that best practices are implemented for data governance, data quality, data cleansing.
Experience in all aspects of project development life cycle such as identifying requirements, design, feasibility analysis, allocating timelines, task prioritization, development, performance, best practices and testing.
Hands-on experience performing data modeling and warehousing in a cloud-based data-warehousing system (Snowflake)
Experience in day-to-day support and maintenance of the data warehouse environment, reports, data integration jobs and job schedules.
Experience performing analysis and reporting from the data warehouse, ideally using PowerBI
Experience setting up data access and visualization tools and systems for non-technical users
Working knowledge of Python and/or SQL
Prior experience with renewable energy and/or SCADA a plus.
Experience working in a rapidly evolving environment, adapting quickly to new information and re-prioritizing as needed
Demonstrated interest/passion for renewable energy required.

What Apex Can Offer You

A mission-driven, energetic environment
Collaborative and driven professional workforce committed to supporting your ideas and feedback and accelerating your potential
Ongoing support and guidance such as on-the-job learning, hands-on experience, and mentorship
Training, strategies, and tools to support your personal and professional growth
Team atmosphere of diverse professionals committed to making an impact as an organization
Opportunities to volunteer and give back to our local communities
Exceptional benefits such as medical and dental; 401(k) with corporate match
Base and bonus commensurate with experience
Responsible Paid Time Off plus standard company holidays
Benefits Offered: comprehensive high-deductible health plans, dental and vision insurance plans, short-term and long-term disability, group life insurance, 401(k) corporate matching, flexible spending arrangements, company paid parking and cell phone, fitness and wellness corporate discounts

Apex Clean Energy, Inc. is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.