Dimensional Modelling

1 day ago

Mumbai Pune, India Systechcorp Inc Full time ₹ 15,00,000 - ₹ 25,00,000 per year

Position: Dimensional Modelling & BI Solution Implementation

Location: Mumbai / Pune, India

Notice period: Only 15-30days

Experience: 8+yrs

Dimensional Modelling & BI Solution Implementation

  • 8+ years of experience in dimensional modelling using a top-down & hybrid approach
  • Expertise in implementing access/presentation layers in BI tools (e.g., Tableau, Power BI)
  • Strong hands-on experience applying advanced design patterns and techniques
  • Proven success delivering large-scale, greenfield projects

Business Domain & Requirement Analysis

  • Deep understanding of the Life Insurance domain
  • Skilled in requirement analysis, translating business needs into dimensional models
  • Focus on optimization, data quality, and governance

Team Lead & Consultancy skills

  • Lead a team of modelers to deliver dimensional models & end-to-end BI solutions for an enterprise
  • Organized, results-oriented, and self-motivated with excellent communication and problem-solving skills
  • Ability to collaborating & manage client, engineers, architects, PM and other stakeholders in a project
  • Support PM in project planning
  • Willing to travel to LIC site in Mumbai
  • Can-do attitude with minimal behavioural issues

Data Discovery & Mapping

  • Proficient in medallion architecture
  • Skilled at tracing data flow from silver (3NF) to Gold layer (dimensional)
  • Experienced in designing efficient data mappings and integrating business rules
  • Close collaboration with relevant teams

Tools & Technology

  • Erwin
  • Teradata architecture & tools
  • Advance SQL
  • ETL pipelines

Agile Method of Delivery

  • Well versed with leading & delivering a project in an agile manner

  • Lead BI

    4 days ago

    Pune, India Systechcorp Full time

    Key Responsibilities :- 8+ years of experience in dimensional modelling using top-down and hybrid approaches.- Implement access/presentation layers in BI tools such as Tableau, Power BI, etc.- Apply advanced design patterns and modelling techniques to deliver high-quality solutions.- Proven track record in large-scale, greenfield BI projects.- Deep...

  • Tolerance Validation of Dimensional

    5 days ago

    Pune, India Tata Technologies Full time

    **Skills**: - Dimensional/ tolerancing experience. - Strong understanding of GD&T concepts and documentation. Self-motivated. - Able to meet deadlines. - Strong analytical and problem solving skills. Knowledge in basic statistics and process control. - Strong communication skills with ability to work with cross-functional teams. - Familiarity with gaging,...

  • Data Modelling

    3 days ago

    Pune, Maharashtra, India Sureminds Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    5 to 8 years of data modelling experience in a large enterprise. Dimensional data modeling is a key requirement.Should be good at translating business requirements into conceptual, logical, and physical data models.Knowledge of Star-Schema Modelling, Snowflake Schema Modelling, Fact, and Dimension tables.Demonstrable experience in modeling using a variety...

  • Data Modeller

    2 weeks ago

    Pune, Maharashtra, India Optimum Solutions Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Roles and ResponsibilitiesDesign data models using Erwin/Snowflake to meet business requirements.Develop dimensional models for data warehousing purposes.Collaborate with stakeholders to gather requirements and create conceptual, logical, and physical data models.Ensure consistency across multiple platforms by maintaining a single source of truth for data...

  • Data Modeller

    7 days ago

    Pune, Maharashtra, India Inwinteck Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Responsibilities:* Develop data models using ERwin, SQL & Dimensional Modeling.* Implement tools & manage metadata.* Collaborate with stakeholders on model development & documentation.Provident fund

  • Data Modeler

    3 weeks ago

    Mumbai, India Tata Consultancy Services Full time

    Job Title: Senior Data Modeler Exp Range: 8- 14 years Job Location: Kolkata Only Job Description: Required skill: Kimball, Inmon, Data Vault and Dimensional Modelling Data Modelling Expertise o Proficient in designing conceptual, logical and physical data models o Skilled in methodologies such as Kimball, Inmon, Data Vault and Dimensional Modelling o...

  • Data Modeler

    3 weeks ago

    Mumbai, India Tata Consultancy Services Full time

    Job Title: Senior Data Modeler Exp Range: 8- 14 years Job Location: Kolkata Only Job Description: Required skill: Kimball, Inmon, Data Vault and Dimensional Modelling Data Modelling Expertise o Proficient in designing conceptual, logical and physical data models o Skilled in methodologies such as Kimball, Inmon, Data Vault and Dimensional Modelling o...

  • Data Modeler

    3 weeks ago

    Mumbai, India Tata Consultancy Services Full time

    Job Title: Senior Data Modeler Exp Range: 8- 14 years Job Location: Kolkata Only Job Description: Required skill: Kimball, Inmon, Data Vault and Dimensional Modelling Data Modelling Expertise o Proficient in designing conceptual, logical and physical data models o Skilled in methodologies such as Kimball, Inmon, Data Vault and Dimensional Modelling o...

  • Data modeler

    2 weeks ago

    Pune, India Best Infosystems Ltd. Full time

    Data Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...

  • Data Modeler

    2 weeks ago

    Pune, India Best Infosystems Ltd. Full time

    Data Modeler_Full-Time_Pune /Bangalore (Hybrid , 3 Days WFO)Job Title: Data ModelerJob Type: Full-TimeLocation: Pune /Bangalore (Hybrid , 3 Days WFO)Shift Timing: 2:30 PM to 10:30 PMExperience: 10-14 YearsJob Description:• Creation and management of business data models in all their forms, including conceptual models, logical data models and physical data...