Data Analyst - Gas Utilities (Naperville)

Job Title: Data Analyst – Gas Utilities

Company: AcceleratedPM

Type: Full-Time Onsite

Location: Naperville, IL

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

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)

Benefits :

• Paid Time Off and Holidays
• Medical, Dental, and Vision Insurance
• IRA w/ 3% contribution from Company