Enterprise Data Integration Engineer

The Enterprise Data Integration Engineer is responsible for designing, developing, and maintaining data integration solutions across enterprise applications and databases. This role focuses on building and optimizing Extract/Transform/Load (ETL) processes using SQL, SSIS, and programming tools, while also performing data migrations and ensuring accuracy and consistency. The engineer will also partner with business stakeholders to gather requirements, analyze workflows, and translate them into effective technical solutions.

Locations:

Candidates must be able to report into one of the following NYBCe locations: Rye, New York; Kansas City, Missouri; Lincoln, Nebraska; St. Paul, Minnesota; Providence, Rhode Island, and Newark, Delaware.

Hybrid Role in office 3 days/week.

Lead the design and development of ETL processes using SQL, SSIS, and other integration platforms.
• Architect, build, and optimize enterprise data pipelines and workflows for scalability and performance.
• Plan, coordinate, and execute complex data migrations, including data mapping, validation, reconciliation, and quality assurance.
• Serve as a subject matter expert (SME) for data integration tools, practices, and methodologies.
• Provide technical guidance, code reviews, and mentoring to junior and mid-level engineers.
• Troubleshoot and resolve critical integration issues, ensuring system stability and reliability.
• Collaborate with business stakeholders to gather requirements and design effective integration solutions.
• Document integration architectures, data flows, and system designs.
• Ensure integrations comply with enterprise standards, data governance, security, and compliance requirements.
• Evaluate emerging integration technologies and recommend solutions to improve efficiency and scalability.
• Contribute to the development of integration standards, frameworks, and best practices.
• Support enterprise-wide initiatives requiring complex data integrations.
• Participate in strategic planning for data management and integration initiatives
• Any related duties as assigned.

Education:

• Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).

Experience:

• Minimum of 3 years' experience in data integration, ETL development, or closely related experience.
• Strong hands-on experience with ADF (Azure Data Factory), SSIS (SQL Server Integration Services), or similar ETL platforms.
• Proven experience in data migrations, data transformations, and data quality validations.
• Familiarity with at least one programming or scripting language (e.g. C#, Python, Powershell, etc.)

Licenses / Certification:

No licenses or certifications required for the position but encouraged.

• Microsoft Certified: Azure Data Engineer Associate.
• Microsoft Certified: Data Analyst Associate.

Knowledge, Skills & Abilities:

Knowledge:

• Proficiency in SQL development, performance tuning, and troubleshooting.
• Strong understanding of ETL concepts, data mapping, and integration patterns.

Skills:

• Cultural competency and the ability to communicate effectively in a culturally sensitive manner with both individuals and groups from diverse backgrounds.
• Detail-oriented with a focus on accuracy, compliance, and quality.
• Excellent communication and collaboration skills across technical and business teams.
• Analytical and problem-solving skills with strong attention to detail.
• Strong problem-solving skills and the ability to manage multiple priorities in a fast-paced environment.

Abilities:

• Adaptability to learn new integration tools and technologies.
• Ability to independently design, build, and support data integrations.
• Ability to work both independently and collaboratively across departments.
• Ability to balance both technical development and business analyst tasks.

Any combination of education, training and experience equivalent to the requirements above that has supplied the necessary knowledge, skills, and experience to perform the essential functions of the job.

For applicants who will perform this position in New York City or Westchester County, the proposed annual salary is $107,000.00p/yr. to $117,000.00p/yr.

For applicants who will perform this position outside of New York City or Westchester County, salary will reflect local market rates and be commensurate with the applicant's skills, job-related knowledge, and experience.

Position reporting into our Delaware location: $97,000 - $107,000

Positions reporting into our Rhode Island location: $105,000 - $115,000

Positions reporting into our Minnesota location: $105,000 - $115,000

Positions reporting into our Nebraska location: $97,000 - $107,000

Positions reporting into our Missouri location: $97,000 - $107,000

Founded in 1964, New York Blood Center (NYBC) has served the tri-state area for more than 60 years, delivering 500,000 lifesaving blood products annually to 150+ hospitals, EMS and healthcare partners. NYBC is part of New York Blood Center Enterprises (NYBCe), which spans 17+ states and delivers one million blood products to 400+ U.S. hospitals annually. NYBCe additionally delivers cellular therapies, specialty pharmacy, and medical services to 200+ research, academic and biopharmaceutical organizations. NYBCe's Lindsley F. Kimball Research Institute is a leader in hematology and transfusion medicine research, dedicated to the study, prevention, treatment and cure of bloodborne and blood-related diseases. NYBC serves as a vital community lifeline dedicated to helping patients and advancing global public health. To learn more, visit nybc.org. Connect with us on Facebook, X, Instagram, and LinkedIn.