Description

Design and maintain enterprise data warehouses, cloud data lakes, and lakehouse architectures. You will build scalable ETL/ELT pipelines and optimize Snowflake solutions.

This role is on-site.

Responsibilities

• Design conceptual, logical, physical, and dimensional data models for enterprise platforms.
• Implement cloud-native data lake solutions using AWS S3, Parquet, Delta Lake, Hudi, and Iceberg.
• Develop and optimize scalable data integration pipelines including batch, CDC, and streaming architectures.
• Ensure high availability, performance, security, and scalability across data platforms while implementing DataOps and CI/CD practices.
• Collaborate with business users, analysts, and data scientists to deliver analytics solutions and support BI platforms.

Required Skills

• 7+ years of data modeling experience, including Conceptual, Logical, Physical, and Entity Relationship (ER) modeling.
• 5+ years of experience designing, implementing, and supporting enterprise Data Warehouses, with at least 2 years in Snowflake.
• 5+ years of ETL/ELT development and data integration experience using Informatica IDMC.
• 5+ years of SQL programming experience and experience with relational and NoSQL databases.
• 3+ years of cloud data lake development using AWS S3 and Apache Parquet.
• 3+ years of Python or similar object-oriented programming experience.
• 2+ years of Databricks Lakehouse implementation using Delta Lake, Apache Hudi, or Apache Iceberg.
• 2+ years of experience implementing DevOps/DataOps practices.
• 4+ years supporting Analytics & Business Intelligence platforms such as Qlik and Tableau.

Preferred Skills

• Experience supporting Dataiku machine learning environments and model lifecycle management.
• Knowledge of metadata management, data cataloging, and Master Data Management (MDM) using Informatica Customer 360.

Key Skills

Education

Bachelor's degree