Business Intelligence Engineer

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