CLINICAL DATA ANALYST JOB DESCRIPTIONS

A Clinical Data Analyst converts raw clinical and claims data into intelligence that health system leadership can act on. The role owns the translation layer between source systems - EHR records, ICD-10-coded claims, LOINC-mapped lab results - and the dashboards, models, and governance structures that guide quality improvement decisions. Getting this wrong means hospital quality scorecards drift from reality and population health interventions target the wrong cohorts. The role typically reports into a clinical analytics, population health, or health informatics function and works across revenue cycle, pharmacy, care management, and research stakeholders.

As the Clinical Data Analyst, you are accountable for sourcing, governing, and analyzing clinical and claims data to produce reliable analytics that drive quality, cost, and outcomes decisions across the health system. You work within a clinical analytics or population health team, partnering with quality leaders, data stewards, and cross-functional stakeholders to translate data into recommendations that move measurable performance targets.

Career Impact: Expertise in ICD-10 coding standards, LOINC terminology, and enterprise data warehouse governance positions a Clinical Data Analyst as a specialist that health systems, payers, and population health vendors actively compete to hire.

Business Impact: The dashboards and predictive models this role produces feed directly into quality improvement initiatives and value-based care programs, shaping which patients receive outreach and how clinical resources are allocated.

Growth Opportunity: Mastery of population health analytics and data governance at the enterprise level opens paths toward senior analyst, clinical informatics lead, and health data architect roles within two to four years.

• Design and maintain enterprise quality dashboards and population health reports that track outcomes, utilization, and cost metrics for clinical and executive audiences.
• Develop predictive models and statistical analyses, including hypothesis testing and correlational analyses, to support quality improvement and value-based care programs.
• Integrate clinical data from EHR systems, administrative claims, disease registries, and survey sources into a unified analytic dataset.
• Govern data standards by defining key data element requirements, maintaining data dictionaries, and coordinating with data stewards on enterprise data warehouse conventions.
• Write and execute SQL queries against master data and coded clinical datasets to build analytic cohorts and validate data accuracy.
• Translate analytic findings into structured presentations and recommendations for quality teams, clinical leadership, and external stakeholders.
• Monitor data quality continuously, identifying anomalies at the source and communicating resolution recommendations to upstream data owners.

• Bachelor's degree in health informatics, data science, statistics, computer science, or a related field, or equivalent work experience.
• 3 or more years of clinical data analysis experience, with demonstrated work on EHR or claims datasets in a health system or payer setting.
• Proficiency in SQL for querying relational databases, building cohorts, and supporting ETL validation
• Knowledge of healthcare data standards including ICD-9, ICD-10, LOINC, CPT, and SNOMED CT, with practical ability to apply them in analysis.
• Ability to apply statistical methods including regression, correlational analyses, and predictive modeling to clinical datasets.
• Demonstrated competency in data governance practices including data dictionary management, lineage documentation, and stewardship coordination.
• Strong written and verbal communication skills, with ability to present technical findings to non-technical clinical and operational audiences.

• Graduate degree in health informatics, biostatistics, epidemiology, or a closely related field.
• Familiarity with HL7 or FHIR data exchange standards in an enterprise health IT environment.
• Experience supporting population health programs using disease registry data, vital registration systems, or public health administrative records.
• Prior exposure to value-based care analytics, including risk stratification models or quality benchmark platforms such as CMS star ratings.

• Data accuracy rate on governed clinical datasets, reflecting how consistently source-to-warehouse transformations meet defined standards.
• Query turnaround time for ad hoc analytic requests from quality and clinical teams, measured against agreed service levels.
• Dashboard adoption rate among quality team end users, indicating whether delivered reports are replacing manual processes.
• Cohort identification precision, measured by clinician review acceptance rate on population health outreach lists.
• Anomaly detection and resolution cycle time, tracking how quickly data quality issues are identified and resolved upstream.
• Typical tools: Query and analytics (commonly SQL-based warehouse environments); statistical analysis (commonly SAS or R); visualization (commonly Tableau).

• Base Salary Range: $75,000 to $105,000 annually depending on experience and location.
• Bonus: Annual performance bonus of 5% to 10% of base salary.
• Equity: Equity uncommon; occasional RSU grants at larger health systems.
• Health Benefits: Medical, dental, and vision coverage; employer contributes majority of premium.
• PTO: 15 to 20 days annually plus standard federal holidays.
• Common Perks: Tuition reimbursement for health informatics credentials, remote or hybrid flexibility, continuing education support.

Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

Background check and, where applicable, drug screening are required as conditions of employment in this role, consistent with healthcare industry standards. All qualified applicants will be considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to individuals with disabilities throughout the hiring process and in the performance of job duties. Candidates must be authorized to work in the United States.

