Data Engineering Senior Specialist

Southern California Edison•Pomona, CA

3d•Hybrid

About The Position

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 part of the Transmission and Sub-Transmission System Planning (TSSP) department to lead the way in managing and leveraging data that drives critical studies and insights. In this role, you'll oversee data integration from diverse sources, ensure governance standards, and design automated solutions that streamline workflows. You'll create impactful dashboards and reporting tools while uncovering trends through advanced data mining and analytics. With opportunities to deploy machine learning and AI, your work will shape smarter decisions and deliver meaningful results across the organization. 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? 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.

Requirements

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.

Nice To Haves

Experience in writing queries using SQL, PROC SQL or PL/SQL
Experience 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.

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.