Data Engineer at PG&E Corporation

Job description

Requisition ID # 174991 Job Category: Information Technology Job Level: Individual Contributor Business Unit: Technology & Security Work Type: Hybrid Job Location: Oakland Department Overview Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions. Position Summary Designs, develops, modifies, configures, debugs and evaluates jobs for extracting data from various sources, implements transformation logic, and stores data in various formats fit for use by stakeholders. Collects metadata about jobs including data lineage and transformation logic. Works with teams, clients, data owners and leadership throughout the development cycle practicing continuous improvement. This position is hybrid, working from your remote office and Oakland, CA, approximately 1 - 2 days per week, or more based on business needs or company requirements. Compensation 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 between the minimum and midpoint listed below. 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: $102,000.00 Bay Area Mid: $132,000.00 Bay Area Max: $162,000.00 Job Responsibilities • Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs. • Designs and deploys new systems and enhancements to existing systems ensuring compatibility and inter-operability. • Works on moderately complex problems that require in depth analysis and judgment to obtain results or solutions. • Resolves application problems within procedural guidelines. • Provides technology that supports solutions which meet business capabilities and are consistent with enterprise standards, architectures and strategies. Qualifications Minimum: • Bachelors Degree in Computer Science or job-related discipline or equivalent experience • Experience with data engineering/ETL ecosystems (e.g., Informatica, SAP BODS, OBIEE), 3 yrs Desired: Programming & Big Data • Languages: Python, PySpark, SQL, Snowflake SQL Cloud & DevOps (Infrastructure) • Cloud Platforms: Amazon Web Services (AWS) • CI/CD & DevOps Tools: GitHub Actions, Jenkins, Terraform (Infrastructure as Code), Git (Version Control) Database Technologies • Platforms: Snowflake Data Cloud • Core Competencies: Designing and managing cloud data warehouses, writing optimized Snowflake SQL, and managing storage/compute resources. ETL / ELT & Data Integration

Requirements

Must-haves

Requisition ID # 174991
Job Category: Information Technology
Job Level: Individual Contributor
Business Unit: Technology & Security
Work Type: Hybrid
Job Location: Oakland
Department Overview
Information Systems Technology Services is a unified organization comprised of various departments which collaborate effectively in order to deliver high quality technology solutions.
Analyzes existing applications and systems and formulates logic for new systems, devises logic procedures, logical database design, performs coding and tests/debugs programs.
Designs and deploys new systems and enhancements to existing systems ensuring compatibility and inter-operability.
Works on moderately complex problems that require in depth analysis and judgment to obtain results or solutions.
Resolves application problems within procedural guidelines.
Provides technology that supports solutions which meet business capabilities and are consistent with enterprise standards, architectures and strategies.
Bachelors Degree in Computer Science or job-related discipline or equivalent experience
Experience with data engineering/ETL ecosystems (e.g., Informatica, SAP BODS, OBIEE), 3 yrs

Nice-to-haves

Programming & Big Data
Languages: Python, PySpark, SQL, Snowflake SQL
Cloud & DevOps (Infrastructure)
Cloud Platforms: Amazon Web Services (AWS)
CI/CD & DevOps Tools: GitHub Actions, Jenkins, Terraform (Infrastructure as Code), Git (Version Control)
Database Technologies
Platforms: Snowflake Data Cloud
Core Competencies: Designing and managing cloud data warehouses, writing optimized Snowflake SQL, and managing storage/compute resources.
ETL / ELT & Data Integration

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

pythonsqlawsci/cd

Platform: successfactors
Effort: medium