Remote BI Developer II - IS Analytic Services - Remote - FT/Days

About the position Kettering Health is a not-for-profit system of 13 medical centers and more than 120 outpatient facilities serving southwest Ohio. We are committed to transforming the health care experience with high-quality care for every stage of life. Our service-oriented mission is in action every day, whether it's by providing care in our facilities, training the next generation of health care professionals, or serving others through international outreach.

Responsibilities

• Receive requests for new data sets (cubes, views, etc), reports, dashboards, report changes and incidents through the help desk ticketing system.
• Work with customers to understand business decisions and resulting outcomes, defining requirements for data integration, reporting, analysis and/or data mart development.
• Meet with department/unit leaders and end-users to collect business requirements for data.
• Determine whether existing reports or dashboards can fulfill requests, if modifications to existing reports or data sets are needed, or new reports, data sets or visualizations need to be developed.
• Build/modify data sets, reports and dashboards for requests based on collected requirements.
• Generate standard or custom reports for clinical, quality, business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
• Conduct end-user validation of data and visualizations to ensure they fulfill established requirements.
• Collaborate with departments/units to determine the appropriate users to run and view reports.
• Assist in the development of role-based reporting security groups and assign reports to the appropriate security group.
• Work with the Security team on user provisioning to ensure users are assigned to the appropriate reporting security groups.
• Develop BI deliverables using Microsoft SQL Server Reporting Services and self service BI tools.
• Develop and maintain standard BI cubes from data warehouse data sets.
• Evaluate, maintain or update business intelligence tools, databases, dashboards, systems, or methods as appropriate.
• Maintain library of model documents, templates, or other reusable knowledge assets.
• Create business intelligence tools or systems, including design of related databases, cubes, spreadsheets, or outputs.
• Work with technical infrastructure team to ensure integrity of data.
• Create or review technical design documentation to ensure the accurate development of reporting solutions.
• Obtain data from multiple sources to create integrated Business Intelligence deliverables that can be used to drive decision making.
• Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.
• Training and coaching of customers on utilization of reporting and business intelligence tools.
• Assist in coaching and mentoring team members on report development processes and standards and BI report development skills.
• Participate in on-call rotations to provide off-hours support.
• Work with vendors and internal resources to understand and develop data extract requirements, such as Explorys interfaces, Press Ganey interfaces, etc.
• Work as a key member of the Analytics team to bring product, best practice and development expertise to future initiatives.

Requirements

• Associates degree or equivalent combination of education, certification, and experience.
• Minimum of 2 years of experience in data analysis, report creation and visualization.
• Epic Certification (Clarity, EDW) or obtained within 6 months. Nice-to-haves
• Experience with self-service BI tools (PowerPivot, Power View, Tableau, Qlikview, etc.)
• Knowledge of data warehouse concepts including: data modeling, data quality, ETL and data mining.
• Microsoft SQL Server BI tools: SQL Server, SSIS, SSAS, SSRS.
• SQL and Stored Procedures expertise in relational databases. Apply tot his job

Apply tot his job Apply To this Job