Data Analyst II

Campos EPC LLC; San Diego (CA); On-site; USD 70,000 - 100,000; Full time

Job summary

NACC Construction is seeking a data analyst to execute ETL processes, analyze datasets, and produce reliable, traceable data for reporting and visualization. You will develop dashboards and reports to communicate KPIs and regulatory information clearly to project teams and leadership.

In this role you will independently lead analytics projects, coordinate with PMs, SMEs, and data owners, perform QA/QC, document methodologies, and translate complex analyses into plain-language recommendations for

Qualifications

• Bachelor’s or Master’s degree in a relevant field and 2–5 years of data analytics experience.
• Experience with data management, BI reporting, and independently leading analytics projects.
• Proficiency with Power BI or Tableau and data visualization best practices.
• Knowledge of data governance, QA/QC, and regulatory reporting is a plus.

Responsibilities

• Execute ETL processes to prepare reliable, traceable data for analysis.
• Analyze data and compile reports explaining trends, anomalies, and actions.
• Lead analytics projects, including planning, testing, and delivery.
• Develop tests and QA/QC for reports and dashboards.
• Create dashboards communicating KPIs and regulatory information.
• Collaborate with PMs, SMEs, data owners, and stakeholders to gather requirements.
• Identify data quality improvements and automate recurring processes.
• Ensure compliance with data governance practices and security standards.
• Support regulatory reporting and data requests with validated data.

Skills

ETL processes

Data analysis

Dashboards

QA/QC

Data governance

Stakeholder coordination

Communication

Statistical methods

Predictive modeling

Data lineage

Education

Bachelor's degree

Master's degree

Tools

Power BI

Tableau

SQL

Job description

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.
• 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

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!

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.