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

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;
• Flexible work options, including remote and hybrid opportunities;
• Referral program for bringing in new talent;
• Work anniversary program and additional vacation days.