Data Engineering, Senior Specialist

Thomson Reuters Markets Espana SL.; Pomona, Northern (CA, KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Southern California Edison is hiring a Data Engineering, Senior Specialist to design and build data integration workflows, reporting data marts and dashboard reporting systems.

The role focuses on optimizing data pipelines, supporting data scientists, and delivering scalable analytics platforms. It requires strong SQL, Python, ETL skills and experience with BI tools in a hybrid work model based in California.

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.

Responsibilities

• Optimizes performance and scalability of critical data pipelines.
• Develops reusable and parameterized pipeline components and templates; supports Data Scientists.
• Designs pipeline architectures and ETL processes using big data technologies.
• Collaborates with stakeholders to elicit pipeline requirements and identify improvements.
• Troubleshoots and resolves issues with production pipelines.
• Ensures data pipeline continuity and integrity through testing and change management.

Skills

SQL

Python

R

ETL/ELT

Data modeling

Automation

Performance optimization

Education

Bachelor's in STEM

Tools

Power BI

Tableau

SAS Viya

Palantir Foundry

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.