Data Engineer I

Ultipro; Minneapolis (MN); Hybrid; USD 83,000 - 87,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

HSA/FSA benefits

Retirement plan

Paid time off

Parental leave

9 paid holidays per year

Professional development

Job summary

Center for Energy and Environment (CEE) is hiring a Data Engineer to design and maintain data pipelines and architectures that support multiple programs. You will build ETL processes, transform data, and create scalable data models in cloud data warehouses to empower analysts and dashboards.

You will collaborate with data engineers and analysts to deliver reliable data solutions, optimize workflows, and ensure data quality, governance, and reproducibility in a fast‑paced nonprofit environment.

Qualifications

• Bachelor’s degree or equivalent professional experience in a technical field.
• 0-2 years in data engineering, analytics, or a related role.
• Foundational SQL skills.
• At least one programming language such as Python.

Responsibilities

• Support development of data architecture and data pipelines.
• Write and maintain Python ETL scripts and SQL data models.
• Build data from multiple sources into cloud data warehouses.
• Develop automated data workflows with orchestration tools (e.g., Prefect, Airflow).
• Implement data validation and QA/QC processes to ensure data quality.
• Collaborate with analysts to build dashboards (Plotly Dash, Power BI).
• Respond to data and reporting requests and modify schemas as needed.
• Use Git for version control and collaboration.
• Document data processes and contribute to cross‑functional projects.

Skills

Python

SQL

Data modeling

ETL pipelines

Communication

Team collaboration

Problem solving

Education

Bachelor’s degree in CS, analytics, data science or related field

0-2 years data engineering or related analytics experience

Tools

Snowflake

Git

Power BI

Tableau

Job description

• Hybrid
• Information Technology
• Full-Time
• Requisition #: DATAE001349

Description

Location

CEE - Minneapolis

212 N 3rd Ave STE 560

Minneapolis, MN 55401, USA

Hybrid – 1-2 days/week in our Minneapolis office, on-site.

Join Our Dynamic Technology Team

We are looking for a Data Engineer to join our Technology team. As a Data Engineer, you will build and maintain data architecture and pipelines supporting various programs and initiatives across CEE, including automated data ingestion processes and dashboards. This role reports to the Director of Information Technologies and primarily focuses on ETL processes: extracting, cleaning, ingesting, and transforming data to meet Analysts' needs.

This role will work collaboratively with other Data Engineers to support the Efficient Technologies Accelerator (ETA), as well as broader data needs across the organization.

Who We Are

Center for Energy and Environment (CEE) is a clean energy nonprofit with offices in North Loop of Minneapolis and Roseville, MN.We provide practical energy solutions for homes, businesses, and communities to cut energy waste and harmful emissions. We collaborate regularly with field peers and partners, and we employ curious people who enjoy learning and contributing to the Midwest’s quality of life and economy. Recognized as one of Minnesota's top 200 workplaces by the Star Tribune, CEE is known for its open communication, respect for diverse perspectives, and commitment to work-life balance.

What We Offer

• Insurance Coverage Options : To ensure you and your family are well protected, we have got you covered with Medical Insurance, Dental Insurance, Health Saving Account, and Flexible Spending Accounts. Please see our 2026 Benefit Summary .
• Impact: We want to make the world a better and more energy efficient place. Our work and the decisions we make are rooted in this foundational desire.
• Future Planning: To help you secure your financial future, benefit from our retirement saving program. Reach your goal sooner with our immediate vestingand company contribution.
• Work/Life Balance: We recognize the importance of maintaining a healthy work-life balance and are dedicated to supporting our team members in various aspects of their lives. Our benefits include generous Paid Time Off (PTO), paid parental leave, and salary continuation for major medical events, ensuring that you have the support you need during significant life moments and personal challenges.
• Holidays: Our company provides nine paid holidays each year, offering you ample time to observe important occasions and enjoy personal time.
• Growth: We want everyone to grow and learn within their roles. We offer professional development opportunities and education assistance.
• Championing DEI: Our committed DEI Committee promotes a diverse and inclusive work environment by establishing clear goals and assessing progress throughout the organization.

What You’ll Do

• Support the development and implementation of the team’s data architecture, including processes for managing, integrating, and maintaining datasets provided by external partners.
• Write, modify, and maintain Python ETL scripts and SQL data models to automate, scale, and optimize data processing workflows.
• Build and maintain repeatable processes to combine raw data from multiple sources into clean, searchable datasets housed in cloud data warehouses.
• Develop, maintain, and monitor automated data workflows using Prefect or similar workflow orchestration tools, including scheduling, task dependencies, error handling, and troubleshooting.
• Develop and implement data validation and QA/QC processes to monitor data integrity, identify discrepancies, and improve data quality.
• Troubleshoot and resolve issues across data pipelines and ETL, investigate discrepancies, and work with team members to identify and implement solutions.
• Work closely with Energy and Data Analysts to build and enhance data solutions, including interactive dashboards using tools such as Plotly Dash and Power BI, that support analysis, reporting, and decision‑making.
• Respond to ad hoc data and reporting requests from internal teams, making changes to database structures, schemas, tables, views, queries, and dashboards as needed.
• Use Git and established version control practices to manage code changes and collaborate with team members.
• Contribute to the continuous improvement and automation of the team’s data workflows and infrastructure. Facilitate conversations with cross‑functional teams to understand reporting, data intake, and data cleaning needs; build queries and views to support these needs.
• Maintain, clean, and organize large datasets and repositories to ensure data integrity and accessibility.
• Document data processes, transformations, and workflows to improve maintainability and knowledge sharing.
• Conduct quantitative analysis to support program evaluation and measure performance.
• Contribute to cross‑functional projects and assist in the development of technical documentation and deliverables. Work closely with engineering, research, and program teams to support technical analysis and program implementation.

Other duties as assigned

• 2+ years of hands‑on experience programming in Python and SQL, including modifying and maintaining existing code.
• Strong understanding of relational databases and practical experience working with a cloud data warehouse such as Snowflake.
• Experience developing and maintaining ETL/ELT pipelines, including data extraction, transformation, loading, and validation.
• Experience designing and implementing SQL tables, views, queries, and data transformations.
• Experience using Git or another version control system.
• Familiarity with Microsoft Office 365, especially Excel.
• Ability to troubleshoot data and code issues systematically and independently.
• Strong attention to data quality, accuracy, and reproducibility.
• Strong motivation and interest in applying data and technology to energy efficiency and sustainability sectors.
• Ability to work independently and collaboratively in a fast‑paced, dynamic environment.

Required Experience and Education

• Bachelor’s degree in computer science, analytics engineering, data analytics, data science, or a related field, or equivalent professional experience.
• Minimum of 0-2 years of experience in a data engineer or similar role related to data analytics, data engineering, statistics, or a related technical field; internship, co‑op, academic project, or applied business experience may be considered.
• Foundational SQL skills
• At least one analytical or statistical programming language such as Python
• Experience using Git or another version control system.

Preferred Qualifications

• Experience with data visualization tools such as Tableau, Power BI, Plotly Dash.
• Experience with workflow orchestration tools such as Prefect, Airflow, or similar platforms is preferred.
• Excellent written and verbal communication skills, interpersonal skills, and ability to craft clear and compelling deliverables.
• Strong organizational and time management skills, with the ability to prioritize tasks and manage multiple projects.
• Ability to work effectively in cross-functional teams and on a variety of tasks.
• Basic knowledge or interest in energy efficiency and decarbonization is a plus.

Compensation

Dependent on qualifications and experience, we expect the pay range upon hire for this position will be $83,000– $87,000 annually.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.