Data Engineering Senior Specialist

Job Description

Become a Data Engineering Senior Specialist at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll have a strong background in data mining, data preparation, data transformation, feature engineering, data quality profiling, and data visualizations. This role also focuses on supporting a variety of data science use cases and improving data-driven decision-making across the organization. If you are passionate about transforming raw data into actionable insights, we want to hear from you! As a Data Engineer, 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?

Some of the key activities for this position include

• Data Mining: Identify, extract, and gather data from various sources including databases, APIs, and other repositories to build comprehensive datasets for analysis.
• Data Preparation: Clean, preprocess, and refine data to ensure it is in a usable format. Create efficient data pipelines to facilitate integration with data science workflows. Facilitates data engineering activities covering data acquisition, extraction, normalization, transformation, management, and manipulation of large and complex data sets.
• Implements data transformations to derive new datasets necessary for business use cases.
• Feature Engineering: Collaborate with data scientists to design and implement features for predictive modeling and machine learning use cases, ensuring the highest quality of input data for various analytics applications.
• Data Quality Profiling: Implement and maintain data quality profiling rules and monitoring processes. Identify data quality issues and work with stakeholders to resolve them, ensuring data accuracy and consistency.
• Data Visualization: Develop and maintain dashboards and visualizations that effectively communicate insights and support decision-making. Utilize visualization tools to present data findings clearly and effectively.
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand their data needs and provide the necessary support for their projects.
• Documentation: Maintain documentation on data models, pipelines, and processes to promote knowledge sharing and facilitate continued improvements.

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

• Experience with electric utility functional domains data (Asset Management, Work Management, Outage Management, Energy Procurement, Grid Ops, etc).
• Experience with building analytics visualizations using capabilities like Microsoft Power BI.
• Cloud Data Engineer certifications: GCP, Azure, and/or AWS.
• Experience with cloud computing.
• Experience with Python, PySpark, and/or NodeJS/VueJS.
• Experience with Snowflake and data engineering certification on the platform.
• Cloud Analytics certification.

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 Rosemead, CA (SCE General Office, Building 3). However, the successful candidate may also be asked to work for an extended amount of time at any of our office locations.
• Position will require up to 30% traveling and being out in the field throughout the SCE service territory.
• Relocation does not apply to this position.