Data Engineer and Integration Developer

Job description

Join the Clean Energy Revolution

Become a Data Engineer and Integration Developer at Southern California Edison (SCE) and build a better tomorrow.

In this job, you'll enable digital transformation for our business and work with a team that is dynamic, with a strong sense of dedication to our customers.

You will be responsible for interfacing with key business stakeholders, listen to their business needs and apply your technical proficiency around data warehouses, data architecture and data applications to drive increased automation and establishing a solid centralized data warehouse for critical operational and compliance reporting and analytics.

As a Data Engineer and Integration Developer, 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

+ Background in the utility sector and/or energy markets is highly desirable
+ Experience in Snowflake (architecture, SQL, stored procedures, data management analysis) and/or strong proficiency with front-end Python frameworks (Streamlit, Dash, Flask, Django)
+ Experience working with Power BI (and/or other visualization tools) to build dashboards and reports leveraging BI languages & frameworks (i.e. DAX, PowerQuery)
+ Experience working with business stakeholders to understand business processes and goals and work with IT to translate these needs into requirements and desired technology solutions.
+ Experience managing projects including defining scope, establishing business value and ongoing communication on status and risk.
+ Understanding of application design and life cycles
+ Experience working closely with business stakeholders to understand needs and communicate to IT to meet stated goals.
+ Strong knowledge Data structures, Data Engineering concepts, Algorithms, Collections
+ Experience in large scale cloud data migrations using Snowflake, Python, Spark, SQL
+ Critical thinking and problem-solving skills, including planning, organizing and adaptability.
+ Ability to interact with team members at all levels of the organization and with cross functional teams.

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 (https://www.edisoncareers.com/page/show/candidate-resources) 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.
+ Relocation does not apply to this position.

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 (833) 343-0727.

Required Skill Profession

Other General