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. What You Will Receive : Competitive compensation with bonus program. Health, Dental, Vision, Life, 401K with matching, HSA with company contribution. Immediate Paid Time Off, starting annually at 15 days. Paid Holidays. Company-paid on-site wellness meals. Gym membership reimbursement. Employee Assistance Program. Voluntary benefits: short-term disability, whole/term life, hospital indemnity, critical illness, accident expense. Opportunities for growth and development such as company university and tuition reimbursement options. On-staff health coach, one-on-one or group coaching. Health and wellness initiatives: walking challenge, weight loss challenge, health risk assessment 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.
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.
We invite you to explore the Ortho website to learn about our career opportunities and apply ().
Join us in our mission to revolutionize healthcare and empower clinicians to make a difference!
#bideveloper