The Clinical Data Analyst owns data governance and integration across heterogeneous healthcare sources, including ingestion, ontology management, and normalization for an enterprise data warehouse. Reporting to clinical and BI leadership, the role shapes AI and machine learning readiness by driving master data standards, cohort development, and data accuracy education across clinical domains.

Key Responsibilities

• Engage with data stewards to understand and analyze complex data systems.
• Define and ensure key data element transformations and hierarchies.
• Demonstrate competency with disparate healthcare data sources for ingestion, metadata, mappings, ontology management, data catalog management, reference data, rules and hierarchies, and normalization.
• Apply concepts to enable AI and machine learning algorithm development, natural language processing, and patient portal data enrichment.
• Conduct data profiling, data aggregation, mapping, reference data, and data governance evangelization activities
• Educate non-data-minded colleagues on the high stakes associated with data accuracy with superb communication skills.
• Work closely with BI Developers to complete planning, development, testing, and implementation of new products.
• Engage with data stewards throughout the business to collaboratively determine data standards for the enterprise data warehouse and data visualization purposes.
• Embrace the spectrum of data governance implementation including data accessibility, business glossary, data dictionary, data catalog, reference and master data management, data cleansing, data lineage, EMPI, deidentification, and data collaboration.
• Hold data capture systems to high standards of data integrity with oversight of data loads and operations awareness for data analysis and reporting.
• Consult the business regarding educational opportunities, process improvement, and business requirements to drive tool selection and consolidation activities.

Required Qualifications

• Healthcare professional degree (Ph.D., MD, RN, CPhT, RPhT) preferred.
• Bachelor's degree in business analytics, computer science, engineering, accounting, finance, management information systems, or a related field.
• In lieu of a degree, 6+ years of experience or the equivalent combination of education and experience required.
• 6+ years in active healthcare big-data integration with multiple heterogeneous data sources, data cleansing, and reference and master data management on an enterprise data warehouse.
• Understanding of clinical data and data quality needs in the ambulatory oncology setting.
• Understanding of health IT data services technologies and terminologies such as HL7, C-CDA, EDI, FHIR, CDC, ODBC, RDMS, and data replication use cases.
• Understanding of business unit data insights and operations needs across healthcare domains including revenue cycle, research, pharmacy, procurement, medical and radiation oncology, accounting and finance, labs, care management, value-based care, and radiology.
• Domain understanding of data modeling, data warehousing, business intelligence, and ELT development.
• Proficiency in SQL to create and maintain database objects and query and load required data using data governance and visualization tools.
• Ability to perform SQL queries using master data to create oncology cohorts for research use cases.
• Firm understanding of healthcare coding standards such as Claims, HL7, RxNorm, ICD-9, ICD-10, LOINC, Medications, UCUM, UMLS, and SNOMED CT with practical knowledge of clinical terminologies.
• Critical thinking and logic skills with attention to detail and ability to identify root causes for data anomalies and data quality issues.
• Governance-first mindset with the ability to lead subject domain areas within a data steward council.
• Valid state driver's license required for travel to satellite offices and offsite meetings.
• Compliance with driver safety operations and motor vehicle records check policy required.

Embedded within the Global Clinical Development department, the Clinical Data Analyst delivers reliable enterprise quality dashboards, predictive analytics, and advanced statistical modeling to support the Texas Division's strategic quality priorities. Working closely with division and hospital quality teams, clinical informatics, finance, and service lines, the role builds data-driven recommendations that enable organizational transformation and long-range analytic strategy execution.

Core Functions

• Utilize quality data from identified sources of truth including publicly reported databases, quality benchmark platforms, the enterprise national data warehouse, and other clinical or regulatory data reporting tools.
• Work closely with division and hospital quality teams to provide analytic support under guidance from clinical analytics leadership.
• Develop enterprise quality dashboards, predictive analytics, advanced analytics, data visualization, outcomes measures, quality improvement, and statistical and advanced modeling techniques.
• Coordinate with quality and clinical teams to develop data-based recommendations and presentations to support stakeholders' planning and decision making.
• Align with the national analytic strategy to support clinical analytics needs.
• Develop and support analytic project plans with tactics, key deliverables, and timelines for quality, regulatory, or benchmarking reporting needs.
• Define analytic needs and provide analytic support for quality improvement initiatives in collaboration with customers such as quality and clinical teams.
• Collaborate with quality, division analytic leaders, service lines, clinical informatics, finance, and others in a complex organizational matrix to achieve transformation using analytics.
• Facilitate the development and maintenance of standard definitions for clinical analytics.
• Proactively identify opportunities to improve customer focus, system thinking, and data quality and functionality.
• Apply standard statistical and analytic approaches including hypothesis testing, correlational analyses, predictive modeling, and data visualization.
• Identify opportunities for organizational process re-engineering and performance improvement to optimize standard division analytics.
• Guide and mentor other analysts in the department during initiatives and projects as needed.

