Oracle Health Cerner, Data Analyst

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: • Experience: • 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.