Job Description
Power BI and Data Systems Specialist
Department : Project Controls
Reports To : Project Controls Manager
Location : on-site (jobsite)
About The Newtron Group
The Newtron Group is one of the largest privately owned specialty electrical construction companies in the United States and a national leader in Industrial Electrical and Instrumentation services. Beyond our construction expertise, we provide innovative and customized Analytical, Automation, Heat Trace, Integration, and Design solutions across a wide range of industries.
With offices throughout the Southeast and West Coast, The Newtron Group has performed work nationwide and established strong, long-term partnerships with clients, manufacturers, and suppliers.
Our 52+ years of experience and commitment to innovation have led to the creation of the Newtron Group Control System (NGCS) — a first-class management platform that integrates project performance data from the field to the executive level. To continue advancing this system and strengthen our data-driven decision-making, we are seeking a Power BI and Data Systems Specialist to join our Project Controls team.
Purpose of the Position
The Power BI and Data Systems Specialist is responsible for designing, building, and maintaining dashboards and data pipelines that deliver actionable insights into project cost, productivity, forecasting, and performance. This position bridges technical expertise and operational understanding — transforming raw construction data into visual intelligence that empowers project managers, executives, and field operations to make faster, smarter decisions.
Key Responsibilities
1. Dashboard Development and Automation
- Design, develop, and maintain Power BI dashboards and data models visualizing key performance indicators such as labor hours, progress curves, earned vs. burned, change orders, and cost trends.
- Build and manage ETL workflows that extract, transform, and load data from multiple sources including NGCS, Primavera P6, SharePoint, SQL, and Excel.
- Automate recurring reporting processes and ensure dashboards update seamlessly with accurate, validated data.
- Develop standardized KPI templates for consistent performance tracking across projects and business units.
2. Data Analytics and Reporting
Analyze project data to identify trends, variances, and inefficiencies in cost, schedule, and labor performance.Generate weekly and monthly reports summarizing project health and forecasting results.Support project managers and leadership with predictive analytics tools that combine historical performance and real-time data .Collaborate with Prefabrication, Estimating, and Field Operations to quantify performance gains and measure improvement initiatives.3. Data Governance and Integration
Establish and maintain data standards, definitions, and governance protocols for all project reporting.Integrate construction management and financial systems into a centralized analytics environment .Work with IT to maintain secure, role-based access and ensure system reliability and data integrity.Troubleshoot data connectivity and accuracy issues between NGCS, Power BI, and other platforms.4. Stakeholder Engagement and Training
Collaborate with department leaders to define reporting needs and translate business questions into clear analytics solutions.Deliver training and guidance for project teams on interpreting dashboards and using analytics tools effectively.Present insights and recommendations to management using concise, executive-level visualizations.5. Continuous Improvement and Innovation
Continuously enhance data systems by identifying automation, integration, and AI opportunities.Research and implement emerging Power BI and AI / ML capabilities for advanced forecasting and risk analysis.Standardize and document reporting processes to improve scalability across regions and clients.Qualifications and Skills
Bachelor’s degree in Data Analytics, Computer Science, Construction Management, Engineering , or related field (preferred).3–5 years of experience developing Power BI dashboards , DAX measures , and SQL-based data models .Proficiency with Power Query (M language) , SQL , Excel (VBA / Macros a plus) , and relational database design.Familiarity with Primavera P6 , Procore , Viewpoint / Spectrum , or similar construction / project controls systems is highly desirable.Strong analytical and problem-solving abilities with a clear understanding of construction cost and schedule data.Excellent communication and documentation skills; ability to work independently in a fast-paced, team-oriented environment.Why Join The Newtron Group
At The Newtron Group, we combine decades of electrical construction experience with modern, data-driven systems to deliver exceptional results. Joining our team means contributing to one of the most advanced project management ecosystems in the industry — where your work directly enhances operational efficiency, forecasting accuracy, and decision quality across every level of the organization.