Note: The job is a remote job and is open to candidates in USA. Mindex is a company that has been providing solutions in custom software, cloud, data, and AI for over 30 years. They are seeking a Data Engineer to join their data platform team, responsible for building and maintaining data pipelines and transformations using SQL and DBT in Snowflake, while ensuring data quality and clarity in communication.
Responsibilities
- Build and maintain DBT models (Core), including models, tests, macros, and lineage documentation
- Design and optimize Snowflake objects, dynamic tables, views, and schemas, for performance and clarity
- Develop and support data ingestion pipelines using tools such as Informatica, Fivetran, or Openflow
- Profile and analyze source data from complex, multi-domain systems (HRIS, payroll, client platforms) to surface quality issues and inform modeling decisions
- Write advanced SQL to investigate data, validate transformations, and answer ad hoc business questions
- Collaborate with data architects to implement canonical data models and ensure consistency across domains
- Document data quality findings, transformation logic, and modeling decisions in a clear and defensible way
Skills
- 3+ years of hands-on experience with advanced SQL
- 2+ years of experience with DBT Core (models, tests, macros, sources, lineage)
- 2+ years of experience with Snowflake (dynamic tables, views, performance tuning, schema design)
- Experience with data ingestion/replication tooling such as Informatica, Fivetran, or Openflow
- Demonstrated ability to profile and analyze source data from complex or poorly documented systems
- Proficiency in Python for data processing and pipeline support
- BS degree in Computer Science, Data Science, Engineering, or equivalent experience
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
Company Overview