Remote Data Integration Analyst II Build Trusted Data Flows

Yale University; New Haven (CT); On-site; USD 68,000 - 121,000; Full time

Job summary

Yale University in New Haven is seeking a Data Integration Analyst II to support embedded analytics, reporting, data quality, and data integration for clinical research administration.

You will develop and maintain data integrations from OnCore, Epic, Salesforce, REDCap, and financial systems; write SQL queries, data transformation logic, and automated workflows; monitor jobs and assist with dashboards and documentation while upholding data privacy and governance standards.

Qualifications

• 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 and translate findings into practical solutions.
• Ability to understand business processes and data requirements and communicate with technical and nontechnical stakeholders.
• Strong organizational skills, attention to detail, and ability to manage multiple assignments while documenting work.
• Ability to learn new systems and tools, work independently and with others, and follow data privacy and security standards.

Responsibilities

• Develops and maintain data integrations, analytical datasets, reports, and workflow automation from multiple systems.
• Write and maintain SQL queries, data transformation logic, scripts, and scheduled processes.
• Assist with data pipelines that extract, transform, validate, and deliver data across systems.
• Monitor scheduled jobs, data refreshes, interfaces, and automated workflows; investigate failures.
• Perform data quality reviews to identify missing or inconsistent records and resolve discrepancies.
• Support dashboards, reports, work queues, and integration-ready datasets.
• Create and maintain technical documentation including data definitions and process flows.
• Participate in requirements gathering and translate needs into technical tasks and validation criteria.
• Collaborate with teams while maintaining clear distinctions between analytics and integration work.

Skills

SQL queries

Analytical thinking

Stakeholder communication

Documentation

Data privacy & security awareness

Education

Bachelor's degree in business, technology or related field

Four years of related experience

Tools

Git

Power BI

Tableau

Python

dbt

APIs

ETL/ELT tools

Job description

Yale University in New Haven is seeking a Data Integration Analyst II to support embedded analytics, reporting, data quality, and data integration for clinical research administration.

You will develop and maintain data integrations from OnCore, Epic, Salesforce, REDCap, and financial systems; write SQL queries, data transformation logic, and automated workflows; monitor jobs and assist with dashboards and documentation while upholding data privacy and governance standards.