Southern California Edison (SCE) is looking to build a better tomorrow by creating and supporting analytical datamarts, developing data integration pipelines, and analyzing large datasets to power the planet, reduce carbon emissions, and create cleaner air for everyone.
Requirements
- Coding languages (i.e. Python, SQL, PROC, R, etc.)
- Experience with OLAP systems such as Snowflake, GCP and others
- Familiarity with systems like Palantir Foundry, SAP, Oracle, OMS/ADMS, ODRM, or similar platforms
- Understanding of cloud-based data storage and architecture
- Experience building and maintaining APIs and ETL pipelines using tools like Python, SQL, Apache Airflow, Azure Data Factory, or similar platforms
- Additional certifications such as Palantir Foundry Data Engineer, Azure Data Engineer, Certified Data Management Professional, SnowPro Advanced, etc.
- Experience with data validation, metadata management, and ensuring consistency and accuracy across systems
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
- Keeps 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
Other
- 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
- Up to 10% traveling and being out in the field throughout the SCE service territory
- Must work and reside in the state of California
- Hybrid work mode with option to work remotely on certain days