Qualifications & Experience

• Bachelor's degree in a related discipline.
• Five years of experience defining requirements and developing healthcare-specific analytics required.
• Foundation in analytics, statistics, and data modeling in healthcare settings.
• Knowledge of analytic best practices within healthcare and across analytically driven organizations.
• Ability to analyze raw data and disseminate results with logical thinking and high-level accuracy.
• Demonstrated ability to manage and monitor operational processes to achieve implementation of a long-range enterprise analytics strategy.
• Experience with SAS, R, or other statistical software, Tableau, and Qlik.
• Organizational, innovation, design, planning, implementation, and project management skills.
• Ability to transform ambiguous conceptual models into operational practice.
• Ability to analyze data, synthesize information, and transfer knowledge.
• Ability to develop, sustain, and optimize diverse professional relationships.
• Ability to motivate, influence, mentor, coach, and build high-performing teams.
• Ability to delegate to staff and colleagues while ensuring leadership is informed.
• Ability to identify, understand, and navigate barriers to change.
• Excellent written and verbal communication skills with the ability to multitask and prioritize projects to meet scheduled deadlines.

Reporting to clinical analytics leadership, the Clinical Data Analyst shapes continuous improvement of data-driven strategic planning by delivering forecasts, trend analysis, and deep-dive analytics across cross-functional project teams that include ETL development, data quality assurance, and data visualization. Partnering with Business Process Owners, Systems Architects, Application Developers, and Support teams, the role builds scalable governance documentation and functional requirements that connect customers, development teams, and third parties throughout the development lifecycle.

Primary Duties

• Prepare forecasts, analyze data trends, identify data anomalies, and conduct deep dive data analysis
• Participate in high-level business analysis and assist with benchmarking KPIs
• Analyze data and draw conclusions, communicating results in a clear, concise, and actionable manner
• Collate, cleanse, and organize data from several sources
• Work in cross-functional project teams that include ETL development, data quality assurance, and data visualization
• Communicate directly with team members and support teams to diagnose and resolve issues
• Actively participate in project team meetings to achieve team goals
• Use analytic tools such as Tableau and SAS for data analysis and visualization
• Create and maintain documentation of data governance procedures, policies, and adaptations
• Own the functional requirements link between the customer, development team, and any third party regarding software functionality throughout the development lifecycle

Skills & Qualifications

• Bachelor's degree in computer science, systems engineering, applied mathematics, business administration, economics, statistics, telecommunications, or data communications; master's degree preferred.
• 5+ years of progressive, responsible experience in data processing, computer systems, and applications.
• 5+ years of supervisory experience in operations specialty.
• 2+ years of work experience in data analysis and visualization.
• Experience in preparing and conducting extensive business analysis, process assessments, data analysis, and cost-benefit analysis to support data-driven strategies.
• Telecommunications background and experience required for network services roles.
• Knowledge of healthcare industry systems and applications is a plus.
• Broad knowledge of computers, peripheral devices, communications systems, hardware capabilities, and programming languages.
• Proficiency in PL/SQL coding.
• Experience with various data platforms.
• Excellent troubleshooting, problem-solving, and ownership skills with ability to coordinate effective responses and drive improvements through root cause analysis.
• Ability to work within a diverse, technically oriented team setting.
• Adherence to internal and external production SLAs.
• Willingness to participate in team on-call rotation and perform off-hours work as needed.

Sitting at the intersection of clinical content design and EPR configuration, the Clinical Data Analyst supports Solution Consultants and project stakeholders in moving to an electronic patient record by developing, configuring, and validating EPR components including care plans, data items, and task definitions. Operating across customer-facing solution teams, product development teams, and subject matter experts, the role ensures clinical content supports accurate reporting, patient safety, and efficient clinical workflows through usability evaluation, stakeholder presentations, and iterative form design.

Duties

• Develop and configure necessary components of the EPR including software, care plans, data items, and task definitions, ensuring business requirements are met.
• Design, develop prototypes, build, and validate new clinical content along with required documentation.
• Support user requirement analysis with relevant teams and perform usability evaluations.
• Ensure all business specifications and requirements are captured and that form content supports accurate reporting.
• Complete design of forms and specifications through close cooperation with the customer-facing solution team, product development teams, and subject matter experts.
• Support presentations for stakeholder sessions regarding business requirements for electronic capture.
• Present to stakeholders and support iterative evaluation and improvement of forms built, conducting usability testing.
• Prepare content for meetings with end users and establish relationships with external and internal stakeholders.
• Participate in testing and ensure issues raised regarding forms are dealt with in a timely manner in line with service level agreements.
• Manage project controls including risk and issue management and reporting.
• Ensure clinical and patient safety remains paramount throughout any process changes or transition to electronic recording.

