Enterprise Data Integration Engineer

New York Blood Center Inc•City of Rye, NY

1d•$97,000 - $117,000•Hybrid

About The Position

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.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent 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.)
Proficiency in SQL development, performance tuning, and troubleshooting.
Strong understanding of ETL concepts, data mapping, and integration patterns.
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.
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.

Nice To Haves

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

Responsibilities

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.