> Markdown version of [/jobs/ext/3804581-data-analyst-gas-utilities-in-united-states](https://www.wearedevelopers.com/jobs/ext/3804581-data-analyst-gas-utilities-in-united-states). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - Gas Utilities in , United States - **Company:** Energy Jobline - **Location:** Naperville, IL, United States - **Experience:** Experienced - **Salary:** $125,000.0 - $170,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Access, Microsoft Excel, Application Programming Interfaces (APIs), Data Analysis, Microsoft Azure, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Systems, Microsoft Dynamics CRM, Excel Macros, Microsoft SQL Server, NumPy, Operational Data Store, Oracle (Applications), Primavera, Power BI, SAP (Applications), Microsoft SharePoint, SQL Databases, Tableau (Software), Data Processing, Scripting, Sql Optimization, Netsuite Erp, Powerquery, Pandas, Matplotlib, Information Technology, Data Analytics, Plotly, Oracle Erp - **Published:** October 17, 2026 - **Apply:** https://www.energyjobline.com/job/data-analyst-gas-utilities-united-states-31977839 ## About the Role Accredited Bachelor's Degree and 5+ Years of Relevant, 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 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 ## Description 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., 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