Required Skills & Experience
• 2–5 years of data analytics, BI, reporting, or data management experience
• Strong SQL skills
• Strong Power BI experience; Tableau is a plus
• Experience with Python or R
• Hands-on experience with AWS S3 and Redshift
• Advanced Excel skills
• Understanding of statistics, data modeling, data quality, and governance
• Ability to independently own analytics and reporting assignments
• Bachelor's or Master's degree in a related field, or equivalent experience
Nice to Have Skills & Experience
• Utility industry experience
• Wildfire mitigation or infrastructure program experience
• Regulatory reporting, compliance, risk, or asset management experience
• Power BI Data Analyst or similar analytics certification
Job Description
Location: San Diego, CA | In-person collaboration as needed
We're looking for a Data Analyst II to support wildfire mitigation programs and regulatory reporting. This person will work with large datasets, build dashboards and reports, identify trends and data issues, and turn complex information into clear, actionable insights.
What You'll Do
• Analyze, validate, reconcile, and transform data supporting wildfire mitigation and regulatory reporting
• Execute ETL processes and ensure data is accurate, complete, and traceable
• Build and maintain dashboards and reporting in Power BI and/or Tableau
• Support wildfire mitigation reporting, including WMP filings, AIR, QDRs, regulatory data requests, and effectiveness studies
• Investigate data discrepancies, anomalies, missing information, and reporting changes
• Perform QA/QC on reports, calculations, dashboards, and automated processes
• Use statistical and analytical methods to identify trends, patterns, and potential issues
• Document data sources, calculations, methodologies, business rules, and data lineage
• Work closely with project managers, SMEs, data owners, and business stakeholders
• Present technical findings in a clear way to both technical and non-technical audiences