BI Developer (Mental Health Care)

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, Tableau
• dbt, Python, Fivetran
• Snowflake Native Apps
• AWS, Amazon S3, AWS Lambda
• Athenahealt, Salesforce

What You'll Do

• Build and maintain production Tableau dashboards using Snowflake data sources, translating stakeholder requirements into wireframes and production-ready workbooks for executive, operational, and analyst audiences;
• Create certified and reusable Tableau data sources based on curated Snowflake data marts, selecting between live connections and extracts and managing extract refresh schedules;
• Write and optimize SQL for custom Tableau data sources, moving data processing and aggregation to Snowflake where appropriate;
• Analyze dashboard performance using Tableau Performance Recorder and optimize workbooks to improve load times;
• Publish dashboards and data sources to Tableau Cloud or Tableau Server, managing projects, permissions, subscriptions, alerts, and data source certification;
• Conduct requirements intake sessions with operations, finance, and clinical leadership and translate business needs into effective BI solutions;
• Incorporate stakeholder feedback, conduct dashboard walkthroughs, and provide light user enablement;
• Document metric definitions, dashboard logic, and usage guidelines;

Job Requirements

• 8+ years of experience developing enterprise Business Intelligence and analytics solutions;
• Expert-level experience with Tableau, including dashboard development, performance optimization, reusable data source development, and Tableau Cloud/Server administration;
• Strong understanding of BI user experience, dashboard design, and data storytelling;
• Advanced SQL skills, including the development and optimization of custom Tableau data sources;
• Experience working with Snowflake as a reporting and analytics platform;
• Ability to translate business requirements into intuitive dashboards, KPIs, and executive reporting;
• Strong communication and stakeholder management skills;
• 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

• Experience with dbt, analytics engineering workflows, and data modeling, including dimensional modeling;
• Experience optimizing Snowflake queries and data pipelines, including performance tuning;
• Experience with Python scripting for automation and data processing, Python-based data science or ML-workflows;
• Familiarity with Streamlit for developing internal analytics applications;
• Experience with Fivetran;
• Experience with Tableau Prep;
• 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;
• Experience in healthcare, payer, EMR/EHR, Revenue Cycle Management, CRM, or Athenahealth domains;
• 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.