Description
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;
- Flexible work options, including remote and hybrid opportunities;
- Referral program for bringing in new talent;
- Work anniversary program and additional vacation days.
Similar jobs
Est. 120,000 PLN
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, psych…
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, psych…
Est. 84,000 PLN
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, psych…
Company Background Our client is a U.S.-based fintech company providing financing solutions to small and medium-sized businesses. Founded in 2006, the company operates as both a direct lender and a financing marketplace,…
Company Background Our client is a U.S.-based fintech company providing financing solutions to small and medium-sized businesses. Founded in 2006, the company operates as both a direct lender and a financing marketplace,…
About Workato Workato delivers enterprise infrastructure for the agentic era, redefining iPaaS and helping enterprises unify data, applications, processes, and AI into a single, governed platform. A leader in Enterprise…
Est. 120,000 PLN
Company Background Our client is a U.S.-based fintech company providing financing solutions to small and medium-sized businesses. Founded in 2006, the company operates as both a direct lender and a financing marketplace,…
Est. 120,000 PLN
Company Background Our client is a global leader in access solutions and smart home technologies. With over a decade of innovation in the IoT space, the company is a pioneer in connected home solutions, including garage…
Est. 80,000 EUR
About This Role: We're looking for a Senior, dbt-specialised Analytics Engineer to build and maintain the business-critical data models behind the client's credit, payments, and fraud/AML reporting. Our client is a fast-…
Est. 215,000 USD
Why Charlie Health? Millions of people across the country are navigating mental health conditions, substance use disorders, and eating disorders, but too often, they’re met with barriers to care. From limited local optio…
Project Description We are looking for an experienced Data Engineer with deep expertise in Databricks to join our advanced analytics and data engineering team. The ideal candidate will play a key role in designing, build…
Join an exciting journey to create a cutting-edge Consumer Data Lake for a leading global organization based in Europe. This platform will unify, process, and leverage consumer data from various systems, unlocking advanc…
Est. 120,000 PLN
Join an exciting journey to create a cutting-edge Consumer Data Lake for a leading global organization based in Europe. This platform will unify, process, and leverage consumer data from various systems, unlocking advanc…
Est. 215,000 USD
Why Charlie Health? Millions of people across the country are navigating mental health conditions, substance use disorders, and eating disorders, but too often, they’re met with barriers to care. From limited local optio…
Est. 60,000 USD
Are you ready to shape the future of fintech with cutting-edge technology and deep regional impact? Join us as a Data Engineer and help power our next-generation platform for multi-country cloud analytics and consumer fi…
Project Description We are looking for a motivated Data Engineer to join our growing data team. This is a great opportunity for someone early in their career to gain hands-on experience with modern data technologies. You…
Est. 55,000 EUR
Responsibilities Create and maintain reporting and analytical dashboards that provide key business insights Search for insights and patterns through data analysis Based on the analysis results, make conclusions for the b…
Est. 140,000 USD
Theoria Medical is a comprehensive medical group and technology company dedicated to serving patients across the care continuum, with a strong focus on the post-acute care setting. We partner with facilities nationwide t…
KnowBe4 empowers the modern workforce to make smarter security decisions every day. Trusted by more than 70,000 organizations worldwide, KnowBe4 is the pioneer of digital workforce security, securing both AI agents and h…
Est. 119,270 USD
Join PatientPoint to be part of a dynamic team creating change in and around the doctor’s office. As a leading digital health company, we innovate to positively impact patient behaviors. Our purpose-driven approach offer…
Company Background Our client is a leading global provider of advanced analytics, technology solutions, and clinical research services for the life sciences industry. The company combines large-scale healthcare data with…
Emergent builds autonomous coding agents that replace traditional software development by generating, testing, and deploying production applications directly from plain-language intent. Our systems run in production at g…
Company Background Our client is a global technology company transforming the way brands and agencies make marketing decisions. Its platform enables marketers to plan and activate cross-channel, programmatic media campai…
Emergent builds autonomous coding agents that replace traditional software development by generating, testing, and deploying production applications directly from plain-language intent. Our systems run in production at g…
Est. 180,000 USD
About the role Thatch is rewiring how health benefits work. We build software that gives employees real control over how they use their benefits. We're looking for a Data Scientist to help Thatch make better product, com…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Caylent is an AI-first cloud services company that helps organizations turn ambitious ideas into meaningful business impact. As an AWS Premier Tier Services Partner and a charter member of Anthropic’s Claude Partner Netw…
Why Housecall Pro? Help us build solutions that build better lives. At Housecall Pro, we show up to work every day to make a difference for real people: the home service professionals that support America’s 100 million h…
Why Join Exadel We’re an AI-first global tech company with 25+ years of engineering leadership, 2,000+ team members, and 500+ active projects powering Fortune 500 clients, including HBO, Microsoft, Google, and Starbucks.…