Ortho Molecular Products is seeking a Business Intelligence Analyst to design and deliver high-quality dashboards and data solutions that provide actionable insights across the organization. The role will support the transition from on-premises data sources to Microsoft Fabric in 2026, ensuring reporting solutions align with both current practices and future architecture.
Requirements
- Advanced experience using Microsoft Excel, SQL, Data warehouse.
- Strong understanding of Power BI and dashboarding tools.
- Proficiency in Power BI, Tableau, or similar visualization tools.
- Experience with SQL, DataMarts, PowerQuery, and PowerAutomate.
- Strong mathematical skills for writing Excel formulas and applying statistical concepts.
- Demonstrated knowledge of creating/improving business processes.
- Strong analytical and logical skills with meticulous attention to detail.
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.
Other
- Bachelor’s degree or 3 - 4 years of data analyst experience in a related field.
- This is an onsite position Monday through Friday from 8:00am to 5:00pm in Stevens Point, WI or Barrington, IL.
- Applicants must be legally authorized to work for ANY employer in the US.
- Character qualities: thoroughness, dependability, orderliness, persistence and responsibility.
- Ability to understand and perform business and functional requirement analysis.
