Data Engineering, Senior Specialist

Southern California Edison; Pomona, Northern (CA, KY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Southern California Edison (SCE) is seeking a Senior Data Engineering Specialist. You will design and build data pipelines, data integration workflows, and reporting systems to support analytics and business initiatives.

You’ll collaborate with data scientists, analysts, and stakeholders to optimize data flows, ensure data quality, and enable scalable analytics across the organization. The role requires strong SQL, Python, and data modeling skills, with experience in ETL/ELT and dashboards.

Qualifications

• Bachelor's degree in CS/IS/Engineering or equivalent STEM major.
• 5+ years of experience with large data processing and transformations.
• Experience with SQL queries (PROC SQL/PLSQL a plus).
• Experience with Python and/or R for data manipulation.
• Experience building ETL/ELT workflows and data pipelines.
• Experience creating dashboards and reporting with Power BI/Tableau/SAS Viya/Palantir Foundry.
• Knowledge of data modeling, warehousing, and data quality.
• Experience with enterprise platforms like Snowflake, SAP HANA, Palantir Foundry, Oracle, GCP.

Responsibilities

• Optimizes performance and scalability of data pipelines.
• Develops reusable pipeline components and supports Data Scientists.
• Designs ETL architectures for big data to support business initiatives.
• Collaborates with stakeholders to elicit requirements and improvements.
• Troubleshoots production pipelines and ensures data integrity.
• Contributes to data dictionaries and data mapping from sources to targets.

Skills

SQL

Python

R

Data modeling

Data warehousing

ETL/ELT design

Dashboarding

Education

Bachelor's degree in CS/IS/Engineering

Tools

Power BI

Tableau

SAS Viya

Palantir Foundry

Snowflake

Oracle

GCP

Job description

Join the Clean Energy Revolution

Become a Data Engineering, Senior Specialist at Southern California Edison (SCE) and build a better tomorrow. In this job, you’ll be responsible for creating and supporting analytical solutions, by designing and building data integration workflows, reporting data marts and dashboard reporting systems.

As a Data Engineering, Senior Specialist, your work will help power our planet, reduce carbon emissions, and create cleaner air for everyone. Are you ready to take on the challenge to help us build the future?

Responsibilities

• Optimizes performance and scalability of critical data pipelines.
• Develops reusable and parameterized pipeline components and templates. Performs analysis and support to Data Scientists for model development.
• Designs pipeline architectures and ETL processes using big data technologies to support business initiatives.
• Collaborates with stakeholders to elicit pipeline requirements and identify improvement opportunities. Utilizes data ingestion capabilities to ingest and preprocess data from various sources, designed and optimized.
• Troubleshoots and resolves issues with production pipelines.
• Ensures data pipeline continuity and integrity through testing and change management. Contributes to data dictionary and data mapping from sources to the target from SCIM Data Model Design and develop Data-as-a-Service solutions to improve data consumption.
• A material job duty of all positions within the Company is ensuring the protection of all its physical, financial and cybersecurity assets, and properly accessing and managing private customer data, proprietary information, confidential medical records, and other types of highly sensitive information and data with the highest standards of conduct and integrity.

Minimum Qualifications

• Bachelor's Degree in Computer Science, Information Systems, Engineering, Statistics/ Mathematics or equivalent STEM major
• Five or more years of experience in data processing large data sets, hands-on with data transformation, aggregation, and filtering.

Preferred Qualifications

• Advanced experience writing queries and developing data solutions using SQL, with experience in PROC SQL, PL/SQL, or similar query languages a plus.
• Two or more years of experience using Python and/or R for data manipulation, automation, integration, and analysis.
• Experience designing, building, and maintaining ETL/ELT workflows, data pipelines, and reusable data integration components.
• Experience creating dashboards, visual analytics, and reporting solutions using tools such as Power BI, Tableau, SAS Viya, Palantir Foundry, or similar platforms.
• Knowledge of relational database concepts, data modeling, data warehousing, and data quality practices.
• Experience with enterprise data and analytics platforms such as Snowflake, SAP HANA, Palantir Foundry, Oracle, GCP, or similar technologies.
• Experience supporting production data solutions, including troubleshooting, testing, change management, and performance optimization.
• Experience driving process improvement and automation to reduce manual effort, improve data reliability, and support scalable business processes.

Additional Information

• This position’s work mode is hybrid. The employee will report to an SCE facility for a set number of days with the option to work remotely on the remaining days. Unless otherwise noted, employees are required to work and reside in the state of California. Further details of this work mode will be discussed at the interview stage. The work mode can be changed based on business needs.
• Visit our Candidate Resource page to get meaningful information related to benefits, perks, resources, testing information, hiring process, and more!
• Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
• The primary work location for this position is Pomona, CA (PIV3).

About Southern California Edison

The people at SCE don't just keep the lights on. Our mission is so much bigger. We’re fueling the kind of innovation that’s changing an entire industry, and quite possibly the planet. Join us and create a future with cleaner energy, while providing our customers with the safety and reliability they demand. At SCE, you’ll have a chance to grow personally and professionally, making a real impact in Southern California and around the world.

Southern California Edison is a proud Equal Opportunity Employer, including disability and protected veteran status.

We are committed to ensuring that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodations at [e-mail] or [phone] and select option 2.