BI Cloud Datawarehouse Developer II

Title:

BI Cloud Data warehouse Developer II

Location:

Midtown

Org Unit:
Business Intelligence

Work Days:
Weekly

Hours:

35.00

Exemption Status:
Exempt

Salary Range: $ - $

As required under NYC Human Rights Law Int  - Salary range for this role when Hired for NYC Offices

The Senior Cloud Data Engineer plays a key role in designing, developing, and implementing large-scale cloud data solutions to support the institution's Business Intelligence and analytics needs. This position is responsible for architecting and building scalable data integration, processing, and storage solutions across platforms such as Amazon Redshift, Snowflake, and Azure. The engineer develops robust data pipelines using Azure technologies and enterprise ETL tools including Informatica Intelligent Data Management Cloud (IDMC), SAP Data Services (BODS), SSIS, and Azure Data Factory.

The Senior Cloud Data Engineer drives the creation of high-quality, well-governed datasets by ensuring strong data quality practices, supporting Master Data Management (MDM) initiatives, and implementing data governance and cataloging capabilities. The role encompasses all phases of database and data engineering project work-from requirements gathering and data modeling to testing, deployment, and optimization. This position requires deep experience with cloud data architectures, enterprise ETL platforms, and modern BI ecosystems, including the Microsoft BI Stack (SSIS/Data Factory, Azure Data Warehouse, Azure Analytics/SSAS, and Power BI).

The engineer also designs and delivers integrated solutions leveraging SAP Business Warehouse (BW), SAP Data Services, Workday, and Workday Prism. This role ensures the delivery of reliable, scalable, and high-performance data solutions that support the institution's reporting, analytics, and strategic decision-making needs.

• Design and implement data migration, ingestion, and integration strategies, including Data Lake and multidimensional data modeling within Amazon Redshift, Snowflake, and Azure.
• Translate business requirements into scalable data models that drive Data Lakes and Data Warehouse architectures.
• Collaborate with cross-functional teams to gather, document, and validate business requirements for analytics and reporting initiatives.
• Build and maintain data ingestion pipelines for batch and real-time data movement, including CDC from cloud and on-premises applications into Data Lakes or raw zones.
• Design, develop, optimize, and support cloud data pipelines using Azure Data Factory, Azure Spark, AWS Glue, Snowpark, and SAP BODS.
• Transform unstructured and disparate data sources into curated datasets for Data Stores, Data Lakes, and Data Warehouses.
• Model data to support diverse reporting and analytics needs across cloud platforms such as Redshift, Azure Synapse, Google Big Query, and Snowflake.
• Identify data gaps and build new pipelines and automated processes to deliver enriched, high-quality datasets for enterprise applications and analytics.
• Partner with administrators and architects to design, configure, and secure Power BI solutions, including gateways, Azure integrations, and data connectors.
• Develop, maintain, and optimize dashboards, paginated reports, custom visuals, and analytics solutions using Power BI, DAX, SQL, and SQL Server.
• Build reporting and BI solutions leveraging SAP BW, SAP Data Services (BODS), Workday, and Workday Prism.
• Design and implement ETL/ELT workflows using Informatica IDMC, SAP BODS, SSIS, and Azure Data Factory.
• Develop integrations and reporting solutions across enterprise platforms including SAP, Workday/Prism, Redshift, Snowflake, SQL Server, and other data sources.
• Review, tune, and optimize data models, pipelines, and applications to improve performance, scalability, and reliability.
• Recommend best practices and enhancements to improve overall system efficiency and architecture quality.
• Support Master Data Management (MDM) initiatives and enforce data governance, cataloging, and metadata management standards.
• Ensure data consistency, quality, and stewardship across enterprise data platforms.
• Provide technical mentoring to team members on cloud…