Experience & Qualifications

• Experience working in the NHS or health sector highly desirable.
• Minimum of 2 years of experience as a data analyst, content analyst, or software analyst.
• Experience in EPR content development or EPR configuration development.
• Experience working with clinical data.
• Experience of managing a team, team building, and coaching of individual staff.
• Healthcare deployment experience desirable.
• Healthcare supplier experience desirable.
• Experience of creating user and training guides, customer-focused documentation, and workflow maps.
• Knowledge of software and technology.
• Strong interest in and understanding of IT.
• Ability to self-manage time and workload in a busy environment.
• Customer-focused with high standards of customer service.
• Meticulous attention to detail with the ability to follow through on actions.
• Excellent interpersonal, communication, and presentation skills.
• Ability to prioritize, organize, and coordinate work for team and self.
• Strong relationship-building, influencing, and negotiating skills.
• Ability to work away from home and willingness to travel essential.

A key member of the clinical analytics team, the Clinical Data Analyst leads the development of clinical risk models using machine learning and AI, medical and pharmacy claims evaluation, and population health metric design across clinical, data science, engineering, and client management functions. Collaborating with sales and client management teams, the role delivers interactive dashboards, KPI frameworks, and informatics strategies that measurably improve health outcomes and organizational performance.

Key Deliverables

• Develop clinical risk models using machine learning and AI, clinical outcomes, population health metric design, data evaluation, medical claims and pharmacy claims utilization evaluation, and clinical operation performance measurement.
• Evaluate clinical intervention programs from a member experience and patient outcome perspective.
• Build reporting and dashboards using Excel, Tableau, and other BI tools.
• Write, program, develop, and implement visual data reports and create personalized, interactive data visualizations from multiple data sources.
• Work with the business to process requirements and convert them into meaningful reports.
• Train and communicate reports to business stakeholders.
• Work with large datasets applying complex database structures and data transformation methodologies.
• Analyze, cleanse, and transform medical, pharmacy claims, and member demographics data for various models and projects.
• Communicate findings and trends to technical and non-technical audiences.
• Establish KPIs to measure effectiveness of business processes, practices, and decisions.
• Create reports and presentations for projects, summarizing recommendations and findings.
• Work collaboratively with clinical, data science, engineering, client management, and sales teams.
• Identify and implement informatics strategies to support health outcomes, patient outreach, and organizational performance.

Position Requirements

• Bachelor's degree in healthcare informatics, mathematics, data engineering, data science, or computer science preferred.
• Minimum of 5 years of experience in data analytics and data science.
• Experience in the healthcare industry strongly preferred.
• Strong understanding of medical claims and pharmacy claims data, from provider billing to payer adjudication.
• Intermediate skills in Microsoft Excel, SQL, R, Python, and SAS.
• Strong analytical and problem-solving skills.
• Strong oral and written communication skills.
• Ability to manage and complete multiple projects within established deadlines with minimal supervision.
• Attention to detail with enjoyment of working closely with large amounts of data and debugging formula and code errors.
• Flexible and friendly work attitude with willingness to assist other team members on projects.
• Team player and self-motivator with ability to take on new challenges with high-level instructions.

High-quality clinical trial outcomes depend on the Clinical Data Analyst, who manages all data management activities for assigned studies including data quality checks, image and video analysis, and discrepancy reporting across clinical and cross-functional teams. Based within a site-based environment, the role ensures data accuracy and reliability through validation, reconciliation, and retrieval workflows that support regulatory compliance and clinical study execution from planning through database lock.

Accountabilities

• Manage all data management activities for assigned studies
• Develop project-specific data management plans addressing workflow processes, reporting, data transfer, and database locks
• Perform data quality and discrepancy checks to ensure accuracy of data
• Perform data analyses and identify trends and patterns in data
• Present ongoing data updates to management on a routine basis
• Perform image and video analysis of clinical data and surgeries
• Regularly prepare presentations and reports to update the team on completed analyses or concerning and abnormal data
• Actively participate in efforts to improve data management processes as needed
• Collaborate with clinical and cross-functional teams

Education & Experience

• BS or MS in statistics, biostatistics, computer science, health sciences, informatics, or mathematics
• 3 to 5 years of clinical experience in data-intensive clinical studies
• Experience leading clinical study data lock and FDA audits
• Experience in ophthalmology refractive studies preferred
• Knowledgeable in correlation analyses including multivariate analyses
• Proficient in MS Excel
• Experience with Minitab, R, or other software and programming languages for statistical analysis
• Familiarity with electronic databases

