Data Modeling Analyst - Kansas City, MO

Role Overview

We are seeking a technically skilled Data Modeling Analyst to join our Business Intelligence/Data Analytics team, supporting our backend reporting infrastructure and data workflows. This role is ideal for someone who excels in SQL development and specifically Microsoft Report Builder.

The successful candidate will be responsible for building and maintaining SQL-based solutions, optimizing data models, and enabling scalable reporting systems that support business operations and decision-making. While SQL and Microsoft Report Builder are the primary focus, this role also includes developing, maintaining, and supporting a broad range of data analytics reporting. This position is based in our Kansas City corporate office and enjoys a hybrid work schedule.

Primary Responsibilities

• Build and optimize paginated reports using Microsoft Report Builder.
• Design, implement, and maintain SQL-based queries, tables, user-defined functions, and stored procedures to support robust data extraction, transformation, and loading (ETL) workflows.
• Support backend Power BI development, including dataset creation and DAX measures.
• Ensure data quality, consistency, and performance across systems.
• Document data sources, transformation logic, and reporting standards.
• Contribute to special projects and cross-functional initiatives, as well as perform other duties as assigned in support of the overall goals and efficiency of the organization.

Minimum Qualifications

• Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, with a minimum of 2 years of professional experience in data modeling, analysis, reporting, or a related development/data-focused role
• Experience with Microsoft Report Builder and SSRS.
• Proficiency in SQL query language including joins, CTEs, indexing, and performance tuning.
• Solid understanding of data modeling, ETL processes, data warehousing, Power BI and Symantec model building based on multiple sources
• Advanced Excel skills for ad-hoc analysis and validation.
• Strong communication and documentation skills.
• Familiarity with Azure SQL Database or other cloud-based data platforms.
• Prior experience with Azure data services (Data Factory, Synapse, SQL, DB) and Microsoft Power BI, Dax, and/or Python preferred.

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 without an attached resume will not be considered. 

**Construction Solutions Group does not accept unsolicited resumes from search firms or agencies. Any resume submitted to any employee of Construction Solution Group without a prior written search agreement will be considered unsolicited and the property of Construction Solution Group. 

Construction Solution Group is an Equal Opportunity Employer.

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