Are you looking for a company to grow with, and who is interested in your well-being? Ortho Molecular Products is a leading manufacturer of dietary supplements with over 35 years of stability and success in a team-focused, values-driven culture. We provide a safe, climate-controlled, and clean work environment for our employees offering a full benefits package including free daily lunches, free and discounted products, annual bonus tied to company performance (free breakfast also included and on-site full amenities gym at the Barrington location).

We are seeking a thorough, diligent, and dependable self-starter who will support and participate in the design and development process for creating and maintaining our data warehouse utilizing the Microsoft SQL Server BI stack (SSIS, SSAS, SSRS). The position will work with a team to maintain/enhance the existing company-wide Business Intelligence platform. This exciting role will work with all departments and executives by helping to put data into useful and meaningful reports to make business decisions easier.

This position is on-site Monday through Friday from 8:00am to 5:00pm in either the Stevens Point, WI or Barrington, IL office. This position requires you to be in the office five days a week (hybrid available for Senior Developers). Applicants living outside of a 30 mile radius of our offices will not be considered.

Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time.  

Qualified Candidates will:

• Demonstrate reliable attendance and positive work ethic.
• Drive to meet goals and exceed expectations.
• Actively seek ways to learn and improve.

What to Expect:

• Gather user requirements for custom database reporting.
• Analyze business needs and provide technology solutions in support of IT Portfolio Management process.
• Design and build Reporting services that meet user/business specifications.
• Develop, maintain, and enhance ETL processes throughout the data warehouse.
• Troubleshoot SQL, reporting functionality and performance issues.
• Implement the expansion of OLAP platform to fulfill business reporting needs.
• Analyze design and develop SQL Server Analysis Services tabular cubes.
• Use Visual Studio and Azure Dev Ops to manage the reporting BI Platforms
• Support Power BI source data workflow and efficient, best practices data model design.
• Support and maintain data integrity and security in BI databases.

What You Will Contribute:

• Bachelor’s degree or higher in Computer Science or Management Information Systems
• 3-5 years experience with SQL Server BI Platform (SQL Server 2023, SSRS, SSAS, SSIS)
• 3-5 years experience with SQL Server Administration (SQL Server 2023).
• 3-5 years experience with business analysis - designing and implementing solutions for business needs.
• 1-2 years experience with Power BI integration and data source design.
• Experience with Visual Studio and Azure Dev Ops for source control.
• 1-2 years SQL Server administration (maintenance plans, performance tuning).
• Expert knowledge of T-SQL / DAX.
• Exhibits character qualities of Diligence, Cooperation, Flexibility, Orderliness, and Thoroughness.

What You Will Receive:

• Health, HSA, Dental, and Vision Insurance: Comprehensive coverage to meet your needs.
• Life Insurance (company provided): Ensuring peace of mind for you and your loved ones.
• 401(k) Plan: With company matching to help you plan for the future.
• Health Savings Account (HSA): With company contributions to support your healthcare expenses.
• Paid Time Off: Start with 15 days of immediate PTO annually.
• Paid Holidays: Enjoy time off for recognized holidays.
• On-Site Wellness Meals: Company-paid meals to support your health.
• Gym Membership Reimbursement: Encouraging your fitness and well-being.
• Employee Assistance Program (EAP): Access to confidential support services.
• Voluntary Benefits: Options including short-term disability, life insurance (whole/term), hospital indemnity, critical illness, and accident expense coverage.
• Growth and Development Opportunities: Access to company university and tuition reimbursement programs.
• On-Staff Health Coach: Personalized coaching available one-on-one or in groups.
• Health and Wellness Initiatives: Participate in walking challenges, weight loss programs, health risk assessments, and more!

Why Work at Ortho Molecular Products:

Our healthcare system faces significant challenges, with issues like complexity and inefficiency. At Ortho Molecular Products, our vision is to help transform the practice of medicine. We work tirelessly to assist healthcare providers in adopting improved solutions for health issues, integrating lifestyle medicine and evidence-based nutritional therapies that enhance patient outcomes. Our commitment involves crafting scientifically grounded products and pioneering innovative clinical initiatives tailored to support doctors in supporting their patients' recovery and well-being.

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

#bideveloper