Business Intelligence Analyst - Stevens Point, WI

UNAVAILABLE; Stevens Point (WI); On-site; USD 70,000 - 80,000; Full time

Benefits offered by this job

Health, Dental, Vision, Life

401(k) with matching

HSA with company contribution

Paid holidays

On-site wellness meals

Gym membership reimbursement

Employee Assistance Program

Voluntary benefits

Job summary

Ortho Molecular Products seeks a skilled Business Intelligence Analyst to design and deliver dashboards and data solutions that drive actionable insights across the organization.

The role will support transitioning reporting from on-premises sources to Microsoft Fabric, with emphasis on creating efficient data flows and high-quality outputs. On-site in Stevens Point, WI, 8:00am–5:00pm, Monday–Friday.

Qualifications

• Bachelor’s degree or 3-4 years of data analyst experience in a related field.
• Strong understanding of Power BI and dashboarding tools.
• Advanced experience using Microsoft Excel, SQL, Data warehouse.
• 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.
• Certifications related to Microsoft Fabric are preferred.
• Character qualities: thoroughness, dependability, orderliness, persistence and responsibility

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.

Skills

Power BI

SQL

Excel

Data warehouse

DataMarts

PowerQuery

PowerAutomate

Tableau

Microsoft Fabric

Education

Bachelor’s degree

Tools

Power BI

Tableau

Excel

SQL

PowerQuery

PowerAutomate

Job description

Overview

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 Business Intelligence Analyst 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 position is 100% on-site Monday through Friday from 8:00am to 5:00pm in Stevens Point, WI.

This position requires candidates to be authorized to work in the U.S.A. without the need for visa sponsorship.

Application Deadline (Estimated): Applications will be accepted through December 9th, 2026, however, this timeline may be adjusted based on business needs and candidate volume.

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.
• Strong understanding of Power BI and dashboarding tools.
• Advanced experience using Microsoft Excel, SQL, Data warehouse.
• 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.
• Certifications related to Microsoft Fabric are preferred.
• 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 like‑minded people who want to join the movement that is changing the way healthcare is being delivered.