Data Modeling & BI Analyst (SQL, Power BI, Fabric)

Construction Solutions Group; Kansas City (MO); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with match

Tuition reimbursement

Job summary

Construction Solutions Group seeks a Data Modeling Analyst to support BI reporting within a Microsoft Fabric environment. You will translate requirements into dashboards and insights, collaborating with stakeholders to enable data-driven decisions.

Initially focused on BI reporting and semantic models, the role will grow to include broader data modeling, pipelines, and governance across the data ecosystem.

Qualifications

• Bachelor's degree in data science, CS, IS or related field.
• 2 years of professional development/data experience.
• Strong SQL, data analysis and BI reporting skills.

Responsibilities

• Develop, maintain, and enhance BI reports and dashboards using Microsoft Fabric and Power BI.
• Write, optimize, and troubleshoot SQL queries for reporting needs.
• Collaborate with stakeholders to translate requirements into insights.
• Validate data accuracy and support data quality initiatives.
• Design and optimize data models and reporting structures.
• Support Python- and Spark-based data solutions and pipelines.
• Contribute to enterprise data and analytics initiatives as the platform matures.

Skills

SQL development

Data analysis

BI reporting

Python basics

Spark basics

Power BI

Stakeholder collaboration

Microsoft Fabric

Education

Bachelor's degree in Data Science / Computer Science / Information Systems

Tools

Microsoft Fabric semantic models

Power BI

Paginated Reports (Report Builder)

SQL tooling

Job description

Construction Solutions Group seeks a Data Modeling Analyst to support BI reporting within a Microsoft Fabric environment. You will translate requirements into dashboards and insights, collaborating with stakeholders to enable data-driven decisions.

Initially focused on BI reporting and semantic models, the role will grow to include broader data modeling, pipelines, and governance across the data ecosystem.