Remote Data Integration Analyst II

Yale Cancer Center; New Haven, Northern (CT, KY); Hybrid; USD 68,000 - 121,000; Full time

Job summary

Yale Cancer Center in New Haven, CT, seeks a Data Integration Analyst II to support embedded analytics, reporting, data quality, and data integration for clinical research administration. You will work with OnCore, Epic, Salesforce, REDCap, and financial systems to develop reliable data products and automated workflows.

The role requires strong SQL skills, data analysis, and collaboration with operational teams and technical partners.

Qualifications

• Bachelor’s degree in business, technology or related field.
• Four years of related experience in analysis of business needs and development of related business systems or an equivalent combination of education and experience.

Responsibilities

• Develops the initial project charter and clarify the project scope, requirements, measurable outcomes, and project benefits in collaboration with process owners.
• Documents the “as is” and “to be” business processes using standard process modeling tools and process improvement methodologies.
• Decomposes high-level business and user requirements into functional requirements. Manages the development of functional specifications by collaborating with process owners; gathering business requirements; creating functional specifications; and identifying, documenting, and resolving design issues.
• Represents requirements using alternative views, such as analysis models (diagrams), prototypes, or scenarios. Provides compelling and concise analysis to enable business owners to make well informed decisions regarding options for problem resolution and opportunity realization.
• Leads requirements analysis and verification, ensuring that requirement statements are complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, and verifiable, and that they conform to standards.
• Contributes in testing and quality assurance process. Collaborates with developers and end-users to insure that application functionality meets client needs. Tests solutions, problem-solve issues, and coordinate enhancements.
• Responsible for requirements prioritization and solution risk analysis.
• Plans and communicates the departmental readiness plan. Supports metrics integration and execution for optimal results.
• Develops and delivers training to end users.
• May perform other duties as assigned.

Skills

SQL queries

Analytical thinking

Stakeholder communication

Data quality

Documentation

Education

Bachelor’s degree in business or technology

Four years of related experience

Tools

Python

dbt

Git/GitHub

APIs

ETL/ELT tools

Job scheduling

Job description

Yale Cancer Center in New Haven, CT, seeks a Data Integration Analyst II to support embedded analytics, reporting, data quality, and data integration for clinical research administration. You will work with OnCore, Epic, Salesforce, REDCap, and financial systems to develop reliable data products and automated workflows.

The role requires strong SQL skills, data analysis, and collaboration with operational teams and technical partners.