Business Intelligence Developer

Position Title:

Business Intelligence Developer

The Business Intelligence Developer II creates analytics content based upon specifications from end-user data needs or those communicated by Business Intelligence colleagues to support end users and leadership. The BID II possesses a strong understanding of the underlying data model and is skillful in development of data queries and data interaction. The BID II is responsible for designing, building, and maintaining data analysis tools and platforms that translate raw data into actionable insights for businesses.

They accomplish this by development and maintenance of paginated reports, datasets, dashboards, reports, and visualizations within Epic and third-party tools (e.g.Power

BI, Tableau, etc.).

Responsibilities listed in this section are core to the position. Inability to perform these responsibilities with or without an accommodation may result in disqualification from the position.

• Develops moderate to complex SQL solutions for creation and maintenance of analytics assets
• Configures and tests EHR- (such as Epic) released and Foundation System content for applications (such as Reporting Workbench, Slicer Dicer data models, Radar dashboards, and Cogito SQL)
• Designs and creates custom content to display EHR (such as Epic) data from databases (such as Chronicles, Clarity, and Caboodle) in organizationally designated tools (such as EHR, Tableau, Power
  
  BI)
• Distributes analytics content to data consumers and is able to anticipate needs with minimal prompting
• Provides thorough education of tool/data usage to end users without support
• Provides development support for projects and can leads projects with some support.
• Reviews peer reports for validity
• Performs moderate to complex peer review of code (such as SQL, DAX)
• Works with subject matter experts to understand the needs of data consumers
• Responds with professional communication to triage and/or resolve requests from end users independently
• Tests analytics build in specified testing environments, including designing basic test scripts when appropriate
• Reviewing upgrade documentation for database (such as Clarity and Caboodle) features
• Maintains analytics catalog and metadata records
• Develops and maintains strong operational relationships

• Performs other duties as assigned.

Education Requirements: Bachelor's Degree required.

• 3-5 years of experience in analytics (Business Intelligence, Data Engineering, Data Science, etc.) including at least 1 year experience using SQL, relational databases and integration tools required.
• Healthcare IT experience preferred in analyzing, programming, designing, testing, and/or implementing computer-based systems.
• Prior experience working with an accounts receivable system or prior experience working with an EMR system is preferred.

• Cogito Fundamentals
• Cogito Tools Administration
• Clarity Data Model
• Caboodle Data Model
• Access, Clinical,/or Revenue Data Model(s)

For preferred items below, OU Health may require incumbents to complete additional trainings, including those noted below, as part of their job requirements. Accreditation(s)/Certification(s)/License(s)/Registration(s), as appropriate, will be required no more than three months after course completion.

• Data Visualization tools (e.g. Tableau, Power
  
  BI, etc.)
• Additional Accreditation(s)/Certification(s)/License(s)/Registration(s) as requested to support evolving businesses

• Ability to communicate effectively orally and in writing with all business partners across the enterprise. Mentors junior level developers on advancing their communication effectiveness.
• Ability to effectively translate all complexities of customers requests or stated needs into meaningful business requirements with no support, advises junior level developers in this effort.
• Participates and contributes to development of designing and implementing workflow processes and standards for the team.
• Critical thinking and an analytical mindset with demonstrated ability to both rapidly synthesize problems and generate logical, solutions-focused responses.
• Proficient SQL developer with understanding of relational database concepts and has competence using related BI tools (e.g. Microsoft SQL Server and associated tools).
• Engages in junior level developer peer review of code and tool development, both providing guidance to those junior and incorporating new learning from senior level developers with demonstrated growth of coding skillset.
• Proficiency in design, build, and maintain data analysis tools, translate raw data into actionable insights for business. Uses analytics assets (e.g. metrics, dashboards, reports, self-service analysis tools, etc.), both of general industry standard analytics tools and those inline of an Electronic Health Record (EHR) such as Epic, for enterprise use. Advises and mentor junior level developers in…