Data Analyst - Gas Utilities

AcceleratedPM; Naperville (IL); Presencial; USD 125.000 - 170.000; Jornada completa

Descripción de la vacante

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.

Formación

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

Responsabilidades

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

Conocimientos

SQL (Oracle & MS SQL Server)

Python (pandas, NumPy)

Power BI (DAX, Power Query)

Excel

Tableau

Data visualization & analytics

Educación

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

Herramientas

Tableau

Excel

Access

Descripción del empleo

Experience Required: Accredited Bachelor’s Degree and 5+ Years of RelevantExperience

AcceleratedPM is seeking a Data Analyst to support one of our largest utility and energy clients. This position will play a critical role in building advanced analytics solutions for the Project Management Office (PMO) and Construction Operations teams. The analyst will be responsible for sourcing, transforming, and visualizing complex data from multiple systems to drive insights that improve project delivery, field execution, and resource planning.

Location/Travel:

The primary work location is Naperville, IL. Travel to client or project sites may be required.

Duties and responsibilities may include:

• Extract, transform, and analyze data from multiple sources, including Oracle ERP, Microsoft SQL, and other construction-related platforms
• Write advanced SQL and Python scripts for data wrangling, process automation, and exploratory analysis
• Build and maintain ETL pipelines, ensuring high 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 meaningful analytics
• Conduct trend analysis, forecasting, and cost/resource modeling to support capital project planning
• Document data sources, workflows, and reporting logic in a clear and repeatable way
• Monitor and improve data quality, implementing best practices for validation and governance
• Analyze project controls data, including schedule, cost, resource, progress, and field productivity information, to support PMO reporting and decision-making
• Stay current with emerging tools and best practices in the data analytics space, especially as they apply to project-driven environments
• Develop and maintain methods to aggregate data from multiple sources for analysis, dashboards, and reporting
• Demonstrate high proficiency in Excel, Access, Tableau, Power BI, and related data analysis and reporting tools
• Apply and maintain commonly used data organizing, classifying, and governance practices and procedures
• Work closely with project teams to develop, refine, and maintain project metrics and analytical products

Required Qualifications

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

Preferred Experience:

• Prior work with utility companies, EPC firms, or construction contractors
• Familiarity with project management, scheduling (Primavera P6), cost control, or earned value concepts
• Exposure to GIS, BIM, or field productivity data systems
• Experience integrating data from APIs, Excel macros, SharePoint, or Azure services

Salary: $125 – 170k per year depending on experience (1099 contract available also)