Birlasoft

Senior Data Modeler – Technical Lead, Data Engineering

Birlasoft

full-time

Posted on:

Location Type: Office

Location: Pune • India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

CloudERPOracleSQL

About the role

  • 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.
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