Data Analyst II

Campos EPC•San Diego, CA

14h•$90,000 - $110,000

About The Position

The Data Analyst II performs ETL, data analysis, reporting, visualization, and quality assurance to prepare reliable, traceable data and communicate useful findings. The role independently leads assigned reporting and analytics projects, from planning and stakeholder coordination through testing, documentation, and delivery. It also supports wildfire mitigation reporting and regulatory deliverables by gathering, validating, reconciling, and analyzing relevant data; maintaining dashboards; documenting methods and lineage; and translating technical analyses into plain-language findings and recommendations. Work must follow Campos EPC standards, client procedures, security and confidentiality requirements, and data governance practices.

Requirements

Bachelor’s or Master’s degree in Business Administration, Information Systems, Communications, Computer Science, Engineering, Statistics, or Economics, or equivalent experience.
Minimum 2 to 5 years of relevant data analysis, reporting, data management, business intelligence, or comparable experience.
Demonstrated experience with data management and visualization.
Demonstrated experience independently leading reporting or analytics assignments.

Nice To Haves

Utility, wildfire mitigation, regulatory reporting, compliance, risk, asset management, or infrastructure program experience.
Power BI Data Analyst or comparable analytics certification.

Responsibilities

Execute ETL processes to assess client datasets and prepare reliable, traceable data for analysis, reporting, and visualization.
Analyze data and compile technical reports explaining trends, anomalies, assumptions, limitations, and recommended actions.
Independently lead assigned reporting and analytics projects, including planning, stakeholder coordination, testing, documentation, and delivery.
Develop test plans and perform QA/QC on reports, calculations, dashboards, and data automation tools.
Create dashboards and visual reports communicating key performance indicators and business or regulatory information.
Collaborate with project managers, SMEs, data owners, and business stakeholders to understand requirements, resolve data issues, and communicate findings and status.
Identify opportunities to improve data quality, standardize methodologies, strengthen data lineage, automate recurring processes, and reduce manual effort.
Perform work in accordance with Campos EPC standards, client procedures, security and confidentiality requirements, and data governance practices.
Support quarterly data and spatial reporting, AIR, WMP filings and tables, regulatory data requests, and other wildfire mitigation reporting requirements.
Gather, analyze, validate, and reconcile data for QDRs, AIR, WMP tables, effectiveness studies, narratives, and regulatory responses.
Investigate reporting changes, anomalies, conflicting values, missing information, and source-system discrepancies, coordinating resolution with data owners and program SMEs.
Apply statistical methods and diagnostic or predictive modeling, as appropriate, to identify trends, patterns, relationships, and anomalies.
Build and maintain interactive Power BI or Tableau dashboards and visual reports for wildfire mitigation performance and regulatory reporting.
Identify appropriate data sources and develop clear, defensible analyses and supporting information for wildfire mitigation data requests.
Validate data accuracy, completeness, consistency, traceability, and alignment across regulatory deliverables.
Document data sources, metric definitions, calculation methodologies, assumptions, business rules, regulatory requirements, validation procedures, and data lineage.
Translate technical analyses into plain-language findings and recommendations for project managers, executives, business leaders, and regulatory stakeholders.