Ortho Molecular Products · 2 days ago
Business Intelligence Analyst
Barrington, IL
Full-time
Onsite
Mid Level
$70K/yr - $80K/yr
3+ years expOrtho Molecular Products is dedicated to transforming the practice of medicine, and they are seeking a Business Intelligence Analyst to join their dynamic team. This role will focus on designing and delivering high-quality dashboards and data solutions that provide actionable insights across the organization, particularly during the transition to Microsoft Fabric in 2026.
Health Care
No H1B
Responsibilities
Develop, manage, and maintain data solutions and interactive dashboards using Power BI
Collaborate with business units to gather requirements and deliver data-driven insights that address key challenges
Build and adapt data models to support evolving reporting needs, optimizing for both performance and usability
Partner with BI developers and analysts to design efficient data flows and ensure high-quality report outputs
Write clear specifications and documentation for new and updated reports, ensuring accuracy through thorough testing
Support the transition of reporting from on-premises sources to Microsoft Fabric, leveraging the Fabric Data Lake as the primary data source
Seek opportunities to improve efficiency through automation and process improvements
Stay current with Power BI, Microsoft Fabric, and related BI technologies to bring forward best practices and innovative solutions
Qualification
Required
Bachelor's degree or 3 - 4 years of data analyst experience in a related field
Advanced experience using Microsoft Excel, SQL, Data warehouse
Strong understanding of Power BI and dashboarding tools
Demonstrated knowledge of creating/improving business processes
Ability to understand and perform business and functional requirement analysis
Strong mathematical skills for writing Excel formulas and applying statistical concepts
Proficiency in Power BI, Tableau, or similar visualization tools
Experience with SQL, DataMarts, PowerQuery, and PowerAutomate
Strong analytical and logical skills with meticulous attention to detail
Character qualities: thoroughness, dependability, orderliness, persistence and responsibility
Benefits
Health, Dental, Vision, Life, 401(k) with matching, HSA with company contribution.
Earn up to 15 paid days off annually.
Paid Holidays on business workdays.
Company-paid on-site wellness meals.
Gym membership reimbursement.
Employee Assistance Program.
Voluntary benefits: short-term disability, whole/term life, hospital indemnity, critical illness, accident expense.
Opportunities for growth and development such as company university and tuition reimbursement options.
On-staff health coach, one-on-one or group coaching.
Health and wellness initiatives: walking challenge, weight loss challenge, health risk assessment and more!
Company
Ortho Molecular Products
Ortho Molecular Products is an ortho molecular products in Woodstock.
201-500 employees
Funding
Current Stage
Growth StageRecent News
Company data provided by crunchbase