Data Engineer
Core
Own the management and development of the Snowflake data warehouse serving as the central repository for ESG data, analytics, and client reporting.
Role type
Senior Data Engineer (Data Warehouse & Pipelines)
Builds
Centralized Snowflake data warehouse, ETL/ELT pipelines connecting Oracle and client-specific warehouses, automated exports, and data visualizations.
Domain
Fund Administration / ESG Data / Cloud Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Snowflake administration and optimization, SQL, Python, Data Warehousing and Data Modeling, Relational Database integration (Oracle, SQL Server, PostgreSQL), Cloud Data Lakes (AWS/Azure), ETL/ELT tools (Glue, Data Factory, Fivetran), Cloud workflow services (Step Functions, Logic Apps), Event management (Lambda, Functions), API development.
Preferred skills
AWS Redshift, Azure Synapse, PowerBI/QuickSight/Mode, Messaging systems (Kafka, RabbitMQ, SQS/SNS), Microsoft BI Stack (SSIS, SSAS, SSRS).
Responsibilities
Manage and optimize Snowflake schemas, views, tables, and environments; Build and maintain data pipelines between Oracle, Snowflake, and client warehouses; Design client-specific tables/views with Row Level Security (RLS); Prepare and expose data for downstream consumption via exports and APIs; Identify and implement pipeline improvements for faster data delivery; Document and maintain the modern data platform; Provide guidance to downstream data consumers.
Seniority
Senior, hands-on IC