PCGJP00004951 Senior Ops Data Analyst not avail for ref

Spotlight Call Notes on PCGJP00004951

Summary

• Hiring for Senior Ops Data Analyst (Req #4951) to support the Visual Management and Insight Services team, specifically translating regulatory compliance data (CPUC, CAL FIRE) into visual insights.
  
• Top priority is expert Power Apps proficiency (building canvas apps from scratch, releasing, and maintaining) as the current team is understaffed in this specific domain; knowledge of Power BI, Power Automate, and Dataverse is required.
  
• Candidate preferences: Prior PG&E or utility experience is a preferred initial filter; candidates must live within the PG&E service territory (Oakland/Sacramento/Rocklin) to allow for occasional physical interaction, though daily in-office requirements are flexible.
  
• Engagement terms: The role is currently posted through 31 Dec 2026 due to calendar-year budget cycles, but the hiring manager anticipates a long-term need of 6–12 months with potential for full-time conversion.
  
• Next steps for suppliers: Filter for candidates with a minimum of 4 years related experience; Hiring manager requests a portfolio of prior Power Apps work for review during the interview process. (this is not a hard requirement but will make our submissions stand out in compairison)
  

Full Notes

Role Overview and Team Objectives

• Job posting 4951 is for a Senior Level Ops Data Analyst within the Visual Management and Insight Services department, managed by Patrick Panikvar.
  
• The team is responsible for translating regulatory compliance data from agencies such as CPUC, OEIS, and CAL FIRE into visual insights.
  
• The primary driver for this hire is the need to scale the team’s reporting capacity and transition from simple numerical reporting to generating actionable insights.
  
• The team currently utilizes the Microsoft Power Platform, including Power BI, Power Automate, and Dataverse.
  
• A critical gap exists in Power Apps development, which is the central focus of this new role.
  

Technical Requirements and Candidate Qualifications

• The essential requirement for this position is demonstrated experience in building, releasing, and maintaining Power Apps solutions from scratch.
  
• The candidate will primarily work with Canvas apps (a type of Power Apps) to create new solutions for the compliance team.
  
• Expertise in the broader Microsoft Power Platform is required, though the team already possesses proficiency in Power BI and Power Automate (so although needed, these will not be part of their day-to-day work).
  
• The Hiring Manager established specific filters for the candidate selection process to manage high applicant volumes.
  
• Prior experience with PG&E or a utility background is preferred and will be used as a primary resume filter.
  
• Candidates must have a minimum of four years of related work experience and a BA or BS degree, or equivalent work experience.
  
• Several technical skills were identified as non-mandatory, "nice-to-have" attributes that demonstrate analytical depth.
  
• These include Unix Shell programming, SAS, Azure Data Factory, Azure SQL, and Synapse Analytics.
  
• Experience working cross-functionally to gather requirements from non-technical stakeholders is highly valued.
  

Engagement Logistics and Timeline

• The contract is currently scheduled to end on December 31, 2026, due to calendar-year budget constraints.
  
• Patrick Panikvar noted that contracts typically last between 6 and 12 months, and extensions are very likely if budget permits.
  
• There is a possibility for the role to convert to a full-time staff position in the future.
  
• Work location requirements are flexible but restricted to the PG&E service territory.
  
• The role is essentially remote-friendly provided the candidate is within the PG&E territory.
  

Interview and Vetting Process

• The selection process will focus on behavioral and technical discussions rather than formal skills testing.
  
• Candidates will be asked to describe specific Power Apps they have built, focusing on the challenges faced and their collaborative process.
  
• The Hiring Manager requested that candidates provide a portfolio or samples of previous work to demonstrate the depth of their experience.
  

Requirements

Pay 60-63/ hr

Location Hybrid - Oakland CA

TOP THINGS:
Prior PG&E experience or utility experience
Specific Power Apps domain knowledge (building, releasing, and maintaining Power Apps Solutions for teams) and other power platform skills such as Power BI, Power Automate, and Dataverse experience
Cross functional requirements gathering and partnership experience.

*****THERE WILL BE A SPOTLIGHT CALL

Minimum Experience
4 years of related work experience in data analysis, business intelligence, reporting, operations analytics, database management, automation, Power Apps development, or application development.
Experience designing, building, deploying, and supporting Canvas or Model-Driven Power Apps in a business or enterprise environment.
Experience developing Power BI dashboards, enterprise reporting solutions, data models, or KPI scorecards.
Experience using Microsoft Power Platform technologies such as Power Apps, Power Automate, Dataverse, SharePoint Online, and Microsoft 365 is strongly preferred.

Knowledge, Skills, and Abilities
Advanced data analysis, data processing, data visualization, and reporting skills with ability to translate complex data into actionable business insights.
Advanced Microsoft Excel and Access skills, including complex formulas, graphing, VBA, data manipulation, and reporting automation.
Advanced skill writing SQL queries using Oracle, Business Objects, SQL Server, or related database technologies.
Proficiency with Power Apps, including Canvas apps, Model-Driven apps, forms, galleries, components, connectors, formulas, validation logic, role-based functionality, app testing, app deployment, app documentation, and user support.
Proficiency with Power BI, DAX, Power Query, data modeling, semantic models, star schema design, fact and dimension tables, data relationships, and dashboard design.
Proficiency with Power Automate, SharePoint Online, Dataverse, Microsoft 365, Teams, Outlook, Excel, and workflow automation concepts.
Familiarity with Power Platform governance, application lifecycle management, environment strategy, security roles, permissions, solution packaging, release management, and maintainability practices.
Familiarity with ETL/ELT processes, REST APIs, data warehousing, data governance, data quality controls, and row-level security.
Familiarity with utility operations, compliance, risk management, audit, governance, or executive reporting environments.
Knowledge of UNIX shell programming, base-SAS, Visual Basic, Perl, C, Azure Data Factory, Azure SQL, Synapse Analytics, Microsoft Fabric, or other data platforms is preferred.
Strong organizational skills with ability to independently prioritize work, manage multiple projects, meet deadlines, and deliver high-quality work products with limited supervision.
Strong communication, presentation, facilitation, and stakeholder management skills, including ability to tailor findings and recommendations to technical and non-technical audiences.
Strong analytical, problem-solving, troubleshooting, project management, and continuous improvement skills.