Senior Data Modeler – Technical Lead, Data Engineering

Birlasoft

Lead Data Modeler with Snowflake requires 17+ years of experience in data engineering and architecture. Involves data modeling and collaboration with Database admins and Data Engineers.

Posted 4/15/2026full-timePune • 🇮🇳 IndiaSeniorWebsite

Tech Stack

Tools & technologies

CloudERPOracleSQL

About the role

Key responsibilities & impact

JD for the Lead Data Modeler with Snowflake
Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality
Experience designing Data Marts and Data Warehouses on Enterprise Scale
Knowledge in both OLTP and OLAP Modelling
Solid understanding of modern data lake and medallion architecture, including bronze, silver, and gold layers

Requirements

What you’ll need

Min 17+ years of overall experience in data engineering, data modeling, analytics engineering, or related roles
Minimum 8-10 years being Data Modeler or Data Architect
Expertise in data modeling, including dimensional modeling, fact table design, conformed dimensions, and Slowly Changing Dimensions (SCD Type 1 and Type 2)
Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements
Experience in ERWIN, SQL Database Modeler (SQL DBM) or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred
Knowledge in both OLTP and OLAP Modelling
Solid understanding of modern data lake and medallion architecture, including bronze, silver, and gold layers
Very good hands-on knowledge/experience with complex SQL queries
Experience designing Data Marts and Data Warehouses on Enterprise Scale
Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality
Data modeling ERP domain experience in at least one platform, such as Oracle EBS, JDE, or Oracle Cloud ERP
Experience in Snowflake Data Cloud, including virtual warehouses, roles and security, stages and file formats, tasks and streams, and features such as Time Travel and Fail-safe
Additional experience in Oracle and SQL Server Databases preferred.

Benefits

Comp & perks

