Data Architect - Remote
About The Position
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.
Requirements
- 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
Responsibilities
- 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
Benefits
- Medical, Dental, and Vision Insurance
- 401(k) with Company Match
- Company-Paid Life and Disability Insurance
- Professional Development Opportunities
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
