Senior Data Analyst - Utilities & PMO Insights

AcceleratedPM; Naperville (IL); On-site; USD 125,000 - 170,000; Full time

Job summary

AcceleratedPM seeks a Data Analyst to support a major utility and energy client from Naperville, IL. You will source, transform, and visualize complex data to drive insights for the PMO and Construction Operations teams.

Responsibilities include building ETL pipelines, creating Power BI dashboards, and collaborating with project teams to turn data into actionable analytics—while maintaining data quality and governance standards.

Qualifications

• Accredited bachelor's degree in data-related field.
• 5+ years of relevant data analysis experience, preferably in project-driven or operational environments.
• 3+ years of hands-on SQL experience (Oracle and MS SQL Server).
• 3+ years of Python scripting for data processing (pandas, NumPy) and visualization (matplotlib, seaborn, plotly).
• Strong experience building dashboards and models in Power BI (DAX, Power Query).
• Familiarity with ERP data structures.
• Experience with Oracle Cloud ERP, SAP, or MS Dynamics.
• Experience analyzing data in construction, utilities, engineering, or infrastructure projects.
• Excellent verbal and written communication skills; able to explain complex concepts to technical and non-technical audiences.
• Self-starter thriving in cross-functional teams and fast-paced environments.

Responsibilities

• Extract, transform, and analyze data from multiple sources, including Oracle ERP and MS SQL Server.
• Write advanced SQL and Python scripts for data wrangling, automation, and exploratory analysis.
• Build and maintain ETL pipelines with focus on data integrity and performance.
• Develop interactive dashboards and reports in Power BI, using DAX and Power Query.
• Partner with construction managers, schedulers, and project controllers to translate operational data into analytics.
• Conduct trend analysis, forecasting, and cost/resource modeling for capital project planning.
• Document data sources, workflows, and reporting logic clearly and repeatably.
• Monitor and improve data quality, implementing governance practices.
• Analyze project controls data to support PMO reporting and decision-making.
• Stay current with emerging tools and best practices in data analytics for project environments.
• Develop and maintain methods to aggregate data from multiple sources for analysis and reporting.
• Demonstrate high proficiency in Excel, Access, Tableau, Power BI; maintain data governance.

Skills

SQL (Oracle & MS SQL Server)

Python (pandas, NumPy)

Power BI (DAX, Power Query)

Excel

Tableau

Data visualization & analytics

Education

Bachelor's degree in Data Science, CS, Engineering, Statistics, or related field

Tools

Tableau

Excel

Access

Job description

AcceleratedPM seeks a Data Analyst to support a major utility and energy client from Naperville, IL. You will source, transform, and visualize complex data to drive insights for the PMO and Construction Operations teams.

Responsibilities include building ETL pipelines, creating Power BI dashboards, and collaborating with project teams to turn data into actionable analytics—while maintaining data quality and governance standards.