Coherent Solutions is a digital product engineering company focused on empowering business success. Our global team of 1700+ talented professionals collaborate seamlessly to deliver innovative solutions that drive measurable business impact. Headquartered in Minneapolis, USA, the company’s core competencies across 10 locations worldwide include product software development, IT consulting, data and analytics, machine learning, mobile app development, DevOps, Salesforce, and more.

We grow a team of advisors, not just order takers, and strive to make the company a place for career growth and opportunities. If you want to grow your core competencies, share your passion and be sure that every contribution is evaluated, we are on the same page.

Company Background

Our client is a clinician-founded medical and behavioral health organization providing integrated mental health care across the United States. Founded in 2011, the company combines psychotherapy, psychiatry, and nutritional counseling through a telehealth-first hybrid care model, making high-quality behavioral health support more accessible. Its care model focuses on the whole person, helping clients address mental health challenges, improve relationships, support personal growth, and work toward healthier, more fulfilling lives.

Project Description

As part of this initiative, the team is building a modern cloud-based data platform to support operational reporting, executive dashboards, AI-powered analytics, and data-driven decision-making. The specialist will play a key role in designing and implementing scalable data models, data pipelines, and governed analytics datasets that serve as the foundation for business intelligence and advanced analytics across the organization.

Technologies

- Snowflake, SQL, dbt, Python
- Git, CI/CD
- Fivetran, Tableau
- AWS, Amazon S3, AWS Lambda
- Snowflake Native Apps
- Athenahealth, Salesforce

What You'll Do





- Develop and maintain dbt models across staging, intermediate, and mart layers;
- Convert ad hoc SQL queries into version-controlled dbt models and improve existing models for performance and readability;
- Build and maintain Snowflake task-based workflows, triggers, and dependency-aware data pipelines;
- Monitor pipeline execution, configure alerts, and resolve data processing issues;
- Implement data quality checks and reconciliation models across EHR, Salesforce, and billing systems;
- Investigate and resolve data inconsistencies, duplicate records, and issues with data relationships;
- Optimize analytical queries and support decisions related to warehouse sizing, clustering, and resource usage;
- Participate in Git workflows, code reviews, and CI/CD processes, and develop Python scripts for API integrations and file processing;

Job Requirements

- 8+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence Engineering, or a related role;
- Expert-level experience with Snowflake, including advanced SQL, query optimization, performance tuning, Tasks, Streams, warehouse optimization, and orchestration;
- Strong hands-on experience with dbt, including incremental models, snapshots, testing, documentation, and semantic modeling;
- Proficiency in Python for automation, API integrations, and data processing;
- Strong understanding of ETL/ELT, data warehousing, data modeling, and dimensional modeling;
- Experience with Git, CI/CD, and modern software development practices;




- Strong analytical and problem-solving skills, with a focus on scalability, performance, and data quality;
- English level: Upper-Intermediate or higher;
- Ability to maintain daily overlap with the US team until at least 12:30 PM Pacific Time;

Nice To Have

- Tableau: dashboard development, reusable data sources, performance optimization, dashboard UX, and Tableau Prep;
- Experience with Fivetran;
- Experience with data quality validation, reconciliation, and data governance practices;
- Experience with event-driven data architectures and AWS data services;
- Experience with Snowflake Cortex, LLM-powered analytics;
- Experience building AI-ready data architectures;
- Familiarity with Streamlit and Python-based data science or machine learning workflows;
- Experience in healthcare, payer, EMR/EHR, Revenue Cycle Management, CRM, or Athenahealth environments;
- Knowledge of healthcare interoperability standards, including FHIR and HL7;

What Do We Offer The global benefits package includes:

- Technical and non-technical training for professional and personal growth;
- Internal conferences and meetups to learn from industry experts;
- Support and mentorship from an experienced employee to help you professional grow and development;
- Health insurance;
- Sports activities to promote a healthy lifestyle;
- Versátil work options, including remote and hybrid opportunities;
- Referral program for bringing in new talent;
- Work anniversary program and additional vacation days.

If this opportunity excites you, send us your resume!

Please, note, that we will consider all the applications with due respect, but only shortlisted candidates will be contacted.

Please take your time to see Coherent Solutions Privacy Policy for Job Applicants for details on how we process your personal data: https://www.coherentsolutions.com/privacy-policy-for-job-applicants

📌 Analytics Engineer (Mental Health Care) (México)
🏢 Coherent Solutions
📍 México