We are seeking a Business Intelligence Developer , who will support and participate in the design and development process for creating and maintaining SQL Server BI stacks (SSIS, SSAS, SSRS) and SQL Server BI Databases. The position 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 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 on on-site Monday through Friday from 8:00am to 5:00pm in either the Stevens Point, WI or Barrington, IL office. What to Expect: Gather user requirements for custom database reporting; troubleshoot SQL, reporting functionality and performance issues. 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 Reporting and BI Platforms 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 Team Foundations Server to manage the reporting BI Platforms Support Power BI source data workflow and efficient data model design incorporating best practices. Support and maintain data integrity and security in BI databases. Plan and implement testing/deployment and coordinate with infrastructure team. What You Will Contribute: Bachelor's degree or higher in Computer Science or Management Information Systems 3-5 years' experience with SQP Server BI Platform (2008R2-2016, SSRS, SSAS, SSIS)3-5 years' experience with SQL Server Administration (SQL Server 2008R2-2016)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 Visual Studio and use of Team Foundation Server, Agile and Scrum Methodologies 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. 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.
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.
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.
#businessintelliegencedeveloper
