Data Engineer, Advisor

Join the Clean Energy Revolution

Becomea Data Engineer, Advisorat Southern California Edison (SCE) and build a better tomorrow. In this job, you’ll have a strong background in data mining, data preparation, 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. . As a Data Engineer, Advisor, 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?

The focus area for this position includes:

• 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.
• Integration Solutions: Create and manage integration solutions to facilitate seamless data flow between disparate systems, including Enterprise Resource Planning (ERP), Geographic Information Systems (GIS), and Supervisory Control and Data Acquisition (SCADA) systems.
• Collaboration: Work closely with data scientists, analysts, and other stakeholders to understand their data needs and provide the necessary support for their projects.
• Best practices/standards/guidelines: Development of best practices/standards/guidelines for data and integration domain
• Documentation: Maintain documentation on data models, pipelines, and processes to promote knowledge sharing and facilitate continued improvements.

Responsibilities

• Manages and scales data pipelines from internal and external data sources to support new product launches and drive data quality across data products
• Facilitates data engineering activities covering data acquisition, extraction, normalization, transformation, management, and manipulation of large and complex data sets
• Keep abreast of new and current data engineering, big data and data science techniques. Research methods, techniques, and new practices; develop and promote data engineering best practices, standards and guidelines
• Works closely with subject matter experts to design and develop front end applications with data model and data pipelines supporting the applications
• Provides governance and oversight of data assets, data environments and relevant data procedures, with the proactive planning and enforcement of data asset naming conventions
• Builds and maintains data pipelines using big data processing technologies to process and analyze large datasets; uses ETL processes on the internal cluster
• Develops and maintains data warehouse schema and data models, ensuring data consistency and accuracy
• Ensures ongoing alignment of technical and business strategies based on changing business and technology drivers and risks
• Creates advanced visualizations and tools to provide insight, drive action, and support work throughout the business
• Identify and design Data-as-a-Service candidates for improved data availability and 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
• Seven or more years of experience in data processing large data sets, hands-on with data transformation, aggregation, and filtering.

Preferred Qualifications

• Three or more years of experience with electric utility functional domains data (Asset Management, Work Management, Outage Management, Entergy Procurement, Grid Ops, etc).
• Cloud Data Engineer certifications: GCP, Azure, and/or AWS.
• One or more years of experience with cloud computing.
• Three or more years of experience with Python, PySpark, and/or NodeJS/VueJS.
• Snowflake certification.
• 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.

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.

At SCE, we celebrate our differences. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected 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 (833) 343-0727.