Business intelligence analyst

Job Description

A client of Insight Global is looking for a Business Intelligence Analyst to join their team in Columbus, Ohio. This person will 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.

You'll 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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and Requirements

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