Data Architect - Remote

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. You will also lead and mentor a team of data engineers, guiding their technical growth and ensuring alignment with the broader data strategy., + 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)

• Partner closely with your team of 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

• 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)

• Strong proficiency in 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

$120,000 - $173,000, + Fully Remote Work Environment

• Flexible Time Off

• Medical, Dental, and Vision Insurance

• 401(k) with Company Match

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.