Business Intelligence Engineer
About The Position
The Business Intelligence Engineer will serve as Medefy’s BI subject matter expert within the Data team. This role owns the discovery, design, development, and governance of Business Intelligence data and processes across the organization. This position bridges business strategy and technical implementation ensuring that business reporting needs are translated into scalable, secure, and reliable analytics infrastructure. About our awesome company, Medefy Health... Medefy Health (www.Medefy.com) is a leading SaaS benefits navigation company, dedicated to simplifying the way employees’ access and utilize their benefits. Our mission is to drive better health and financial outcomes for our users while supporting HR teams and broker partners with seamless, data-driven solutions. Our company is headquartered in Tulsa, OK. We’re proud to be Oklahoma’s #1 fastest-growing company and rated by Inc. Magazine as the 37th fastest-growing tech company and the 288th fastest-growing company overall in the USA, and our story is still being written! Healthcare is only getting more complicated, and more expensive, for employers and their employees. This is where Medefy Health comes in. We’re on a mission to eliminate the stress on hard-working families caused by an impossible to navigate healthcare system. All while saving them, and their employers, a significant amount of time and money. We demolish barriers between healthcare and the people who need it, and we need your help to further our mission!
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
Nice To Haves
- Healthcare, claims, eligibility, or HIPAA-compliant data experience preferred
- Python or scripting experience preferred
- Strong communication skills and ability to translate business needs into technical solutions
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
- 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
- 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
- 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
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
