"Alerted.org

**We are more than a health system. We are a belief system.** We believe wellness and sickness are both part of a lifelong partnership, and that everyone could use an expert guide. We work hard, care deeply and reach further to help people uncover their own power to be healthy. We inspire hope. We learn, grow, and achieve more – in our careers and in our communities.

Job Description Summary:

*MUST LIVE WITHIN THE STATE OF OHIO*

*Qualified candidates must have Cogito Clarity Certification and meet all the required qualifications below. This position is remote but does require at least one in-person meeting per month in Columbus, Ohio.*

The Intermediate Informatics Data Analyst will support OhioHealth Pharmacy Services by analyzing and managing healthcare data to enhance decision-making. This role requires advanced proficiency in writing SQL queries, the ability to analyze complex data, and clear communication with requestors to ensure accurate reporting.

RESPONSIBILITIES

- Develop SQL queries to retrieve, analyze, and integrate data from multiple clinical and operational sources (EHR systems, automated dispensing systems, ERP databases, etc.).

- Create dashboards and visual reports in analytics tools such as Qlik Sense and Power BI to present insights effectively.

- Collaborate with stakeholders to gather requirements and deliver reporting solutions.

- Identify and troubleshoot data quality issues in ad-hoc and automated reports.

- Implement report automation and self-service analytics to empower our end users.

- Develop clinical and operational knowledge to understand end-user workflows and effectively assess customer needs.

MINIMUM QUALIFICATIONS AND SPECIALIZED KNOWLEDGE

- High School Diploma or GED (required)

- Bachelor's Degree in one of the following fields of study: Health Information Systems, Computer Science, Information Technology, Industrial Engineering, Statistics, Public Health, Epidemiology, or related. A combination of education, training and experience may be considered in lieu of degree (required)

- Years of Experience: 3 to 5 years minimum (required)

- Epic Cogito Clarity Certification with the ability to write SQL Queries for data extraction, transformation, and analysis. (required)

- Experience, preferably in a healthcare setting, manipulating large amounts of data, developing complex queries and analyses, managing multiple projects, preparing reports and presentations and working in a multidisciplinary team setting.

- Experience with data visualization tools (E.g., Qlik Sense, Power BI, Tableau, etc.).

- Strong analytical skills with the ability to interpret complex healthcare data.

- Effective communication skills to translate technical findings for non-technical audiences.

- Ability to manage multiple projects and work collaboratively in an interdisciplinary team.

- Proficient in the use of Excel and PowerPoint.

- Experience in Python and business intelligence tools are preferred.

Responsibilities And Duties:

Extracts data from various data sources including electronic medical record, decision support, clinical quality, clinical registries, and claims databases and understands architecture to allow for creative solutions to problems of simple to moderate difficulty. Identifies and gathers detailed business requirements, creates technical documentation, clarifies, interprets and translates specifications as required in order to develop an appropriate information solution utilizing analytic and technical tools such as SAS, SQL and visual analytic tools for requests of moderate difficulty. Understands the importance of data accuracy and consistently uses good skills such as tracking case counts and comparing to known results in order to promote data quality. Looks for and resolves data issues not limited to duplication, corruption, and missing elements etc. . Implements plan to obtain data, sets up and maintains databases, analyzes data and creates reports and graphics for dissemination to stakeholders for projects of moderate difficulty. Troubleshoots errors in results and datasets. Provides timely reports and data extracts and automates programs when it makes sense. Develops methodology for metrics needed for program evaluation at a simple-medium level of complexity. Organizes, manages, and prioritizes daily work accounting for multiple projects with planned deliverables. Knowledgeable in data management, study design and analysis and documents methodology. Actively promotes the correct interpretation of data. Acts as liaison between clinical teams and other IT teams within the system sometimes facilitating as project manager. Works both independently and as team member to develop analytic solutions. . Has ability to extract meaningful information from data and to tell the story to stakeholders. Promotes self-service skills to customers as applicable. Communicates complex information at appropriate level for customer and seeks guidance when needed. Has knowledge and understanding of evidence based standards and benchmark and seeks guidance when needed. Serve as the subject matter expert by providing expert knowledge in all analytics solution design and development initiatives. Promotes self-service reporting tools to maximize organizational self-sufficiency

Minimum Qualifications:

High School or GED (Required)COGITO - Cogito Certification - Epic Inc.

Additional Job Description:

Work Shift:

Day

Scheduled Weekly Hours :

40

Department

Corporate Pharmacy Services

Join us!

Equal Employment Opportunity

OhioHealth is an equal opportunity employer and fully supports and maintains compliance with all state, federal, and local regulations. OhioHealth does not discriminate against associates or applicants because of race, color, genetic information, religion, sex, sexual orientation, gender identity or expression, age, ancestry, national origin, veteran status, military status, pregnancy, disability, marital status, familial status, or other characteristics protected by law. Equal employment is extended to all person in all aspects of the associate-employer relationship including recruitment, hiring, training, promotion, transfer, compensation, discipline, reduction in staff, termination, assignment of benefits, and any other term or condition of employment

Remote Work Disclaimer:

Positions marked as remote are only eligible for work from **Ohio** .