🌐 Worldwide Post a Job Affiliates ❌ Jobs You've Hidden ⭐️ Saved Jobs ✅ Applied Jobs Account Birlasoft Website LinkedIn All Job Openings 10,000+ employees 🤝 B2B 🏢 Enterprise B2B
Enterprise Birlasoft is a global IT services and digital transformation company that helps enterprises modernize and run mission-critical systems using cloud, ERP (Oracle, JD Edwards, SAP), intelligent automation, analytics, and AI-powered platforms. It delivers industry-focused solutions across banking and financial services, manufacturing, energy, life sciences, and more, and partners with major technology providers to implement cloud migrations, enterprise integration, e‑commerce, and data-driven applications for large B2B clients and Fortune 500 companies. Senior Data Modeler – Technical Lead, Data Engineering 🔥 1 minute ago 🏢 Pune – Onsite ⏰ Full Time 🟠 Senior 🧑‍💻 Full-stack Engineer Cloud ERP Oracle SQL Apply Now Find Hiring Managers Customize resume for this job ☆ Save ☑️ Mark as applied ❌ Hide Report problem 📋 Description
JD for the Lead Data Modeler with Snowflake
Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality
Experience designing Data Marts and Data Warehouses on Enterprise Scale
Knowledge in both OLTP and OLAP Modelling
Solid understanding of modern data lake and medallion architecture, including bronze, silver, and gold layers 🎯 Requirements
Min 17+ years of overall experience in data engineering, data modeling, analytics engineering, or related roles
Minimum 8-10 years being Data Modeler or Data Architect
Expertise in data modeling, including dimensional modeling, fact table design, conformed dimensions, and Slowly Changing Dimensions (SCD Type 1 and Type 2)
Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements
Experience in ERWIN, SQL Database Modeler (SQL DBM) or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred
Knowledge in both OLTP and OLAP Modelling
Solid understanding of modern data lake and medallion architecture, including bronze, silver, and gold layers
Very good hands-on knowledge/experience with complex SQL queries
Experience designing Data Marts and Data Warehouses on Enterprise Scale
Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity
Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality
Data modeling ERP domain experience in at least one platform, such as Oracle EBS, JDE, or Oracle Cloud ERP
Experience in Snowflake Data Cloud, including virtual warehouses, roles and security, stages and file formats, tasks and streams, and features such as Time Travel and Fail-safe
Additional experience in Oracle and SQL Server Databases preferred. Apply Now 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score Similar Jobs Senior System Software Engineer – GPU Virtualization 🔥 7 hours ago NVIDIA 10,000+ employees 🤖 Artificial Intelligence 🎮 Gaming Website LinkedIn All Job Openings Senior System Software Engineer for GPU Virtualization at NVIDIA, designing next-generation graphics features and collaborating with internal teams. Requires strong experience in device drivers and software optimization in a fast-paced environment. 🏢 Pune – Onsite ⏰ Full Time 🟠 Senior 🧑‍💻 Full-stack Engineer Linux Senior Engineer – Operative Purchase 🔥 9 hours ago Liebherr Group 10,000+ employees 🚀 Aerospace Website LinkedIn All Job Openings Senior Engineer managing purchasing records and ensuring smooth operations for Liebherr CMCtec India. Collaborating with departments and suppliers, ensuring compliance and timely deliveries in procurement. 🏢 Pune – Onsite ⏰ Full Time 🟠 Senior 🧑‍💻 Full-stack Engineer Advisory Software Engineer 🕒 2 days ago Pitney Bowes 10,000+ employees ☁️ SaaS 🏢 Enterprise 🚗 Transport Website LinkedIn All Job Openings Cloud Security Engineer ensuring compliance and security for hybrid cloud systems. Collaborating with various teams to assess security needs and implement standards. 🏢 Pune – Onsite ⏰ Full Time 🟡 Mid-level 🟠 Senior 🧑‍💻 Full-stack Engineer AWS Azure Cloud Cyber Security Firewalls Google Cloud Platform ITSM Python SDLC Terraform VMware Advisory Software Engineer 🕒 2 days ago Pitney Bowes 10,000+ employees ☁️ SaaS 🏢 Enterprise 🚗 Transport Website LinkedIn All Job Openings Senior network security Engineer for Zero Trust and Network security architecture team at Pitney Bowes. Ensuring implementation, operation, and optimization of zero trust solutions. 🏢 Pune – Onsite ⏰ Full Time 🟡 Mid-level 🟠 Senior 🧑‍💻 Full-stack Engineer Cloud Firewalls Python Terraform Senior Engineer – Design, Legacy Data 🕒 4 days ago Liebherr Group 10,000+ employees 🚀 Aerospace Website LinkedIn All Job Openings Senior Engineer responsible for structural design and data migration of tower cranes. Collaborating with teams and ensuring compliance with engineering standards in Pune, India. 🏢 Pune – Onsite ⏰ Full Time 🟠 Senior 🧑‍💻 Full-stack Engineer View More Full-stack Engineer Jobs 🌐 Worldwide Built by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com Search Search Jobs by country Search jobs by city Search jobs by job title Search entry-level jobs Search junior-level jobs Search senior-level jobs Search jobs by tech stack Search jobs by contract type Search remote internships Search remote part-time jobs Remote jobs Anywhere in the World Companies Hiring Anywhere in the World Companies Hiring Sales People Anywhere in the World Companies Hiring Software Engineers Anywhere in the World Resources Advice Tips for finding remote jobs Interview questions and answers Resume examples Cover letter examples Post a job Affiliates Privacy policy Terms of service Job board SEO course AI Apply Copilot OpenClaw job finder Jobs by Country Remote jobs anywhere in the world (Worldwide remote jobs) Remote jobs United States Remote jobs Australia Remote jobs Brazil Remote jobs Canada Remote jobs France Remote jobs Ireland Remote jobs Germany Remote jobs Netherlands Remote jobs Spain Remote jobs UK Popular Jobs Remote data analyst jobs Remote customer support jobs Remote executive assistant jobs Remote marketing jobs Remote product designer jobs Remote product manager jobs Remote project manager jobs Remote recruiter jobs Remote sales jobs Remote software engineer jobs Jobs by Type Remote full-time jobs Remote part-time jobs Remote contract jobs Remote internship jobs Remote entry-level jobs Remote jobs with no experience required Remote junior jobs (1-3 years of experience) Digital nomad jobs Remote jobs with no degree required Freelance remote jobs Temporary remote jobs Remote jobs hiring now Stay at home mom jobs

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data modelingdimensional modelingfact table designconformed dimensionsSlowly Changing Dimensions (SCD Type 1 and Type 2)complex SQL queriesdata mart designdata warehouse designOLTP modelingOLAP modeling

Soft Skills

collaborationcommunicationproblem-solvingattention to detailorganizational skills