Data Analyst II | Wildfire Mitigation Support

Insight Global; San Diego (CA); On-site; USD 70,000 - 95,000; Full time

Job summary

Insight Global in San Diego, CA is seeking a Data Analyst II to support wildfire mitigation programs and regulatory reporting. You will work with large datasets, build dashboards, and translate complex data into actionable insights.

You will analyze, validate, and transform data, execute ETL processes, and create dashboards in Power BI and Tableau. Collaboration with project managers and stakeholders is essential to deliver timely, accurate reporting.

Qualifications

• 2–5 years of data analytics, BI, reporting, or data management experience.
• Bachelor’s or Master’s degree or equivalent experience.
• Power BI Data Analyst or similar analytics certification (preferred).
• Experience with regulatory reporting, risk, or asset management is a plus.

Responsibilities

• 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 filings and regulatory data requests.
• Investigate data discrepancies, anomalies, missing information, and reporting changes.
• Perform QA/QC on reports, calculations, dashboards, and automated processes.
• Document data sources, calculations, methodologies, business rules, and data lineage.
• Work with project managers, data owners, and stakeholders; present findings clearly.

Skills

SQL

Power BI

Tableau

Python

R

Excel

Statistics

Data governance

Data modeling

Data quality

Education

Bachelor’s or Master’s degree in a related field, or equivalent experience

Tools

AWS S3

Redshift

Job description

Job Description

Location: San Diego, CA | In-person collaboration as neededWe’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

Skills and Requirements

• 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
• 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

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [e-mail].