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.
Compensation$120,000 - $173,000
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)
- 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
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
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
Applicants must be authorized to work for any employer in the United States. Mindex is unable to sponsor employment visas at this time.
Physical Requirements/Conditions:
Prolonged periods sitting at a desk and working on a computer
No heavy lifting is expected. Exertion of up to 10 lbs.
Skills Required
- BS degree in Computer Science, Data Science, Engineering, or equivalent experience
- 8+ years of progressive experience in data engineering or architecture
- 5+ years hands-on with modern data platforms (Snowflake, Databricks, Spark)
- Strong experience (5+ years) in Python, SQL, PySpark, or R
- 3+ years designing cloud-based data architectures, preferably on Microsoft Azure
- Experience with CI/CD, DevOps, and infrastructure-as-code practices
What We Do
Mindex is an industry leader in software applications and development in Rochester, New York. For more than 25 years, Mindex has delivered on the needs of a variety of customers to achieve their goals through proven technologies, software, and services. Mindex specializes in software development for large enterprise clients in the Rochester, NY area and for New York State K-12 schools. We are a rapidly growing organization expanding heavily into cloud app. development and modernizing our home-grown K-12 Student Management System, SchoolTool. SchoolTool leads the way as the most trusted web-based student management system in New York State. Designed specifically to meet NYS requirements and school districts, it provides secure access to real-time data and time-saving tools for K-12 school administrators, faculty, staff, and parents. Awards and Accolades: #1 Software Developer, 2022 - RBJ Book of Lists A Top 100 Company (#48) - The Greater Rochester Chamber of Commerce #1 Best Company - 2019 RBJ Reader Rankings Best Company Culture (top three winner) - 2019 RBJ Reader Rankings Our Mission - With the brightest minds, unparalleled dedication, a passion for creating solutions, and thoughtful execution, we collaborate with our customers to achieve their goals through proven technologies, software, and services. Our Vision - We will anticipate tomorrow’s challenges, inspire innovation, and cultivate relationships to create solutions. We are committed to connecting people, teams, and communities to make a difference and give back. Our Values - Innovation, Collaboration, Excellence, Trust, Gratitude
