What are the responsibilities and job description for the Data Modeling Analyst - Kansas City, MO position at Construction Solutions Group (CSG)?
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)
- MS Report Builder experience.
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.
Salary : $1,000