Lead Data Warehouse Engineer
Core
Architecting and maintaining Operational data stores, Enterprise Data Warehouse, data lakes, and data marts while designing performance data movement pipelines for large-scale cloud data platforms.
Role type
Senior Lead Data Warehouse Engineer
Builds
Next-gen cloud hosted data platform, ETL pipelines, data intelligence environments
Domain
Financial Technology / Cloud Data Engineering
Required skills
Cloud data warehouse platforms (Azure/AWS Databricks, Redshift, Snowflake), Informatica IDMC, Relational DBs (SQL Server, PostgreSQL, Oracle), Python/Unix Shell scripting, OLAP data modeling, Performance tuning, Distributed systems design
Preferred skills
Financial technology domain knowledge, NoSQL DBs (MongoDB, Cassandra, Azure Cosmos DB), Cloud certifications
Technologies
Informatica, Databricks, Apache Kafka, Azure Event Hub, SQL Packages, MS SQL Server, PostgreSQL, Oracle, Python, Unix Shell
Responsibilities
Architecting and maintaining ODS, EDW, data lakes, and data marts; Designing and implementing performance data movement pipelines using ETL tools; Developing scalable frameworks for structured and semi-structured data ingestion; Gathering business requirements and translating them into logical and physical data models; Conducting design reviews and communicating artifacts with stakeholders; Creating source to Target data mappings; Optimizing database features for performance and scalability; Delivering proofs of concept to stakeholders; Leading Master Data Management, Data Quality & Data Governance initiatives; Resolving critical production issues and errors.
Seniority
Senior, hands-on IC with leadership responsibilities