As the Clinical Data Analyst, this role serves the Brooklyn Data Station team by leading data management and analytic processes that support population health programs using electronic health records, administrative records, surveys, and disease registries. The Brooklyn Data Station team relies on this work to deliver routine reports, data dictionaries, and query-driven extracts that enable faculty, staff, and community audiences to access and act on clinical and public health data.

Key Responsibilities

• Serve as a clinical data analyst to support population health programs using data sources including electronic health records, project-specific surveys, administrative records, and other novel data sources.
• Lead data management and analytic processes.
• Work with faculty and staff to respond to requests for clinical data.
• Write and execute queries to extract data from electronic health records.
• Develop dashboards to communicate data summaries with various stakeholders.
• Integrate data from multiple sources including electronic health records, published literature, surveys, censuses, administrative records, vital registration systems, and disease registries.
• Develop and document code that can be used by a diverse range of individuals to solve commonly encountered problems and implement widely used analyses.
• Develop routine reports for project monitoring.
• Create and maintain data dictionaries and other metadata resources to share with other analysts and researchers.
• Provide technical assistance and support to stakeholders to help them use data resources effectively.
• Participate in project meetings and workgroups to share knowledge and best practices.
• Create text, tables, figures, and charts for presentations and publications for scientific and community audiences.

Required Qualifications

• Master's degree in epidemiology, data science, public health, clinical informatics, information management, biostatistics, healthcare administration, or a related field.
• 2 to 3 years of experience in clinical data analysis.
• Demonstrated success in writing and executing queries to extract data from electronic health records.
• Familiarity with clinical information including diagnostic coding and clinical databases.
• Knowledge of current research and trends in public health and appropriate computer processing methods used to generate, organize, and display statistical and research data.
• Ability to apply mathematical formulas and make calculations.
• Ability to gather, organize, analyze, and report findings from analyses.
• Demonstrated success in developing code in SQL, SAS, R, Python, Stata, or other coding languages.
• Experience with Hadoop preferred.
• Familiarity with data visualization tools such as Tableau.
• Strong quantitative aptitude with desire to learn new skills and ability to interpret complex analytic information.
• Strong attention to detail with demonstrated organizational skills, self-motivation, flexibility, and strong communication skills.
• Knowledge of Chinese (Mandarin or Cantonese) or Spanish preferred.
• Adherence to all data security requirements.

Clinical Data Analyst delivers superior analytic modeling and customized pharmacy claims insights for strategic clients within a pharmacy services setting, supporting clinical consulting, account management, and operations departments. Success in the position means producing quarterly performance reviews, ad hoc client analyses, and trend modeling that drive client satisfaction, retention, and business execution across moderate-to-complex analytical engagements.

Operational Focus

• Provide superior analytic modeling with a focus on client satisfaction, client retention, and trend management.
• Support short- and long-term operational and strategic business activities.
• Develop, enhance, and maintain operational information and models with impact on business execution.
• Efficiently extract and manipulate pharmacy claim data for internal and external clients.
• Use logic and analytic skills to perform client-specific analyses in response to business questions and communicate findings including data sources, methodology, outcomes, and recommendations.
• Communicate drug cost and trend information to requesters and respond to plan-specific analytic inquiries.
• Stay aware of market intelligence pertinent to the role.
• Formulate client insights based on client data through ad hoc or custom modeling.
• Demonstrate critical thinking by analyzing relevant information with multiple methods.
• Generate innovative ideas that can be scaled across the organization.
• Routinely identify, develop, and share best practice experience with peers.
• Routinely collaborate with clinical consulting and account management to provide clinical aspects of client quarterly reviews.

Background & Experience

• Bachelor's degree in business, finance, health administration, statistics, economics, or a related field, or equivalent work experience.
• 1+ years of experience in quantitative analytics and conducting advanced analytic modeling for large claims databases.
• 1+ years of experience querying and analyzing pharmacy claims data.
• 1+ years of managed care or PBM experience.
• Experience gathering and documenting requirements from the client and business.
• Intermediate level of proficiency with SQL or SAS.
• Proficiency with relational databases and database structures.
• Ability to communicate analysis to business partners and clients in writing and verbally.
• Ability to research conflicting or inaccurate data.
• Ability to prioritize multiple concurrent tasks.
• Excellent communication and interpersonal skills.
• Demonstrated growth mindset with curiosity and courage to pursue success.

The Lab Clinical Data Analyst owns full data management study life-cycle delivery for regional and global clinical trials, including project timelines, data transmission agreements, and quality control procedures for laboratory databases. Reporting to a senior laboratory data analyst or manager, the role builds accurate, regulation-compliant database deliverables in accordance with ICH E6 guidelines and FDA, ISO, and HL7 standards.

Role Responsibilities

