Semantic Data Modeler

4 days ago

Pune, India Teradata Full time

**Role**: Semantic Data Modeler - Finance Industry

**Job Location**: - Mumbai/ Pune/ Bangalore

Education Requirement

Bachelor’s Degree (or higher) preferably in Computer Science, Information Systems, Mathematics or other related fields

Skills and Attributes

6- 12 years of overall experience in data warehouse

4 - 6 years of Dimensional Modelling expert - Kimball Approach.

2 - 3 years of Database Design experience in Teradata.

In depth knowledge of Semantic Layer and Integration layer

Banking Domain knowledge

Business Understanding

Good communication skills (both written as well as oral). Communicates equally well with business people and technical team members.

Work in a collaborative environment

Focus on immediate project scope without losing sight of the big picture

Knowledge of data modeling philosophies and techniques, including Inmon and Kimball.

Provide thought leadership on best practices while designing the foundation and semantic layer

Good Understanding of key Processes in, Banking (GL/Deposit/Loan/Bills/Instrument/Debit card/Credit card/Internet Banking), Investment Banking (Mutual Fund/IPO/Bond/Derivative /Portfolio management/Merger & Acquisition) and Insurance (General business/Life insurance/ Property & Casualty).

Knowledge of Teradata Financial Services model (FS-DM) or Sound business knowledge of any Banking/Investment/Insurance industry data model for data warehouse.

Job Responsibilities

Creating high level Common Semantic layer Architecture based on customer expectations. Review it with SMEs from client side and baseline the high level model.

Owning the end to end Semantic modelling work

Analyze business requirements to determine the data elements needed in the Semantic Layer

Create necessary access layer objects for Facts, Dimensions to meet the business requirements

Should have good knowledge of Star Schema Design using the Kimball approach.

Must have good knowledge of OLAP queries, Aggregates, and usage of analytical functions in SQL queries.

Good understanding of any one BI tool like Tablue /Cognos/Business Objects etc.

Must have created interactive dashboards using any of the UI tools.

Interact with Business SMEs to understand required data elements, the business rules governing them and confirm definitions

Create, manage and modify conceptual, logical and physical data models for Semantic Layers. Present data models to business and technical audiences for review and validation

Implement Data Profiling Develop/maintain all target-from-source mappings - Business Requirements to Access Layer data model(s); Access Layer data model(s) to Core Layer data model, Core Layer data model to Acquisition Layer ;
Stakeholder’s interaction includes Enterprise Architects, Development Team, Business Intelligence team, Business SMEs, technology vendors etc.

  • Semantic Data Modeler

    3 days ago

    Hyderabad / Pune / Mumbai, India CRISIL Ltd Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Semantic Data Modeler Department Corporate Group Job Description Job description: We are seeking a highly skilled Semantic Data Modeler to join our data and AI team. This role will focus on designing and implementing canonical models, ontologies, and taxonomies to enable a unified semantic layer that bridges structured data from multiple silos...

  • Semantic Data Modeler

    2 weeks ago

    Hyderabad, Mumbai, Pune, India Crisil Full time ₹ 12,00,000 - ₹ 22,00,000 per year

    Job description:We are seeking a highly skilled Semantic Data Modeler to join our data and AI team. This role will focus on designing and implementing canonical models, ontologies, and taxonomies to enable a unified semantic layer that bridges structured data from multiple silos (RDBMS and other sources) into AI-ready, knowledge-driven assets. The ideal...

  • Semantic Modeler

    2 weeks ago

    Pune, India Teradata Full time

    **Role**: Semantic Modeler **Job Location**: - India Position Overview - Teradata is looking for highly motivated and experienced individuals to join our Global Consulting Center (GDC) Business Intelligence (BI) team as a Semantic Modeler. To be part of the data revolution by performing hands on data analysis and developing analytical solutions to produce...

  • Data Modeler

    1 week ago

    Pune, India Teradata Full time

    **Role**: Data Modeler Specialist **Educational Requirements**: Bachelor’s degree from a reputed Educational Institute. Post-graduate degree is a plus **Technical Skill Set Required**: 5-8 years of IT Exp 3+ Years of Teradata Development experience Performed Low/ High Level Design activities Good understanding of Teradata database architecture and...

  • Senior Data Modeler

    2 weeks ago

    Pune, Maharashtra, India Gentrack Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    The CompanyGentrack provides leading utilities across the world with innovative cleantech solutions. The global pace of change is accelerating, and utilities need to rebuild for a more sustainable future.  Working with some of the world's biggest energy and water companies, as well as innovative challenger brands, we are helping companies reshape what it...

  • Senior Data Modeler

    3 weeks ago

    Pune, India ElementSkill Full time

    We are seeking a highly skilled Senior Data Modeler to lead the design, governance, and optimization of enterprise data models within our Data & Analytics platform. In this role, you will develop scalable, modular, and business-aligned models that serve as the foundation for analytics and reporting across multiple regions and clients.Working closely with...

  • Data Modeller

    3 days ago

    Pune, Maharashtra, India Barclays Full time ₹ 10,000 - ₹ 25,000 per year

    Join us for a role in " Data Modeller" at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionize our digital offerings, ensuring unapparelled customer experiences.To be successful as a "Data Modeller", you should have experience with:Strong analytical...

  • Senior Data Modeler

    5 days ago

    Bengaluru, Chennai, Pune, India Photon Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    About The Role   Location:  ChennaiExperience:  6-9 YearsJob Summary: We are looking for a highly skilled Senior Data Modeler  with extensive experience in data modeling, SQL, metadata management, and data governance . The ideal candidate will have expertise in relational, dimensional, and analytic data modeling  with hands-on experience in databases...

  • Lead Data Modeler

    3 days ago

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

    Position: Lead Data ModelerLocation: Mumbai/PuneWhat Youll DoDevelop conceptual, logical, and physical data models to represent various data domains, ensuring accuracy, consistency, and scalability.Define data structures, relationships, and attributes that capture business requirements and enable efficient data storage and retrieval.Collaborate with business...

  • Lead/Data Modeler

    1 day ago

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

    Role: Lead/Data Modeler - Insurance DomainExperience: 5+yrsNotice period: Only 15-30daysLocation: Mumbai/Pune LocationWhat Youll DoDevelop conceptual, logical, and physical data models to represent various data domains, ensuring accuracy, consistency, and scalability.Define data structures, relationships, and attributes that capture business requirements and...