Data Analyst II

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

SALARY: 90-110k/yr depending on experience

WHY CAMPOS EPC?

Campos EPC offers industry leading pay, a great team environment, and a rewards system that aligns your compensation with your success. Our continued growth provides career development opportunities and the ability to create your own future. Campos EPC rewards innovative thinking, hard work, and determination. Come grow with us!