• Manage delivery of projects through the full data management study life-cycle with guidance from a senior laboratory data analyst or manager, including managing project timelines, quality, and out-of-scope work.
• Serve as a primary laboratory data analyst for regional or global studies.
• Interact with internal and external team members to negotiate timelines and responsibilities and resolve issues related to clinical trials databases.
• Ensure service and quality meet agreed-upon timelines and deliverables in data transmission agreements and obtain peer review where required.
• Determine and assist with data requirements and specifications per project needs, identify database setup and programming gaps, and resolve issues using the global issue escalation and communication policy.
• Ensure specification and design documentation are filed and stored according to policy.
• Understand and verify error logs generated by data transmission creation programs and communicate to the programming and support team to resolve any issues.
• Record all evidence of the data transmission process from data file definition to closure of study.
• Ensure internal and external customer queries are addressed and resolved effectively.
• Perform comprehensive quality control procedures to maintain completeness, accuracy, and consistency of clinical trial database deliverables.
• Use multiple approaches or technologies to solve problems within established standards and procedures.
• Provide input for negotiations with customers relative to project details including timelines, financial, process, and resources.
• Perform all work in accordance with ICH E6 guidelines for good clinical practice.

Minimum Qualifications

• Bachelor's degree in computer life sciences or a related field required.
• Equivalent combination of education, training, and experience accepted.
• 1 year of relevant work experience including programming experience required.
• Good understanding of medical, clinical research, and lab data management processes and terminology.
• Working knowledge of regulatory requirements such as FDA, ICH, ISO, HL7, and GLP.
• Experience with SAS programming in the course of file format processes.
• Proficiency in Windows operating systems and Microsoft Office applications.
• Good customer-focused perspective with skill to guide customer communications.
• Good attention to detail with aptitude to anticipate, address, and escalate issues.
• Good project and task management capabilities with the ability to manage multiple projects simultaneously.
• Effective problem-solving skills with the ability to proactively identify process improvements.
• High degree of ethics and integrity in carrying out duties in accordance with laws, regulatory standards, and policies.

Embedded within the Global Clinical Development department, the Senior Clinical Data Analyst advances end-to-end data management across a variety of global studies by coordinating clinical data review, query generation, query resolution, and reconciliation activities in support of quality, integrity, and timeline requirements. Working closely with Data Managers through study startup, maintenance, and database lock, the role develops study-specific plans, executes SAS listings, and supports the training of new staff on projects.

Day-to-Day Responsibilities

• Serve as a member of the project team with primary responsibility for coordinating clinical data review, query generation, query resolution, and reconciliation activities to support delivery of clinical data according to quality, integrity, and timeline requirements.
• Assist in the development of the project data management plan including data review guidelines, diagnostics specifications, and setup of data management systems.
• Review clinical trial data in accordance with data management plans, edit check specifications, and data review guidelines and raise queries to resolve erroneous, missing, or incomplete data.
• Generate, resolve, and track queries to address problematic data identified during aggregate data review activities.
• Run and execute additional programs, special listings, and reconciliation discrepancy listings to support the review of clinical trial data.
• Assist with review of data listings for internal data review.
• Assist in creating dummy data to test edit checks and to test database screen design and functionality.
• Assist in creating dummy data to test SAS reports and data listings.
• Modify standard templates to create study-specific data management plans and eCRF completion guidelines.
• Post data management documentation and complete data management-related administrative tasks including maintenance of eTMF as required
• Generate study status reports and perform database extracts.
• Assist with the completion of database lock activities.
• Support the training of new staff on projects.

Knowledge Skills & Abilities

• University or college degree in life science, pharmacy, or a related subject preferred, or certification in a related allied health profession from an appropriately accredited institution.
• Additional relevant work experience will be considered in lieu of formal qualifications.
• Applicable experience in clinical research with data management experience preferred.
• Knowledge of medical terminology.
• Knowledge of the drug development process.
• Knowledge of effective clinical data management practices.
• Demonstrated time management skills with the ability to adhere to project productivity metrics and timelines.
• Demonstrated ability to work in a team environment and collaborate with peers.
• Demonstrated organizational ability with strong communication and interpersonal skills.

Reporting to the Population Health Department leadership, the Clinical Data Analyst shapes the architecture, design, development, and strategy for building Population Health Analytics databases within the RWJBH data infrastructure, including OLAP cubes, OLTP solutions, and ETL processes for claims and EMR/EHR data. Partnering with multidisciplinary teams, the role builds analytic and reporting capabilities that generate insight into healthcare trends, quality metrics, utilization, cost, and patient experience across the health system.

Scope of Work

• Learn to use database developer tools to create OLAP cubes and OLTP solutions using MS SQL Server Analysis Services.
• Write SQL and SAS queries for ETL processes.
• Assist in testing and maintaining data integrity for multiple databases.
• Plan and execute reporting, evaluation, and analytic projects.
• Interpret and translate analytic concepts, approaches, and results for executive audiences.
• Achieve clinical reporting and support of population health management objectives.
• Work both independently and on multi-disciplinary teams.

