Kettering Health

Maintain patient pricing, manage item files, support materials management system, and provide training on SCM requisitioning programs. | Associate degree or equivalent, 3 years technical experience, 1 year customer service, proficiency in Excel and SQL, McKesson MMIS preferred. | Job Details Kettering Health 1 Prestige Place | Miamisburg | Full-Time | First Shift Responsibilities & Requirements The SCM Systems Support II position duties include, but are not limited to the following: Help update patient pricing changes in MM Inventory Locations and maintain PMM patient pricing and the CDM information in sync Assist in training staff in various SCM requisitioning programs Develop system tutorials to educate KHN staff on proper utilization of PMM system. Support and implementation of the Par Excellence materials management system Expedite PMM item file updates in a timely manner. Maintain and update vendor information in utilization of Cardinal OptiFreight Freight Management program Review and update item file information being exchanged between GHX (Global Healthcare Exchange) and KHN to validate the data information in launching new vendors. Job Requirements Associate’s degree (qualified experience can suffice in lieu of degree) 3 years minimum of related technical experience 1 year minimum of customer service in user support Well versed in Microsoft Excel and Microsoft SQL Preferred Qualifications 3 year experience working with McKesson MMIS products Overview Kettering Health is a not-for-profit system of 14 medical centers and more than 120 outpatient facilities serving southwest Ohio. Our mission is to live God’s love by promoting and restoring health. Our commitment to our patients is to help individuals be their best. With that context, safety is our top priority. We provide an integrated system of healthcare experts committed to providing exceptional care.

Develop and maintain Extract, Transform, and Load functions from Epic and other operational data sources into their respective target environments. Performance monitoring, troubleshooting, and optimization will be key responsibilities. | A bachelor's degree or equivalent combination of education, certification, and experience is required. The candidate should have 2 years of data warehouse administration experience for finance or healthcare organizations. | Overview 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 & Requirements Job Responsibilities Develop and maintain Extract, Transform, and Load functions from Epic and other operational data sources into their respective target environments. Performance monitoring Troubleshooting and optimization will be key responsibilities for the Timely and quality delivery of data to the user accessible desitinations. Requirements Bachelor’s degree or equivalent combination of education, certification, and experience 2 years of data warehouse administration experience for finance / healthcare organizations Knowledge in a variety of data warehouse applications and tools Knowledge of data structures, database solutions, and best practice data management principles SQL Server Integration Services package development, configuration and deployment Experience with TSQL, performance monitoring and query tuning

The BI Developer II will receive requests for data sets, reports, and dashboards, working closely with customers to define requirements and develop solutions. They will also collaborate with departments to ensure appropriate user access and assist in the development of BI deliverables using various tools. | Candidates must have an associate degree or equivalent experience, along with a minimum of 2 years in data analysis and report creation. Epic Certification is required within 6 months of hire, and experience with self-service BI tools is preferred. | Overview 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 & Requirements 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 Job 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 Preferred Qualifications Experience in the following areas is desired but not required: 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