SNOWFLAKE DATA ENGINEER

Designed and developed enterprise Snowflake Views and tables (CV, B$, B, VIZ, DQ) supporting Supply Chain and Inventory Analytics. Engineered enterprise-scale Snowflake data models and reusable canonical views supporting Inventory Management, Consignment, Order Fulfillment, and Supply Chain Analytics across SAP ERP environments. Designed scalable SQL transformation frameworks using advanced analytical functions, recursive CTEs, QUALIFY clauses, and window functions to process complex SAP inventory transactions efficiently. Automated business-critical inventory processing through reusable Snowflake objects eliminating manual execution while improving pipeline reliability. Built enterprise Data Quality framework that reduced reporting inconsistencies by 35% and improved downstream data accuracy. Reduced Snowflake query execution time by 40% through SQL optimization and warehouse tuning. Developed production-ready analytical views powering executive Power BI dashboards used for operational reporting and strategic supply chain decision-making. Collaborated closely with Supply Chain SMEs, SAP Functional Consultants, Product Owners, and Data Governance teams to translate business requirements into scalable enterprise data solutions throughout the software development lifecycle. Worked with curated SAP ERP datasets including MARC, MSEG, MKPF, LTAP, LTAK, Material Documents, Inventory Transactions, Sales Orders, and Inventory Management data.

Owned end-to-end development of enterprise ETL pipelines using Snowflake, Matillion, and DBT, ensuring reliable and scalable cloud data processing. Modernized transformation workflows through modular DBT models across staging, intermediate, and mart layers, improving maintainability and accelerating feature delivery. Implemented historical tracking using DBT Snapshots, enabling accurate point-in-time reporting and audit-ready dimensional data management. Established automated CI/CD deployment pipelines (GIT HUB -DBT) integrating DBT Cloud and version control, reducing deployment effort and improving release consistency. Designed reusable Jinja macros and YAML-based documentation standards that improved code reusability, lineage visibility, and developer productivity. Implemented comprehensive DBT testing strategies including uniqueness, null validation, referential integrity, and custom business-rule validation to improve overall data quality. Served as the primary technical owner for Snowflake and Matillion production support, rapidly resolving complex data engineering issues while maintaining platform stability. Mentored new engineers on Snowflake, Matillion, and DBT development standards, accelerating onboarding and promoting engineering best practices.

Supported enterprise migration of Oracle and SQL Server workloads into Snowflake, enabling modernization of finance reporting platforms. Built foundational Snowflake database objects including stages, tables, file formats, and transformation pipelines supporting scalable cloud data ingestion. Developed automated batch loading processes using COPY commands and Snowflake utilities to improve operational efficiency. Implemented Streams and Tasks to enable incremental processing and improve synchronization across downstream systems. Collaborated with business analysts and production support teams to resolve data issues, improve reporting accuracy, and ensure timely delivery of business-critical requests.