Data Modeling Analyst - Kansas City, MO

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

We are seeking a technically skilled Data Modeling Analyst to support our reporting and analytics platform within a Microsoft Fabric environment. This role is ideal for an individual with strong business intelligence and data analysis experience, particularly in SQL, with working knowledge of Python and Spark.

In the near term, this position will focus on developing and maintaining BI reporting solutions using an existing Microsoft Fabric semantic model. The successful candidate will work closely with business stakeholders to translate reporting requirements into meaningful dashboards, reports, and analytical insights that support operational and strategic decision-making.

Over time, this role will expand to include broader data modeling and platform responsibilities, supporting the development and optimization of enterprise data models, pipelines, and analytical solutions that improve the scalability, performance, and governance of our data ecosystem.

Key Responsibilities

• Develop, maintain, and enhance BI reports and dashboards using Microsoft Fabric and Power BI.
• Leverage existing semantic models to deliver scalable and consistent reporting solutions.
• Write, optimize, and troubleshoot SQL queries to support reporting and analytics needs.
• Collaborate with business users and technical teams to gather requirements and deliver actionable insights.
• Validate data accuracy and support data quality initiatives.
• Assist with the design and optimization of data models and reporting structures.
• Support future development of Python- and Spark-based data solutions and pipelines.
• Contribute to enterprise data and analytics initiatives as the platform matures.

Preferred Qualifications

• Strong SQL development and data analysis skills.
• Understanding of Lakehouse, Data Warehouse, ETL/ELT, and medallion architecture concepts
• Experience developing reports and dashboards in Power BI or similar BI tools.
• Familiarity with Microsoft Fabric semantic models and modern analytics platforms.
• Working knowledge of Python and Spark.
• Understanding of data modeling, data warehousing, and ETL/ELT concepts.
• Experience with Microsoft Report Builder (Paginated Reports) is a plus.
• Strong communication skills and the ability to work effectively across a multi-tiered organization.
• This position offers an opportunity to make an immediate impact through BI reporting while growing into a broader role supporting enterprise data modeling, analytics, and Microsoft Fabric platform development.

Nice To Have (not Required)

• MS Report Builder experience.

Education and Background

• Bachelor's degree: Data Science, Computer Science, Information Systems, or a related field.
• 2 years of professional experience in a development/data-related role

What We Can Offer You

• Inclusive Medical, Dental, Vision, Accident, and Illness insurance
• Company paid Disability and Life insurance
• Health Savings Account contribution of up to $1,000 per year
• 401(k) retirement savings program with a company match
• Employee Assistance Program including discounts with major vendors & products
• Mental and physical wellness programs
• Competitive time off package including vacation, sick, and holiday pay
• Career advancement opportunities with a stable well-established organization
• Tuition reimbursement program and access to LinkedIn Learning course
• Applications submitted without a resume will not be considered
• CSG does not accept unsolicited resumes from search firms or agencies. Any resume submitted to any employee of CSG without a prior written search agreement will be considered unsolicited and the property of CSG.

CSG is an Equal Opportunity Employer.

Qualified candidates will be considered without regard to race, sex, disability, veteran status, sexual orientation or gender identity.