Business Intel Engineer

UC Health•Cincinnati, OH

About The Position

UC Health is hiring a Full Time Business Intel Engineer Under minimal direction, coordinates the compilation of technical reporting and analytics components of a project or program. Responsible for the design lifecycle of programs requiring advanced technical knowledge and utilization of advanced programming and database techniques. Competent to work at the highest technical level. Acts as the technical, reporting and analytics expert for the organization. Leads multiple projects for organizational data reporting, data extracts, visual dashboards and related metrics to inform decision-making, planning, and continuous improvement across UC Health. Responsibilities revolve around the collection, manipulation and dissemination of data to support the needs of decision-makers at all levels of the organization. Leads development projects with junior and intermediate staff and is responsible for the creation, documentation, and support of business intelligence (BI) solutions from Epic databases and other data-stores. Leads presentations of to all levels of the organization. About UC Health UC Health is an integrated academic health system serving Greater Cincinnati and Northern Kentucky. In partnership with the University of Cincinnati, UC Health combines clinical expertise and compassion with research and teaching—a combination that provides patients with options for even the most complex situations. Members of UC Health include: UC Medical Center, West Chester Hospital, University of Cincinnati Physicians and UC Health Ambulatory Services (with more than 900 board-certified clinicians and surgeons), Lindner Center of HOPE and several specialized institutes including: UC Gardner Neuroscience Institute and the University of Cincinnati Cancer Center. Many UC Health locations have received national recognition for outstanding quality and patient satisfaction. Learn more at uchealth.com.

Requirements

Minimum Required: Bachelor's Degree - Business Intelligence/Analytics related field.
4 years equivalent experience can substitute for a BA/BS degree.
Minimum 1 Epic data model certification.
Minimum 2 Epic Cogito Badges.
Minimum Required: 6 - 10 Years equivalent experience.
Demonstrated expert level experience using complex SQL queries to extract data from databases
Experience with performance tuning of SQL queries and expert knowledge of database concepts
This position requires demonstrable expert knowledge of database reporting tools including Excel, SAP Web Intelligence, Crystal Reports or other business intelligence tools
Expert knowledge of Epic workflows and the reporting environments and tools including Radar and RWB
Working knowledge of a business intelligence platform (e.g. Tableau, Power BI)
Master of presentations to all levels of the organization
Must possess a high level of customer service skills and participate as strong, collaborative team player

Nice To Haves

Preferred: Master's Degree - Business Intelligence/Analytics related field.
Preferred: 11 - 15 Years equivalent experience.
Working knowledge of scripting language (VB or java) helpful

Responsibilities

Analytics Development and Support: Guides a team of analysts and/or programmers in the development and/or support of automated and manual reporting systems.
Develops or assists in the development of the most complex programming routines, programs and functions according to detail design and user needs.
Provides technical guidance to analytics team for complex analytical tasks.
Supports information requests from inception to delivery, translating client requirements into appropriate reporting objects that tell a story with data including, but not limited to: analytic scorecards, dashboards, and reports.
Provides solutions and alternatives to problems/issues including adhoc reports to support offered solutions.
Responsible for monitoring data quality of related reporting datasets.
Works with data requestor or stakeholder to validate results.
Provides support and recommendations to level I and I Business Intelligence Analysts to enhance their technical skills including but not limited to participation in design and code walkthroughs.
Executes reporting design changes according to established procedures.
Provides maintenance support for all queries or reports.
Provides user training and/or support to stakeholders.
Provides timely and accurate support to resolve reporting errors and user reported problems.
Utilizes and adheres to production support standards and promotion process.
Acts as a resource / subject matter expert for the UC Health Departments.
Assists in the evaluation for Business Intelligence solutions and software products.
Ability to work independently and meet competing deadlines with minimal supervision.
Ability to develop creative solutions to complex problems and communicate solutions effectively.
Meets with users to determine the technical specifications and analytics components of a project or program
Determines and manages workload priorities.
Coordination: Leads analytics development teams for complex projects, delegates tasks and responsibilities, follows up on results internally.
Provides input and feedback to more junior staff.
Identifies and recommends changes in workflow, procedures, forms and/or data to make optimal use of system resources.
Provides Epic product function, design, and reporting expertise and experience needed for successful development of analytics.
Analyzes business processes and clinical workflow to ensure proper system configuration.
Assesses and escalates user requests and issues.
Works with programming teams on application development.
Testing and Documentation: Provides documented solution to problems/issues.
Develops detailed, written, and inclusive analytic test plans.
Performs complete testing of reports and software and validates application requirements are met.
Contribute to the testing of software tools that will allow knowledge workers to compare and map fields to those that exist within the data warehouse.
Project Support: Provides task level detail for project plans, including suggested schedules and skill set of team members required.
Provides accurate and timely individual status reports.
Documents and ensures timely resolution of project issues.
Coordinates effectively with team members and vendors.
Supports the institution’s internal and external, strategic and operational reporting needs.
Informs management of all issues that are impacting or will impact assigned area(s).
Assists with vendor and consultant activities.
Documents and maintains all required system design and build documents.
Customer Relationship: Builds consultative relationships, establishing value for the department as a key partner for producing high-quality, actionable information that meets the needs of decision-makers at all levels of the organization.
Conveys technical messages in layman terms so that the receiver can understand, regardless of their technical aptitude. Assumes technical and reporting leadership for the most complicated areas and business functions.
Facilitates end user meetings.
Provides consults to end users.
Conducts presentations as requested.
Other Duties Assigned by Manager Provides training to other staff and users as appropriate.