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.
As a Junior BI Developer, you will support and participate on design and development process for creating and maintaining SQL Server BI stacks (SSIS, SSAS, SSRS) and SQL Server BI Databases. You will work with a team to maintain/enhance the existing company-wide Business Intelligence Platform and implement the daily activities of the Corporate Reporting and Data Platform.
- This position is not remote and is based out of our in Stevens Point, Wisconsin location
What To Expect
Utilize Microsoft Business Intelligence tools to enhance and support existing reporting and data warehouse environment, including use of EQL Server Management Studio, SSRS, SSIS, SSAS, PowerShell and Power BI.
Generate reports, data extracts, and ad hoc analysis to assist in key operational business decisions.
Support SQL BI team on developing, maintaining, and updating SQL Server Analysis Services tabular cubes.
Create and maintains the logical and physical data model for the Reporting and BI Platforms
Integrate and work with other team members at different locations.
Support Power BI source data workflow and efficient data model design incorporating best practices
Develop, maintain, and enhance ETL processes throughout the Reporting and BI Platforms
Adapt and execute established data integrity and security process in BI databases
Plan and implement testing/deployment projects for new functionality
Troubleshoot SQL, Reporting functionality and performance issue
What You Will Contribute
Bachelor’s degree in Computer Science or Management Information Systems
1 - 2 years of experience preferred (recent graduates welcome to apply)
Exposure with SQL Server BI platform (2008R2-2016, SSRS, SSAS, SSIS)
Must be action oriented, ability to work in an extremely fast paced environment, a strong work ethic with a sense of ownership
Strong passion to learn BI platform technologies and conceptual knowledge with relational and dimensional data models
Be integral part to implement best practices of data management and design and data governance initiatives
Must have desire and willingness to stay current on emerging technologies, vendors, and solutions
Strong interpersonal and written/verbal/listening communication skills to communicate complex topics with internal customers
Exhibits character qualities of attentiveness, diligence, availability, cooperation, flexibility, orderliness, and thoroughness
What You Will Receive
Competitive Compensation with Bonus Program
Medical, Dental, Vision, Company Paid Life Insurance, and 401(k) with Employer Match
Short Term Disability, Life, Critical Illness, Accident, & Hospital Indemnity
Paid Time Off and Holidays
Job Specific Training (No Experience Required) & Tuition Reimbursement Program
Wellness & Employee Assistance Program, Gym Reimbursements, and Healthy, Company Paid Meals
Free Monthly Products, Employee Discounts, and Employee Referral Incentives
Ortho Molecular Products honors the service of our military veterans and understands how that service translates to a successful career. We invite you to explore the Ortho website to learn about our career opportunities and apply. Ortho Molecular Products is an Equal Opportunity Employer