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

What We Can Offer You :

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.

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.