Ortho Molecular Products - Barrington, IL

posted 4 months ago

Full-time - Entry Level
Barrington, IL
Chemical Manufacturing

About the position

Overview: 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.

Responsibilities

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

Requirements

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

Benefits

  • Health savings account
  • Disability insurance
  • On-site gym
  • Dental insurance
  • Tuition reimbursement
  • Paid time off
  • Employee assistance program
  • Vision insurance
  • 401(k) matching
  • Gym membership
  • Food provided
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service