Technical Qualifications

• Bachelor's degree in software engineering, computer science, economics, or another engineering field.
• Must have hands-on expertise as a database developer.
• 1 to 3 years of experience designing and executing data warehouse solutions.
• 3 to 5 years of experience in database management writing stored procedures, functions, and views using SQL.
• Experience using health transaction and survey results databases.
• Knowledge of healthcare coding systems including CPT4, ICD-10, revenue codes, HCPCS, NDC, and LOINC, and of EMR systems and RHIO data.
• Analytical, statistical, predictive modelling, and problem-solving skills.
• Strength in ETL processes.
• Knowledge of SQL Server Analysis Services and extensive use of SQL Server Integration Services and SSRS packages.
• Ability to apply statistical, analytic, and visualization tools such as R, Python, SAS, and Tableau.
• VBA skills a plus.
• Excellent interpersonal skills.
• Excellent oral, written communication, and presentation skills.

Sitting at the intersection of clinical oncology research and data quality, the Clinical Data Analyst works with the Clinical Data team to interpret, organize, and capture clinical oncology data that supports the mission of improving lives by learning from the experience of every cancer patient. Operating across software engineering, research, and client delivery functions and reporting to the Manager, Clinical Data, the role leads portfolio management of 3 to 5 projects while developing data capture forms, validation checks, and process improvement tools that ensure high-quality data products for clients.

Leadership Responsibilities

• Support the management of a portfolio of 3 to 5 projects.
• Assist with the development of data capture forms, data capture instructions, and data analyses.
• Support data quality and control activities including clarifying guidance, correcting errors, and refining instructions.
• Participate in problem-solving discussions with internal stakeholders to determine clinically and scientifically sound approaches.
• Contribute to the development of templates and tools to identify major pain points in various workflows and address these challenges.
• Surface suggestions to software engineers regarding how to improve software platforms.
• Work with cross-functional teams on research initiatives to develop high-quality data products for delivery to clients.

Professional Experience

• 2+ years of experience working in clinical or lab research.
• Familiarity with EMR systems, EDCs, or other data management systems.
• High comfort level with technology.
• Strong verbal and written communication skills.
• Demonstrated attention to detail.
• Self-motivated with the ability to support the team in identifying problems and executing solutions in a dynamic and fast-paced environment.

A key member of the data management team, the Clinical Data Analyst leads eCRF development, data validation planning, database lock management, and quality control processes for assigned BA/BE projects and selected clinical trials. Collaborating with team members on DMP implementation, query generation, and EDC reconciliation, the role delivers accurate, SOP-compliant data management outputs that support study setup, conduct, and closeout in accordance with ICH and regulatory guidelines.

Work Activities

• Develop screens testing, edit check testing, and completion guidelines for selected projects.
• Develop eCRF, annotate CRF, and create data validation plans for selected projects.
• Develop, review, and manage project plans for selected projects, including data management plans and data management reports.
• Develop, provide, and incorporate data transfers from other sources for selected projects.
• Manage database lock and unlock for selected projects.
• Implement DMP changes to daily work activities and reference data issues logs to resolve queries, generate data queries, and conduct quality control processes including CRF to database review.
• Perform data cleaning including query activity and EDC reconciliation, identify and report issues and data trends, and communicate resolution recommendations.
• Complete assigned tasks promptly, run reports as requested, and complete work for BA/BE projects including setup, conduct, and closeout.
• Reconcile project files, reports, listings, and other documents generated in data management against the EDC database for accuracy and completeness.
• Perform all tasks in accordance with relevant SOPs, ICH, or other regulatory guidelines in data management.
• Act as DBP on a trained EDC system if needed.
• Make timelines, allocate work content, guide team members to complete tasks, and ensure work quality for BA/BE projects.
• Prepare and transfer information as part of new project team member onboarding.

Qualifications & Experience

• BSc degree or above or equivalent education.
• 1 to 2 years of clinical data management experience for CDA I/II; 2 to 4 years for Senior CDA.
• Basic understanding of medical terminology and clinical research terminology.
• Understanding of ICH-GCP principles.
• Effective communication through both written and verbal methods.
• Ability to manage time effectively to produce quality deliverables within expected timeframes.

High-quality health system performance and national benchmarking depend on the Senior Clinical Data Analyst, who designs, develops, and maintains databases to collect, organize, and analyze primary and secondary data from internal and external sources. Serving as the analytical backbone for quality and safety initiatives, the role produces dashboards, scorecards, outcome data extracts, and ad hoc reports that enable the health system to compare performance against targets, peer groups, and national benchmarks.

Strategic Responsibilities

