ESSENTIAL DUTIES AND RESPONSIBILITIES
These are functions a qualified incumbent or applicant must be able to perform with or without reasonable accommodation.
Key Responsibilities:
- Execute ETL processes to assess client datasets and prepare reliable, traceable data for analysis, reporting, and visualization.
- Perform data analysis and compile technical reports and findings that explain trends, anomalies, assumptions, limitations, and recommended actions.
- Lead assigned reporting and analytics projects independently, including planning, stakeholder coordination, testing, documentation, and delivery.
- Develop thorough test plans and perform QA/QC to confirm the proper functioning of reports, calculations, dashboards, and data automation tools.
- Create dashboards and visual reports that communicate key performance indicators and other 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 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, applicable security and confidentiality requirements, and established data governance practices.
Wildfire Mitigation Assignment Responsibilities
- 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 supporting QDRs, AIR, WMP tables, effectiveness studies, narratives, and regulatory responses.
- Investigate reporting changes, anomalies, conflicting values, missing information, and source-system discrepancies; 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