Mindex is seeking a Data Platform Engineer to design, build, and optimize scalable data solutions that support analytics, reporting, and business decision-making. In this role, you'll work across complex data domains to develop robust data models, build ingestion pipelines, and ensure data quality throughout the data lifecycle.
Responsibilities:
- Design, develop, and optimize Snowflake objects, including dynamic tables, views, and schemas
- Build and maintain DBT Core models, including models, tests, macros, sources, and lineage documentation
- Develop and support data ingestion and replication pipelines using tools such as Informatica, Fivetran, Openflow, or similar technologies
- Profile and analyze source data from complex, multi-domain systems to identify quality issues and inform modeling decisions
- Write advanced SQL to investigate data, validate transformations, and support business reporting and analytics needs
- Collaborate with data architects to implement canonical data models and ensure consistency across business domains
Requirements:
- 2+ years of experience with Snowflake, including dynamic tables, views, performance tuning, and schema design
- 3+ years of hands-on experience with advanced SQL
- 2+ years of experience with DBT Core, including models, tests, macros, sources, and lineage
- Experience with data ingestion and replication tools such as Informatica, Fivetran, Openflow, or similar technologies
- Experience working with complex, poorly documented, or multi-source datasets and identifying data quality issues
- Proficiency in Python
- Bachelor's degree in Computer Science, Data Science, Engineering, or equivalent professional experience
- Experience implementing dimensional, canonical, or enterprise data models
- Experience with data lineage, metadata management, or data quality frameworks
- Experience supporting modern analytics platforms built on Snowflake and DBT
- Experience working with enterprise HR, payroll, financial, or customer data domains