Data Modeling Analyst - Kansas City, MO
Construction Solutions Group
Develop and optimize SQL queries and Microsoft Report Builder reports for BI.
22 days ago ago
Intermediate (4-7 years), Junior (1-3 years)
Full Time
Kansas City, MO
Hybrid
Company Size
2,500 Employees
Service Specialisms
Construction services
Project Management
Consulting
Engineering
Architecture
Property Development
Design
Technical Services
Sector Specialisms
Commercial
Healthcare
Institutional
Residential
Industrial
Owner's Representation
Program Management
Construction Administration
Role
What you would be doing
power bi
sql development
etl workflows
paginated reports
data documentation
data quality
- Support backend Power BI development, including dataset creation and DAX measures.
- Design, implement, and maintain SQL-based queries, tables, user-defined functions, and stored procedures to support robust data extraction, transformation, and loading (ETL) workflows.
- Build and optimize paginated reports using Microsoft Report Builder.
- Document data sources, transformation logic, and reporting standards.
- Ensure data quality, consistency, and performance across systems.
What you bring
sql
power bi
azure
excel
bachelor’s
communication
- Solid understanding of data modeling, ETL processes, data warehousing, Power BI and Symantec model building based on multiple sources
- 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
- Proficiency in SQL query language including joins, CTEs, indexing, and performance tuning.
- Familiarity with Azure SQL Database or other cloud-based data platforms.
- Advanced Excel skills for ad-hoc analysis and validation.
- Prior experience with Azure data services (Data Factory, Synapse, SQL, DB) and Microsoft Power BI, Dax, and/or Python preferred.
- Experience with Microsoft Report Builder and SSRS.
- Strong communication and documentation skills.
- Inclusive Medical, Dental, Vision, Accident, and Illness insurance
- Tuition reimbursement program and access to LinkedIn Learning course
- Mental and physical wellness programs
- Employee Assistance Program including discounts with major vendors & products
- Company paid Disability and Life insurance
- Health Savings Account contribution of up to $1,000 per year
- Career advancement opportunities with a stable well-established organization
- 401(k) retirement savings program with a company match
- Competitive time off package including vacation, sick, and holiday pay
Information not given or found
Interview process
Information not given or found
Visa SponsorshipInformation not given or found
Security clearanceInformation not given or found
People also searched
Data Engineer Jobs in Kansas City United StatesData Analytics Jobs in Kansas City United StatesData Scientist Jobs in Kansas City United StatesBusiness Analytics Jobs in Kansas City United StatesData Analyst Jobs in Kansas City United StatesBusiness Analyst Jobs in Kansas City United StatesBI Developer Jobs in Kansas City United StatesBI Analyst Jobs in Kansas City United States
Company
Overview
Founded 2010
Year Established
Begun in 2010, the company has grown from its founding to become a multi-service provider.
2024 ERP Launch
Dynamics 365 Rollout
In 2024, the company introduced Dynamics 365 ERP to enhance project management and efficiency.
- Born from The Heico Companies legacy, CSG weaves a story of small‑business culture backed by large‑scale capability across North America.
- Operating across the U.S. and Canada, it tackles both commercial build‑outs and heavy industrial projects like refinery piling and marine work.
- Flagship units include Ceco Concrete’s formwork expertise, Zalk Josephs’ structural steel fabrication, KenMor’s electrical contracting, and Titan’s shoring rentals.
- CSG thrives on complexity—delivering deep foundations, shoreline stabilization, high‑profile concrete framing, and large‑scale equipment logistics.
- We are driven by a culture of collaboration, innovation, and delivering high-quality solutions.
- We foster an environment of respect, integrity, and trust with our clients and colleagues.
- We prioritize safety in every project we undertake, ensuring a secure and efficient workplace.
- We support professional development and personal growth through ongoing training and mentorship.
- We promote a work-life balance and provide opportunities for flexible working arrangements.
2030
Net Zero Target
The company is committed to achieving net zero emissions by this year.
- The company is committed to reducing environmental impact by focusing on energy efficiency and sustainable practices.
- Sustainable materials and green technologies are utilized in all projects to minimize waste and reduce carbon footprint.
- Regular measurement and tracking of sustainability performance ensure continuous improvement.
- Clients and partners are engaged to promote environmental awareness and adopt best practices.
- Creating a workplace that values inclusion and diversity.
- Providing equal opportunities and fostering a culture of respect.
- Continuing to increase the number of women in leadership roles.
- Offering programs and initiatives to support the professional growth of underrepresented groups.
Articles
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio