Principal Data Engineer Jobs in California (NOW HIRING)

Requisition ID # 172993 

Job Category: Information Technology 

Job Level: Manager/Principal

Business Unit: Energy Delivery

Work Type: Hybrid

Job Location: Oakland

Department Overview

The Technology & Data Strategy team within the Land, Environmental and Permitting Services (LEAPS) Organization delivers a broad range of expertise and services to drive integrated, cross-organizational solutions for LEAPS. The Technology & Data Strategy (T&DS) is responsible for building, maintaining, enhancing, and analyzing systems and data applications, as well as creating visualization that provides valuable information. The team's mission is to provide practical and relevant insights from data, that supports strategic and informed decisions.

Position Summary

The Principal Data Engineer designs, develops, modifies, configures, debugs and evaluates solutions for extracting data from various sources, implements transformation logic, and stores data in various formats fit for use by the resource planning and strategy team. Collects metadata about jobs/sources including data lineage and transformation logic to create data models and ensure data is accessible to the team. Works with IT teams, data owners, functional area leads and leadership throughout the development cycle practicing continuous improvement. The data engineer identifies and solves current gaps in data requirements and creates ease of access to ensure fast and consistent responses to leadership inquiries.

This position is hybrid, working from your remote office and your assigned work location based on business needs or company requirements. The assigned work location will be within the PG&E Service Territory and will be agreed upon by the successful candidate and hiring leader.

PG&E is providing the full salary/pay range for this position. The actual amount paid to an individual will be based on multiple factors, including, but not limited to, internal equity, specific skills, education, licenses or certifications, experience, market value, and geographic location. The range to reasonably expect will be around the minimum and the midpoint. The final decision will be made on a case-by-case basis related to the factors above. This job is also eligible to participate in PG&E's discretionary incentive compensation programs.

Bay Area Min: $155,000

Bay Area Mid: $210,000

Bay Area Max: $265,000

Job Responsibilities

Forms and leads teams to focus on complex data and analytics-centric problems having broad and significant impact that require in-depth analysis and judgment to obtain results or solutions.

Contributes to the resolution of uniquely complex data and analytics-centric problems having significant impact.

Creates and maintains optimal data pipeline architecture

Created complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.

Provides thought leadership on infrastructure that allows data to be accessed and analyzed with verified data quality and metadata appropriately captured and catalogued.

Aids other programmers /analysts on unusual or especially complex problems that cross multiple functional/technology areas.

Works closely with other departments on cross-team work needs/requirements.

Partners with the business and other departments to develop requirements and assemble large, complex data sets that meet functional / non-functional business requirements.

Drives the development of departmental standards, norms, and new goals/objectives.

Communicates (oral and written) recommendations.

Mentors/provides guidance to less experienced colleagues.

Qualifications

Minimum

BA/BS in Computer Science, Management Information Systems or related field of study, or equivalent experience

10 years of experience with multiple data engineering/ETL ecosystems such as Palantir Foundry, Spark, Informatica, SAP BODS, OBIEE.

Experience with multiple data engineering/ETL ecosystems.

Proven track record of successfully implementing data warehouses/data lakes over previous five years.

Experience leading development teams.

3 years of experience in machine learning algorithm deployment and machine learning operations.

Desired

Familiarity with utility operations

Experience in Snowflake or Microsoft Fabric

Experience in Power BI Dataflows and Semantic Models