Medefy Health is a leading SaaS benefits navigation company dedicated to simplifying employee access to benefits. The Business Intelligence Engineer will serve as the BI subject matter expert, responsible for the discovery, design, development, and governance of BI data and processes across the organization, ensuring that business reporting needs are met with scalable and reliable analytics infrastructure.

Responsibilities:

Business Intelligence Strategy & Requirements
Lead discovery sessions with Product, Finance, Care Operations, Sales, and Leadership
Translate business questions into structured data requirements
Define and standardize data definitions
Maintain analytics documentation and metric dictionary
Identify data gaps and propose collection strategies
Analytics Architecture & Data Storage
Own analytics data storage strategy (primarily Snowflake)
Design and maintain dimensional models and data marts
Determine appropriate data storage across Snowflake, SQL Server, and Postgres
Define governance standards for reporting schemas
Ensure compliance with HIPAA and PHI handling requirements
Reporting Platform Ownership
Evaluate and select BI tools for internal and external reporting
Own BI Embedded architecture
Design customer-facing reporting solutions
Drive consolidation of reporting into Snowflake as the single source of truth
Support and maintain reporting APIs and analytics applications
Pipeline Development & Data Movement
Build and maintain analytics pipelines using dbt and ELT processes
Develop transformations to support reporting use cases
Collaborate with Data Engineering on data transport strategy
Define instrumentation needs for new product features
Support reverse ETL and data sync requirements
Data Governance & Security
Define role-based access models in Snowflake
Reduce over-privileged access and improve audit posture
Implement testing and monitoring on analytics models
Support Data Reliability Index (DRI) improvement initiatives
Cross-Functional Leadership
Serve as BI subject matter expert across the organization
Guide teams toward self-service analytics best practices
Improve analytics literacy across departments
Partner with Engineering on event tracking improvements

Requirements:

Experience leveraging Artificial Intelligence (AI) and machine learning concepts in analytics architecture and reporting, including the ability to evaluate AI-driven tools, incorporate AI-assisted data modeling and insight generation, and strategically apply AI to improve reporting automation, anomaly detection, and decision support across the organization
Advanced SQL across Snowflake, SQL Server, and Postgres
Strong dimensional modeling experience (star schema, data marts)
Experience with dbt and modern ELT/analytics engineering practices
Experience designing BI architecture and reporting ecosystems
Experience supporting embedded reporting tools
Strong communication skills and ability to translate business needs into technical solutions
Healthcare, claims, eligibility, or HIPAA-compliant data experience
Python or scripting experience

Medefy Health

Open Positions (1)

Data

Business Intelligence Engineer