Business Intelligence Analyst II

Cincinnati Children's is a leading children's hospital dedicated to improving health outcomes for children. The Business Intelligence Analyst II will transform clinical and operational data into insights that support patient care and operational efficiency, collaborating with various stakeholders to deliver high-quality reporting solutions.

Responsibilities:

• Collaborate with stakeholders to understand and gather requirements for Epic reporting solutions
• Design, develop, and maintain custom reports within the Epic reporting framework, ensuring the accuracy and reliability of data
• Utilize Epic's reporting tools to create and enhance reports based on end-user needs
• Work with Epic analysts and end users to troubleshoot and resolve reporting functionality or data integrity issues
• Collaborate with the Data and Analytics team to integrate Epic reporting solutions with other systems and data sources
• Provide training and support to end users on utilizing and interpreting Epic reports
• Participate in the planning and execution of system upgrades and enhancements related to Epic reporting
• Document technical specifications, data mappings, and report configurations in our enterprise data catalog
• Ensure compliance with regulatory requirements and organizational policies in developing and maintaining Epic reports
• Gather, prepare and analyze user requirements to create complex reports and simple to moderate dashboards, utilizing enterprise data systems (such as Epic Slicer Dicer, Clarity & Caboodle, Microsoft tools including PowerBI etc.)
• Participate in technical code reviews, including reviewing simple code of others
• Perform change management when reporting system modifications are needed
• Follow build, configuration and release management processes and meet user and technical documentation standards as set by CCHMC
• Translate business user questions into data solutions
• Utilize and contribute to the CCHMC information glossary to refer to governed definitions when analyzing and creating reports
• Provide end user training as required for new hires or when changes are made to existing applications/systems
• Create educational materials for end user training, adoption & activation including, but not limited to job aids, lesson plans & quick start guides
• Provide ad hoc analysis for hospital departments and divisions accurately and in a timely manner, including assistance with understanding the data and potential gaps
• Continually develop professional skills
• Maintain Epic certifications where appropriate
• Expand oral and written communication skills, particularly related to translating customer requirements into BI solutions
• Plan and execute testing plans
• Timely completion of assigned tasks
• Accurate & timely communication of status
• Effective time management and prioritization of assigned tasks
• Assist with setting task priorities and timelines
• Responsible for identification of issues with potential solutions
• Serve as project manager for simple projects
• Perform other duties as assigned
• Analyze Business Intelligence requests to align with existing tools and processes
• Organize and complete assigned tasks and associated documentation upon directives from supervisor
• Use troubleshooting skills to effectively support Business Intelligence solutions
• Develop support plans for new solutions
• Escalate unresolved issues with urgency
• Seek the appropriate resources needed for activities with multiple tasks
• Coordinate and facilitate communication between internal and external parties on assigned tasks and related issues
• Be personally accountable for commitments to projects, timelines, and deliverables
• Effectively work with cross-functional teams and customers to identify build deficiencies based on customer reporting requests

Requirements:

• Bachelor's degree in a related field
• 2+ years of work experience in related job discipline
• Previous clinical experience in a healthcare or hospital setting is a plus
• Certification in Epic's Cogito Administration or relevant Epic certifications
• Proven experience in report development within the Epic reporting environment, including familiarity with Clarity or Caboodle
• Knowledge of healthcare industry standards and regulations, including HIPAA, and the ability to ensure compliance with report development
• Experience with data visualization tools such as Power BI
• Familiarity with Epic modules and their underlying data structures is highly desirable