Construction Solutions Group
Data Modeling Analyst - Kansas City, MO
Construction Solutions Group, Kansas City, Missouri, United States, 64101
Overview
Data Modeling Analyst - Kansas City, MO at Construction Solutions Group. This role supports the Business Intelligence/Data Analytics team, focusing on SQL development and Microsoft Report Builder to back backend reporting infrastructure and data workflows. The position is based in our Kansas City corporate office with 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 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; perform other duties as assigned to support organizational goals. Minimum Qualifications
Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, with at least 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 related modeling concepts. 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 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 without a prior written search agreement will be considered unsolicited and the property of Construction Solutions Group. Equal Opportunity Employer
Construction Solutions Group is an Equal Opportunity Employer. Qualified candidates will be considered without regard to race, sex, disability, veteran status, sexual orientation or gender identity.
#J-18808-Ljbffr
Data Modeling Analyst - Kansas City, MO at Construction Solutions Group. This role supports the Business Intelligence/Data Analytics team, focusing on SQL development and Microsoft Report Builder to back backend reporting infrastructure and data workflows. The position is based in our Kansas City corporate office with 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 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; perform other duties as assigned to support organizational goals. Minimum Qualifications
Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, with at least 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 related modeling concepts. 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 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 without a prior written search agreement will be considered unsolicited and the property of Construction Solutions Group. Equal Opportunity Employer
Construction Solutions Group is an Equal Opportunity Employer. Qualified candidates will be considered without regard to race, sex, disability, veteran status, sexual orientation or gender identity.
#J-18808-Ljbffr