Remote Open Source Intelligence Jobs in Rochester, NY

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.

$120,000 - $173,000

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