YCCI Data Integration Analyst II Job Northern Kentucky USA,IT/Tech

Location: Northern

Working at Yale means contributing to a better tomorrow. Whether you are a current resident of our New Haven-based community, eligible for opportunities through the New Haven Hiring Initiative, or a newcomer, interested in exploring all that Yale has to offer, your talents and contributions are welcome. Discover your opportunities at Yale!

Overview

The Data Integration Analyst II supports YCCI’s embedded analytics, reporting, data quality, and data integration function. Reporting to the Senior Manager, Analytics, this position works with operational teams and technical partners to develop and maintain reliable data products and automated workflows supporting clinical research administration.

Key responsibilities include:

Develop and maintain data integrations, analytical datasets, reports, and workflow automation using data from systems such as OnCore, Epic, Salesforce, REDCap, and financial platforms.
Write and maintain SQL queries, data transformation logic, scripts, and scheduled processes that support recurring operational needs.
Assist with data pipelines that extract, transform, validate, and deliver data across approved systems and environments.
Monitor scheduled jobs, data refreshes, interfaces, and automated workflows; investigate failures and coordinate issue resolution.
Perform data quality reviews to identify missing, duplicate, inconsistent, stale, or incorrectly mapped records.
Reconcile information across systems and work with operational subject-matter experts to understand and resolve discrepancies.
Support the development, testing, documentation, and maintenance of dashboards, reports, work queues, and integration-ready datasets.
Create and maintain technical documentation, including data definitions, process flows, source mappings, testing results, and support procedures.
Participate in requirements gathering and translate operational needs into clearly defined technical tasks and validation criteria.
Use version control, testing, and established development standards to support maintainable and reproducible solutions.
Collaborate with YCCI operational teams, enterprise data teams, and application owners while maintaining clear distinctions between analytics and integration work and application administration.
Handle sensitive institutional and research data in accordance with privacy, security, and data governance requirements.

The position is well-suited for an analytical and technically curious individual who enjoys investigating data issues, learning complex business processes, and building dependable solutions that improve operational efficiency and data quality.

Required

Skills and Abilities

Demonstrated ability to write SQL queries for extracting, joining, transforming, and validating data from relational databases.

Strong analytical and problem-solving skills, including the ability to investigate discrepancies, identify root causes, and translate findings into practical solutions.

Ability to understand business processes and data requirements and communicate effectively with both technical and nontechnical stakeholders.

Strong organizational skills, attention to detail, and ability to manage multiple assignments while documenting work and meeting established deadlines.

Ability to learn new systems and tools, work both independently and collaboratively, and follow data privacy, security, testing, and change-management standards.

Preferred

Skills and Abilities

Experience with Python, dbt, Git or Git Hub, APIs, ETL/ELT tools, job scheduling, or other data integration and automation technologies.

Experience working with healthcare, clinical research, financial, or other regulated data, including familiarity with privacy and security requirements.

Experience with systems such as OnCore, Epic, Salesforce, REDCap, Workday, or comparable enterprise applications.

Experience developing or supporting dashboards and analytical products using Power BI, Tableau, or similar business intelligence tools.

Familiarity with cloud data platforms, data warehouses, lake houses, Microsoft Fabric, semantic models, data quality testing, or modern analytics engineering practices.

Principal Responsibilities

Develops the…