At New York Blood Center, one of the most comprehensive blood centers in the world, our focus is on cultivating excellence by merging cutting-edge innovation with diligent customer service, groundbreaking research, and comprehensive program and service development. Join us as we work towards meeting and exceeding the growing needs of our diverse communities, further our lifesaving strategic goals in a rapidly changing environment, and expand our impact on the local, national, and global communities we serve.

This position will work within the enterprise data engineering team to continuously build, maintain, and improve the design, performance, reliability, scalability, security, and architecture of the NYBCe enterprise data products.

Responsibilities include:

Develop robust database solutions, data integration (ETL, ELT) packages, automation, performance monitoring, SQL coding, database tuning and optimizations, security management, capacity planning, database HA, and database DR solutions across required data platforms.
• Conduct in-depth data analysis to support data product design.
• Identify and resolve production database and data integration issues.
• Collaborates closely with data quality, application, and visualization teams to deliver high-quality data products.
• Participate in code review, QA, release, and continuous deployment processes.

To qualify, you must have a Bachelors Degree in Computer Science or other quantitative disciplines such as Science, Statistics, Economics or Mathematics.

5+ years of progressive database development experience with the Microsoft SQL Server family suite. Must be familiar with data modeling and data architecture principles for both analytics and transactional systems. Hands-on experience with SQL Server, Oracle, or other RDBMS required.

Preferred Experience

ability to program or script in at least one other language other than SQL (Python, PowerShell, C#, Java, and/or R). Experience in the Microsoft Azure technology stack is a plus. Experience with the design and development of data models for transactional, integration, and analytical system is a plus. Experience with data analytics and visualization is a plus. Experience with at least one cloud data platform (Azure, Google, AWS)

Knowledge:
* Intermediate knowledge of OLTP and OLAP database design
* Intermediate knowledge of data modeling (normalized and dimensional)
* Intermediate knowledge of ETL, ELT architecture especially for real and near-real-time scenarios
* Intermediate knowledge of Data Architecture implementation patterns

For applicants who will perform this position in New York City or Westchester County, the proposed annual salary is $150,000/year to $160,000/year. 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.