Senior Snowflake Data Engineer

Experience: Not Available to Not Available years

Location: Pune, Maharashtra, India

Skills: Snowflake Data Cloud, SAP, Oracle ERP, Microsoft Dynamics, NetSuite, Snowflake, SQL, AWS, Azure, GCP, ETL, ELT, dbt, Matillion, Informatica, Talend, Fivetran, Airbyte, Azure Data Factory, Python, Shell scripting, Kimball, Data Vault, Lakehouse, Power BI, Tableau, Looker, SnowPro certification

Job Description
We are looking for an experienced Senior Snowflake Resource with strong expertise in Snowflake Data Cloud and hands-on experience integrating data from leading ERP systems such as SAP, Oracle ERP, Microsoft Dynamics, NetSuite, or similar platforms. The ideal candidate will drive enterprise data modernization initiatives, build scalable cloud data platforms, and enable seamless ERP-to-analytics integrations.

Key Responsibilities
Snowflake Architecture & Development
Design, develop, and optimize enterprise-grade data solutions on Snowflake. Build scalable data models, schemas, pipelines, and performance-tuned workloads. Implement best practices for Snowflake security, governance, RBAC, masking, and data sharing. Optimize Snowflake costs through warehouse sizing, clustering, resource monitors, and query tuning.

ERP Data Integration
Lead integration of ERP systems (SAP / Oracle / Dynamics / NetSuite / JD Edwards etc.) into Snowflake. Design ingestion frameworks for ERP modules such as Finance, Supply Chain, Procurement, Sales, HR, Manufacturing. Build batch and real-time pipelines using ETL/ELT tools. Understand ERP source tables, transactional flows, master data, and reporting structures. Enable harmonization of ERP data with CRM, legacy, and third-party systems.

Data Engineering & Transformation




Develop ELT pipelines using tools such as dbt, Matillion, Informatica, Talend, Fivetran, Airbyte, or Azure Data Factory. Create dimensional models, fact/dimension structures, and semantic layers for reporting. Implement CDC, SCD, incremental loading, and reconciliation frameworks. Ensure data quality, lineage, auditability, and observability.

Stakeholder & Delivery Management
Work closely with business teams, ERP functional consultants, finance users, and analytics teams. Translate business requirements into scalable Snowflake solutions. Provide technical leadership to developers and junior engineers. Support estimations, solutioning, and presales discussions.

Required Skills
Technical Skills
6+ years in Data Warehousing / Data Engineering. 3+ years hands-on experience with Snowflake. Strong SQL and performance tuning expertise. Experience with cloud platforms: AWS / Azure / GCP. Experience with ETL/ELT tools and orchestration frameworks. Strong understanding of data modeling (Kimball / Data Vault / Lakehouse concepts). Hands-on experience with Python / Shell scripting.

ERP Knowledge
Robust knowledge of one or more ERP systems: SAP ECC / S4HANA Oracle EBS / Fusion Microsoft Dynamics NetSuite Infor / JD Edwards Understanding of ERP functional domains: Finance (GL, AP, AR, FA) Procurement Order to Cash Inventory / Supply Chain HR / Payroll.

Nice to Have
Experience with Power BI / Tableau / Looker. dbt experience. SnowPro certification. ERP migration or transformation project experience.

Preferred Candidate Profile
Strong communication and stakeholder management skills. Ability to work independently in client-facing roles. Experience leading offshore/onshore delivery teams. Strong troubleshooting and problem-solving mindset.

📌 Senior Snowflake Data Engineer (Pune)
🏢 Jade Global Software
📍 Pune