Data Analyst II

Campos•San Diego, CA

About The Position

The Data Analyst II executes ETL processes to assess client datasets and prepare reliable, traceable data for analysis, reporting, and visualization. The role performs data analysis and produces technical reports explaining trends, anomalies, assumptions, limitations, and recommended actions. It independently leads assigned reporting and analytics projects, including planning, stakeholder coordination, testing, documentation, and delivery. The analyst develops test plans and performs QA/QC on reports, calculations, dashboards, and data automation tools, and creates visual reporting that presents key performance indicators and business or regulatory information in an actionable format. The position collaborates with project managers, subject-matter experts, data owners, and business stakeholders to clarify requirements, resolve data issues, and communicate findings and status. It also identifies opportunities to improve data quality, standardize methodologies, strengthen data lineage, automate recurring processes, and reduce manual effort. Work must follow Campos EPC standards, client procedures, applicable security and confidentiality requirements, and established data governance practices. For wildfire mitigation assignments, the analyst supports quarterly data and spatial reporting, AIR, WMP filings and tables, regulatory data requests, and other wildfire mitigation reporting. Responsibilities include gathering, analyzing, validating, and reconciling data for QDRs, AIR, WMP tables, effectiveness studies, narratives, and regulatory responses; investigating changes, anomalies, conflicting values, missing information, and source-system discrepancies; and coordinating resolution with data owners and program SMEs. The analyst applies statistical methods and diagnostic or predictive modeling as appropriate, develops and maintains interactive Power BI or Tableau dashboards, identifies appropriate sources for defensible analyses, validates data across regulatory deliverables, and documents sources, definitions, methodologies, assumptions, business rules, regulatory requirements, validation procedures, and lineage. Technical analyses are translated into plain-language findings and recommendations for project managers, executives, business leaders, and regulatory stakeholders. Campos EPC describes industry-leading pay, a team environment, a rewards system that aligns compensation with success, career development opportunities, and the ability to create one's own future.

Requirements

Bachelor’s or Master’s degree in Business Administration, Information Systems, Communications, Computer Science, Engineering, Statistics, 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 ability to independently lead 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 to confirm reports, calculations, dashboards, and data automation tools function properly.
Create dashboards and visual reports that communicate KPIs and business or regulatory information in an actionable format.
Collaborate with project managers, SMEs, data owners, and business stakeholders to understand requirements, resolve data issues, and communicate findings and status.
Identify improvements to data quality, methodology standardization, data lineage, process automation, and reduction of manual effort.
Follow 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, and coordinate 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 for 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.