Data Modeling Analyst - Kansas City, MO

Ultipro; Kansas City (MO); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with company match

HSA contribution up to $1,000/year

Employee Assistance Program

Job summary

Construction Solutions Group is seeking a technically skilled Data Modeling Analyst to support our BI reporting and analytics platform in a Microsoft Fabric environment. You will translate requirements into dashboards and insights, focusing on SQL-driven reports and scalable data models.

In the near term, you will enhance BI solutions with Fabric semantics and Power BI, collaborating with stakeholders to deliver actionable analytics for operations and strategy.

Qualifications

• Strong BI and data analysis experience, especially SQL, with working knowledge of Python and Spark.
• Translate reporting requirements into meaningful dashboards, reports and insights for operations and strategy.
• Experience with data modeling, data warehousing and ETL/ELT concepts and modern analytics platforms.

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 Python- and Spark-based data solutions and pipelines.
• Contribute to enterprise data and analytics initiatives as the platform matures.

Skills

SQL

Python

Spark

Power BI

Microsoft Fabric

Data modeling

ETL/ELT

Education

Bachelor's degree in Data Science, Computer Science, Information Systems or related field

Tools

Power BI

Microsoft Fabric semantic models

SQL tooling / IDEs

Job description

Construction Solutions Group
Kansas City, MO 64153, USA

• Information Technology
• Full-Time
• Requisition #: DATAM013566

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)

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.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.