• Design, develop, and maintain databases to collect, organize, and analyze primary and secondary data obtained from internal and external sources.
• Collaborate and provide analysis and interpretation of data, identifying key trends and opportunities for improved performance, comparing health system, peer group, and comparative groups, including national benchmarking.
• Identify and use internal and external sources of information for benchmarking and comparative performance, including networking with clinical communities, researching literature and agencies, and staying current on new indicators and requirements.
• Prepare reports, charts, tables, and other graphic displays of data demonstrating performance compared to targets, national benchmarks, and peer groups, including system-level dashboards and scorecards.
• Extract and validate outcome data used in the health system tracker, perfect care scorecard, and other quality and safety initiatives.
• Create standard work for production of reports that can be executed by local ministries, including report templates and auto-populated reports.
• Perform analytical and special projects and prepare ad hoc reports and data queries as assigned.

Education & Experience

• Bachelor's degree in healthcare administration, statistical analysis, data administration, business, math, statistics, information technology, health informatics, or a related subject.
• Master's degree in health informatics, health information systems, computer science, mathematics, or a related field, or equivalent education and experience preferred.
• 3 years of clinical experience in data collection, analysis, quality and safety, or computer programming.
• Experience in designing and managing functional databases.
• Experience with databases.
• Advanced training in managing, modeling, and validating large data sets.
• Coursework or training in SAS or SQL.

As the Clinical Data Analyst, this role leads identification, mapping, and preprocessing of raw data from disparate clinical sources including EMR, imaging, laboratory, and pathology systems, applying HL7, DICOM, and coding standards such as SNOMED, LOINC, and RxNorm to deliver trusted datasets for regulatory reporting and analytics. The clinical analytics team relies on this work to maintain product test cases, validate data quality, and communicate source anomalies that inform enterprise governance strategy and enriched patient data pipelines.

Delivery Expectations

• Identify, evaluate, map, and preprocess raw data for integration from disparate clinical sources using data governance principles.
• Assist the team with healthcare standards such as HL7 and DICOM and coding systems including CPT, HCPCS, SNOMED, ICD-9 and ICD-10, LOINC, and RxNorm to handle clinical data appropriately.
• Engage with customers, prospects, and other experts to understand and analyze complex data systems and define and document key data element requirements, flow, relationships, and dependencies.
• Assist in definition, documentation, and communication of standards and processes to adopt and implement data quality with validated product requirements.
• Investigate and communicate data source anomalies.
• Prioritize and validate product test cases.

Professional Experience

• 2+ years of clinical experience using an electronic health record.
• 2+ years of experience in the healthcare domain with direct experience in data integration, software development, and implementation of enterprise clinical use software.
• Healthcare information technology experience specific to EMR, clinician notes, imaging, laboratory, pathology, and medication administration to create enriched patient data with a clinical analytics concentration.
• Profound knowledge of clinical terminologies and data standards including HL7, RxNorm, ICD-9, ICD-10, LOINC, Medications, UCUM, UMLS, and SNOMED CT.
• Expertise with claims, claim line feed data, revenue cycle management, and patient portals.
• Experience with systems engineering concepts, data modeling, data architecture, data warehousing, databases, and datamarts.
• Proficiency with SQL for product development related to data collection, aggregation, application development, analysis, and reporting.
• Conceptual understanding of AI and ML pipelines and natural language processing.
• Demonstrated competency with disparate healthcare data sources for ingestion, metadata, mappings, ontology management, data catalog management, reference data, rules, hierarchies, and normalization.

Clinical Data Analyst manages key medical data that drives the decisions of Medical Directors within clinical trials, serving as first-line reviewer of tracker data, super user for clinical trial software, and point person for Medical and Executive team inquiries. The work directly supports daily patient progression reporting, lab result query administration, and meeting documentation that keep clinical project managers and the medical team informed throughout study execution.

Key Responsibilities

• Work with clinical project managers and the medical team on setup and maintenance of study trackers.
• Enter relevant data accurately from the electronic data capture system to trackers.
• Administer data queries for lab results outside of normal ranges.
• Provide daily summary reporting to the medical team on patient progression.
• Retrieve data from the EDC for entry and produce reports for program management.
• Assist in compiling patient-specific clinical trial metrics as requested.
• Attend and record meeting minutes for weekly patient development meetings with executive, clinical, and medical teams.
• Serve as super user for clinical trial software, maintaining and updating data reports.

Requirements

• Bachelor's degree with 0 to 2 years of experience in science.
• Advanced proficiency in MS Office required.
• Strong attention to detail.
• Excellent written and oral communication skills with the ability to communicate across all levels of the organization.
• Flexibility in a fast-paced environment.
• Ability to work as part of a team and individually with minimal supervision.
• Desire to learn about drug discovery and data in practice.