Delivery Manager-Snowflake Data Engineer

<p><b><u>Job purpose </u></b></p><p>We are seeking a highly skilled and Snowflake‑certified Data Engineer to independently design, build, and optimize scalable data solutions across the enterprise. The ideal candidate will have deep hands-on expertise in </p><p>Snowflake architecture, data modeling, and end‑to‑end pipeline development, along with a strong understanding of cloud data ecosystems, API integration, and enterprise data platforms. This individual contributor role requires a self-driven engineer capable of owning complex data engineering initiatives end‑to‑end while ensuring performance, reliability, and alignment with business needs. </p><p><b><u>Key responsibilities </u></b></p><ul><li> Independently design and implement Snowflake databases, schemas, warehouses, RBAC, and workload management. </li><li>Configure and optimize Snowpipe, Streams, Tasks, Materialized Views, Clustering, and Time Travel. </li><li> Perform performance tuning and troubleshoot issues directly from the Snowflake portal. </li><li> Design robust dimensional and normalized data models aligned with financial domain needs. </li><li> Architect and implement Medallion (Bronze–Silver–Gold) data layers for scalable pipelines. </li><li>Ensure data quality, governance, and secure access patterns. </li><li> Build and manage end-to-end pipelines using: </li></ul><p>o dbt for transformations </p><p>o Python for automation </p><p>o Airflow/ADF for orchestration </p><ul><li> Implement and maintain CI/CD workflows, code reviews, and automated deployment processes. </li><li> Consume REST/SOAP APIs for data ingestion and integration. </li><li> Connect Snowflake with enterprise systems (Salesforce, SAP, CRM/ERP, cloud services). </li><li> Integrate Snowflake with cloud-native services for ingestion, compute, and storage. </li><li> Maintain high-performance, cost-efficient cloud data operations. </li><li> Take complete ownership of design, development, deployment, and support with minimal oversight. </li><li> Work directly with architects, business analysts, and stakeholders to translate requirements into solutions. </li><li> Produce high-quality documentation, reusable components, and engineering best practices. </li></ul><p><b><u>Key competencies </u></b></p><ul><li> Candidates should have a B.E./B.Tech/MCA/MBA in Information Systems, Computer Science or a related field </li><li> 10–12 years of hands-on data engineering experience, including a minimum of 6 years dedicated to Snowflake. </li><li> Advanced expertise in Snowflake architecture, implementation, administration, optimization, and troubleshooting. </li><li> Experience with Snowflake Data Sharing and Snowflake Marketplace for accessing, integrating, and managing third‑party and shared datasets. </li><li> Strong knowledge of data modeling and Medallion Architecture. </li><li> Proficiency in SQL, Python, and cloud ecosystem workflows. </li><li> Hands-on experience with dbt, Airflow, Azure Data Factory (ADF), or similar orchestration tools. </li><li> Experience integrating REST/SOAP APIs and connecting Snowflake with enterprise platforms (CRM/ERP/SaaS systems). </li><li> Strong exposure to Azure or AWS cloud data services. </li><li> Experience working in the financial domain (preferred but not mandatory). </li><li> Familiarity with CI/CD, Git workflows, automated deployments, and DevOps best practices. </li><li> Strong problem-solving skills, with ability to independently debug and resolve platform issues using Snowflake portal/console. </li><li> Excellent communication skills, self-driven attitude, and ability to work independently with minimal supervision. </li><li> Snowflake Certification (e.g., SnowPro Core or Advanced Data Engineer). </li> </ul>