Data Analyst, Oracle Health - Cerner

Description

We are seeking a highly skilled and experienced Data Analyst with a deep understanding of the Oracle Health Cerner Electronic Health Record (EHR) system. The ideal candidate will be an expert in data analysis techniques and SQL, with a strong background in navigating and extracting data from Cerner's complex database structures. This role is critical in transforming raw healthcare data into actionable insights that drive clinical, operational, and financial improvements.

The successful candidate will be responsible for a wide range of data-related activities, including developing and executing data extraction strategies, performing detailed data analysis, and utilizing modern cloud-based tools to manage and process large datasets. Experience with Google Cloud Platform (GCP) and BigQuery is a key requirement for this position.

Key Responsibilities:

Cerner EHR Data Expertise:

• Serve as a subject matter expert on the Oracle Health Cerner EHR database structure and backend tooling/configuration.
• Develop and execute strategies for data extraction from Cerner, utilizing appropriate backend tools and configurations.
• Collaborate with clinical and operational stakeholders to understand data needs and translate them into technical requirements.

Data Analysis and Reporting:

• Apply expert-level data analysis techniques to complex healthcare datasets, identifying trends, patterns, and anomalies.
• Develop and maintain data visualizations, dashboards, and reports to present findings to a non-technical audience.
• Perform root cause analysis on data quality issues and work to implement solutions to improve data integrity.

SQL and Data Warehousing:

• Demonstrate expert-level proficiency in writing complex, optimized SQL queries to extract, transform, and analyze data.
• Work with relational databases and data warehouses, including experience with data modeling and schema design.

Cloud Data Platform (GCP):

• Utilize Google Cloud Platform (GCP) tools, with a specific focus on BigQuery (BQ), for data processing, storage, and analysis.
• Manage and query large-scale healthcare datasets within a GCP environment.
• Experience with DataVerse Clinical is a significant advantage, particularly in a GCP context.

Qualifications:

• Minimum of 7 years of experience as a Data Analyst, preferably in a healthcare or health technology setting.
• Proven, hands-on experience with the Oracle Health Cerner EHR system, including its database structure and backend configuration.
• Demonstrable experience with data extraction, developing reports, and utilizing backend tooling within the Cerner ecosystem.

Technical Skills:

• Expert-level SQL proficiency is mandatory, with the ability to write complex joins, subqueries, window functions, and optimize query performance.
• Expert-level knowledge of data analysis techniques and tools.
• Strong working knowledge of Google Cloud Platform (GCP) services, specifically BigQuery (BQ).
• Experience with data visualization tools (e.g., Tableau, Power BI, Looker).

Soft Skills:

• Strong analytical and problem-solving skills with meticulous attention to detail.
• Excellent communication skills, with the ability to clearly articulate complex data findings to both technical and non-technical stakeholders.
• Ability to work independently and manage multiple projects simultaneously in a fast-paced environment.

Education:

• Bachelor's degree in Computer Science, Health Informatics, Statistics, Mathematics, or a related field. Master's degree is a plus.

Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment, including but not limited to, computers, phones, and photocopiers.

Physical Demands

This position requires the frequent and repetitive use of a computer, keyboard, and mouse. Hand and finger dexterity is required.

Other Duties

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

EEO

Saama provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.