Data Engineer 1, 2, Senior
About The Position
Transform raw data from SRP's Customer Programs' many data sources into trusted, analysis-ready assets that drive business insight and enterprise value. Provide hands-on data engineering, pipeline development, and analytical enablement for the evaluation, measurement, and verification (EM&V) of SRP's customer-facing Energy Efficiency (EE), Demand Response (DR), Beneficial Electrification (E-Tech), Transportation Electrification (TE), Grid Enablement (GE), and Renewable Energy Solutions (RES) programs. The Data Engineer will design efficient data models, build and optimize complex data pipelines, and create reliable datasets that power production reporting, self-service analytics, and evaluation studies. This role is ideal for someone who enjoys both the technical depth of engineering scalable data solutions and the analytical side of partnering with business teams to uncover insights, support decision-making, and improve program performance. The position will also support secure vendor and implementer data ingestion, cloud data platform development, data quality monitoring, and internal or external reporting needs tied to Customer Programs.
Requirements
- Proficiency in R and/or Python for data preparation, analysis, and automation required
- Strong SQL skills and experience working with complex relational datasets, Snowflake, and cloud data platforms (Azure preferred) required
- Experience with data pipeline orchestration tools (e.g., ADF, Airflow)
- Experience building dashboards, supporting self-service analytics, or partnering with analysts and business users to deliver actionable insights
- All candidates must be legally authorized to work in the United States.
- Currently, SRP does not sponsor H1B visas, OPT, or other employment-related visa's.
Responsibilities
- Drive automation, reporting, and energy impact analytics across Customer Programs
- Build robust ETL pipelines that unify large, complex internal and external datasets
- Own secure data exchange workflows, including vendor and implementer file transfers
- Design and scale modern data infrastructure, including warehouses, lakes, and access frameworks
- Create trusted, analysis-ready datasets that power reporting, evaluation, and business decisions
- Develop and execute data quality checks, validation routines, and exception handling processes
- Build and support repeatable data pipelines and curated datasets for reporting, dashboards, ad hoc analysis, and evaluation deliverables
- Support Snowflake and cloud data platform development (workspace setup, data loading, migration, QA)
- Maintain and enhance program data structures, measure mappings, and business rules
- Support preparation and validation of datasets for regulatory, compliance, and external reporting
- Deliver high-impact dashboards and data visualizations to support business insights and decision-making
- Partner with IT, program teams, evaluators, and cross-functional stakeholders to translate business questions into scalable data solutions and analytical outputs
- Communicate project updates and fulfill data requests supporting evaluation, reporting, and compliance
- Collaborate with program implementers, internal & external stakeholders, and partners to translate business needs into scalable data solutions
- Identify and implement opportunities for automation and process improvement
- Support data engineering and analytical needs across EE, DR, electrification, and sustainability programs
- Use AI responsibly, including Microsoft 365 Copilot Chat, Agents and GitHub, to enhance deliverables, streamline processes, and improve efficiency
- Participate in continuous professional development
Benefits
- Pension Plan (at no cost to the employee)
- 401(k) plan with employer matching
- Medical, vision, dental, and life insurance
- Over 200+ hours of PTO (includes vacation days, holidays, floating holidays, and sick leave)
- Parental leave (up to 4 weeks) and adoption assistance
- Wellness programs (including access to a recreation and fitness facility)
- Short and long-term disability plans
- Tuition assistance for both undergraduate and graduate programs
- 10 Employee Resource Groups for career development, community service, and networking
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Education Level
Associate degree
