Senior Healthcare Analytics Consultant - Remote

Primary Responsibilities

• Design, develop, and maintain stored procedures, views, and queries using Snowflake and modern data tools
• Build and optimize data models to support analytics, reporting, and downstream applications
• Develop robust data ingestion frameworks for structured and semi-structured data
• Ensure data quality, integrity, and reliability through validation and monitoring processes
• Write efficient queries and implement performance tuning strategies in Snowflake
• Work with healthcare datasets such as authorizations, referrals, claims, provider, member, and clinical data
• Ensure compliance with HIPAA and other healthcare data regulations
• Support data standardization and mapping (e.g., CPT, Diagnosis, Provider, Member, etc.)
• Collaborate with business stakeholders to translate healthcare requirements into technical solutions
• Assist in designing scalable, cloud-based data architectures
• Contribute to best practices around data modeling, governance, and pipeline design
• Collaborate with data architecture, warehouse, and operations teams to ensure data is put to action
• Document data pipelines, models, and architecture clearly
• Participate in code reviews and promote engineering best practices

Required Qualifications

• 2+ years of experience in data engineering, data development, data analytics or similar role
• Experience building ETL/ELT pipelines (e.g., dbt, Informatica, Airflow, Azure Data Factory, or similar)
• Experience with data visualizations and setting up models within these environments (PBI, Excel, etc.)
• Understanding of data warehousing concepts (star schema, dimensional modeling)
• Advanced SQL skills (window functions, query optimization, complex joins)

Preferred Qualifications

• 2+ years of Healthcare analytics experience
• Snowflake experience