Birlasoft Limited

Senior Data Modeler Technical Lead - Data Engineering

Birlasoft Limited
Pune
Not disclosed
Work from OfficeWork from Office
Full TimeFull Time
Min. 17 yearsMin. 17 years

Job Description

Data Modeler Sr Technical Lead-Data Engg

Area(s) of responsibility

JD for the Lead Data Modeler with Snowflake:

 

  • Min 17+ years of overall experience in data engineering, data modeling, analytics engineering, or related roles, with 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 (client is using SQL DBM).
  • 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.

 

 

Experience Level

Senior Level

Job role

Work location
Work locationINDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI, IN
Department
DepartmentData Science & Analytics
Role / Category
Role / CategoryDBA / Data warehousing
Employment type
Employment typeFull Time
Shift
ShiftDay Shift

Job requirements

Experience
ExperienceMin. 17 years

About company

Name
NameBirlasoft Limited
Job posted by Birlasoft Limited

Similar jobs you can apply for

Software / Web Developer
Wyse Biometrics Systems Private Limited

Software Tester

Wyse Biometrics Systems Private Limited
Parvati Paytha, Pune
₹15,000 - ₹16,500
Work from Office
Full Time
Any experience
Basic English
Eco Tech Engineers

Quality Engineer

Eco Tech Engineers
Pune
₹25,000 - ₹30,000
Work from Office
Full Time
Any experience
Basic English
Biovision Process Engineering Pvt. Ltd.

Quality Assurance Executive

Biovision Process Engineering Pvt. Ltd.
Pune
₹10,000 - ₹12,500
Work from Office
Full Time
Freshers only
Basic English

Quality Engineer

Nigasavi Solutions Llp
Kothrud, Pune
₹20,000 - ₹30,000
Work from Office
Full Time
Min. 5 years
Basic English

Java Developer

THE NaukriWala
Pune
₹40,000 - ₹1,49,000
Work from Office
Full Time
Min. 2 years
Basic English
IBG Infotech Private Limited

Android Developer

IBG Infotech Private Limited
Hadapsar, Pune
₹10,000 - ₹15,000
Work from Office
Part Time
Full Time
Freshers only
Basic English