Operations Data Analyst, Principal (Snowflake)

Location: Hybrid in Dublin or Pleasanton, California, United States; work from a remote office and assigned PG&E work location, with in-office reporting expected 1–2 days per week.

Salary: $140,000–$238,000 annually, plus eligibility for discretionary incentive compensation programs.

Company

hirify.global delivers clean, safe, reliable, and affordable energy across Northern and Central California through its Electric Transmission & Distribution business.

What you will do

• Manage complex data engineering and analysis projects from initial request through implementation and delivery with limited supervision.
• Extract, transform, cleanse, and transfer data from databases and other source systems for operational analysis and reporting.
• Design, develop, and maintain scalable data pipelines, data structures, automated routines, and data models using Snowflake, SQL, and related integration technologies.
• Develop complex SQL queries, stored procedures, transformations, reports, and analyses for enterprise and company-wide needs.
• Modernize and migrate legacy ETL workflows, SQL workloads, and data processes to Snowflake and modern data engineering solutions.
• Lead cross-functional projects, communicate actionable findings to clients and senior management, and provide direction to less experienced employees.

Requirements

• Bachelor’s degree in Marketing, Business, Computer Science, Engineering, or a related field, or equivalent work experience.
• At least 8 years of job-related experience.

Nice to have

• Master’s degree or equivalent experience.
• Familiarity with utility operations.
• Hands-on production data solution development using Snowflake, including data architecture, modeling, performance optimization, and transformation.
• Advanced SQL and relational database experience, including SQL Server, stored procedures, and complex SQL transformations.
• Experience designing and developing ETL/ELT pipelines, data integration solutions, and data quality, reconciliation, validation, and troubleshooting across multiple data sources.
• Experience migrating data, SQL workloads, or ETL processes from legacy or on-premises platforms to Snowflake.
• Experience with Python and Pandas; Microsoft Fabric; Power BI, Power Apps, and Power Automate; and advanced Microsoft Excel.
• Strong organization, prioritization, multitasking, communication, and presentation skills for delivering complex findings to senior management.
• Project management expertise for leading large, cross-functional projects and developing concise data findings for senior management.

Culture & Benefits

• Hybrid work arrangement combining a remote office with an assigned Dublin or Pleasanton work location.
• In-office reporting is expected 1–2 days per week based on business needs.
• Role supports Electric Transmission & Distribution operations, grid reliability, resiliency, and Lean Methodology practices.
• Eligible to participate in PG&E’s discretionary incentive compensation programs.