Data Engineering Senior Specialist

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?

• 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.

• 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

• Experience in writing queries using SQL, PROC SQL or PL/SQL
• Three or more years of using Python and/or R for data manipulation and integration.
• Experience in creating dashboards and visual reporting using Power BI, SAS Viya, Tableau, Palantir
• Knowledge of relational database systems and concepts
• Experience with SAP HANA, SAS EG, Palantir
• Experience in creating ETL workflows.
• Experience in process improvement and automation
• Exposure to OLAP systems such as Snowflake or GCP
• Experience with C#, Visual Basic, VBA, batch scripting, Java is a plus.

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.
• Southern California Edison is an 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.