Data Architect

About the Role

Mindex is looking for a Data Architect who thrives on solving complex data challenges and transforming information from multiple source systems into scalable, well-structured data solutions. In this role, you will design and maintain the canonical data model for a large-scale Snowflake data platform, bringing together data from HRIS, payroll, client systems, and other domains into a consistent, reusable framework that supports analytics, reporting, artificial intelligence, and other data-driven initiatives.

What You'll Accomplish

• Lead and mentor a team of data engineers, providing technical direction, coaching, and support for their professional development
• Design and own the canonical/common data model that normalizes disparate source schemas into a unified structure across ~10 data domains
• Conduct source-system data profiling and analysis to understand domain-specific data, identify quality issues, and inform modeling decisions
• Build conceptual, logical, and physical data models using dimensional and normalized modeling techniques
• Design and implement Snowflake-specific modeling patterns, including slowly-changing dimensions (SCDs), dynamic tables, and entity resolution strategies (e.g., "Common Worker" across HRIS and payroll systems)
• Collaborate with data engineers to ensure models are implemented correctly and perform well in Snowflake
• Document and justify all modeling decisions clearly for stakeholders — your rationale is as important as the model itself

Required Qualifications

• 5+ years of experience in data architecture, data modeling, or a closely related role
• Prior experience leading or mentoring a team of data engineers or similar technical contributors
• Deep expertise in dimensional and canonical data modeling — normalizing disparate schemas into a unified structure
• Hands-on experience with Snowflake modeling patterns (dynamic tables, views, schema design, performance)
• 3+ years of hands-on experience with advanced SQL
• Proven ability to perform source-system data profiling and analysis across complex, multi-domain environments
• Experience with slowly-changing dimensions (SCDs) and entity resolution across systems
• BS degree in Computer Science, Data Science, Engineering, or equivalent experience

Why Join Mindex?

For more than 30 years, Mindex has helped organizations solve complex business challenges through custom software, cloud, data, and AI solutions. We combine deep technical expertise with a collaborative culture that empowers our employees to innovate, grow, and make a meaningful impact for our clients. In our Product division, our teams have built platforms such as SchoolTool, Advanced Analytics, and our Integrations Platform from the ground up, while also supporting solutions like MTSS Edge and ClearTrack that help schools and organizations make smarter, data-driven decisions.

Benefits

• Fully Remote Work Environment
• Flexible Time Off
• Medical, Dental, and Vision Insurance
• 401(k) with Company Match
• Company-Paid Life and Disability Insurance
• Professional Development Opportunities

Pay

$120,000 - $173,000