Mindex is looking for a Data Engineer with strong SQL and data analysis instincts to join a growing data platform team. In this role, you'll build and maintain data pipelines, models, and transformations in Snowflake using DBT and turn raw, messy source data into reliable, analysis-ready datasets.
The single most important skill for this role is data analysis ability: the capacity to dig into unfamiliar source systems, understand what the data means, surface data quality issues, and make well-reasoned decisions about how to model and use it. Strong communication skills are equally important. You'll need to document your findings and decisions clearly for both technical and non-technical audiences.
$90,000 - $140,000
- 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
Requirements
- 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
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
- 4+ years working with SQL, Snowflake, Databricks, Spark and other big data technologies
- 4+ years using Python, SQL, PySpark, R or similar languages
- 4+ years building and optimizing data pipelines and architectures
- 2+ years supporting large-scale data processing using Azure Data Factory, Integration Runtime, Data Lake
- 2+ years addressing privacy, compliance, and security aspects of data processing
- 2+ years with CI/CD methodologies and tools
- 2+ years with Salesforce FSC and Salesforce Data Cloud
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
