Job Description

We are seeking a talented Business Intelligence Analyst to join our dynamic team. This role will focus on designing and delivering high-quality dashboards and data solutions that provide actionable insights across the organization. While today’s reporting leverages on-premises data sources, we will be transitioning to Microsoft Fabric in 2026, moving our data warehouse into the Fabric Data Lake. The Power BI Developer will play a key role in ensuring a smooth transition by building reporting solutions that align with both current practices and future architecture. Embrace the opportunity to innovate, collaborate, and make a meaningful impact.

This is an onsite position Monday through Friday from 8:00am to 5:00pm in Stevens Point, WI. or Barrington, IL.

What to Expect:

• 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.

What You Will Contribute:

• 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

What You Will Receive:

• The salary range for this position is $70,000 - $80,000 per year, depending on experience and qualifications.
• 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!

Why Work at Ortho Molecular Products:

Simply put, our healthcare system is broken. It is expensive, complicated, and dysfunctional. At Ortho Molecular Products, our vision is to transform the practice of medicine Every day, across America and the world, we help health care providers implement better solutions for health challenges that include lifestyle medicine and nutritional therapies proven to improve patient outcomes. We do this by manufacturing science-based products and developing innovative clinical programs for doctors that help their patients get better faster.

We are looking for people who align with our mission and want to invest their lifework and passion into transforming the practice of medicine. Our team is purpose-driven, values-based, and service-focused. We are looking for likeminded people who want to join the movement that is changing the way healthcare is being delivered.

Ortho Molecular Products is an Equal Opportunity Employer.

Ortho Molecular Products participates in E-Verify+ to verify Employment Eligibility.

Applicants must be legally authorized to work for ANY employer in the US.

Ortho Molecular Products will use E-Verify where required.

We invite you to explore the Ortho website to learn about our career opportunities and apply (www.orthomolecularproducts.com).

Join us in our mission to revolutionize healthcare and empower clinicians to make a difference!

#bianalyst