Job Description

Location: Westerville

Employment Type: Full time

About the Role

Were looking for a data-driven and detail-oriented Business Intelligence Analyst to help us turn complex construction data into clear, actionable insights. In this role, you'll design, build, and maintain compelling dashboards and visualizations using Power BI (or similar BI tools) to support field operations, project management, and executive decision-making across our construction portfolio.

Youll work closely with data engineers, product managers, and business stakeholders to translate raw data into clear, actionable insights. This is a great opportunity for someone with a strong analytical mindset and a passion for presenting data in intuitive and impactful ways.

Key Responsibilities

• Develop and maintain interactive dashboards in Power BI, or similar tools, to track construction KPIs, including cost performance, schedule adherence, productivity, safety metrics, and resource utilization.
• Write and optimize DAX expressions to support calculated columns, measures, and KPIs.
• Collaborate with project managers, superintendents, and operations leads to define reporting requirements and deliver user-friendly insights.
• Build and refine SQL queries to extract data from various systems (e.g., ERP, project management software, field data collection tools).
• Ensure data quality and consistency across all reports and dashboards.
• Support ad hoc analysis and help non-technical users interpret and use data effectively.
• Work with data engineers to improve data models and pipelines for reporting purposes.
• (Bonus) Experience with Palantir Foundry to integrate data sources and create operational workflows and visualizations.

Qualifications

Required:

• 25 years of experience in data analysis, business intelligence, or a related role.
• Proficiency in Power BI, including DAX and Power Query (M).
• Strong SQL skills and understanding of relational data models.
• Experience translating business needs into technical solutions, especially within project-based industries like construction.
• Excellent communication and collaboration skills across technical and non-technical teams.

Preferred:

• Prior experience in the construction industry or adjacent sectors (e.g., engineering, infrastructure, manufacturing)
• Familiarity with data modeling concepts and best practices.
• Exposure to data governance, performance tuning, or data pipeline development.

Job Tags

Similar Jobs