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 stakeholders.
EDUCATION and/or EXPERIENCE - 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 and with independently leading reporting or analytics assignments.
- Utility, wildfire mitigation, regulatory reporting, compliance, risk, asset management, or infrastructure program experience preferred.
- Power BI Data Analyst or comparable analytics certification preferred
Skills & Abilities- SQL - Strong proficiency in database querying and analysis.
- Python or R - Proficiency using at least one language for deeper data analysis, automation, or modeling.
- Business Intelligence - Strong proficiency with Power BI; Tableau or comparable visualization experience may also be beneficial.
- Cloud Data Tools - Hands-on experience with AWS data storage and analysis tools, including Amazon S3 and Amazon Redshift.
- Excel - Advanced Microsoft Excel skills, including analysis, reconciliation, data shaping, and quality review.
- Statistics & Modeling - Working knowledge of statistics, hypothesis testing, data modeling, and diagnostic or predictive analytical methods.
- Data Quality & Governance - Able to validate accuracy, completeness, consistency, and traceability and document methodologies, business rules, controls, and lineage.
- Communication - Able to explain technical findings, assumptions, limitations, and recommendations clearly to technical and non-technical audiences.
- In-Person Collaboration - Able to attend in-person meetings in the San Diego area as needed.
SALARY: 90-110k/yr depending on experience