Semantic Data Modeler

1 day 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 Modeler

    1 week 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...

  • Senior Data Modeller

    7 days ago

    pune, India beBeeDataModeler Full time

    About the Job We are seeking an experienced Data Modeler to lead the design and implementation of data models across various enterprise domains. Key Responsibilities: Lead the creation, extension, and alignment of data models across enterprise domains (e.g., Manufacturing, R&D, Supply Chain, Quality). Define data modeling standards and best practices using...

  • Data Modeler

    6 days 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...

  • Data Modeller

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

  • Lead/Data Modeler

    4 days 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...

  • Business Data Strategist

    5 days ago

    pune, India beBeeBusiness Full time

    Business Intelligence DeveloperA visionary opportunity awaits for a skilled Business Intelligence Developer to craft interactive and informative dashboards, reports, and semantic models using Power BI and SSAS.Key Responsibilities:Create dynamic and user-friendly dashboards to effectively communicate insights to stakeholders.Design and develop reports that...

  • Data Modeller

    1 week ago

    Gera Commerzone SEZ, Pune, India Barclays Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job DescriptionPurpose of the roleTo design, implement, and maintain conceptual, Logical and Physical data models that meet business data/process and technology requirements, by using designs and data strategies across a wide selection of platforms. AccountabilitiesAnalysis and documentation of business requirements to translate them into data models...

  • Remote Sensing Analyst

    3 days ago

    Pune, Maharashtra, India Semantic Technologies & Agritech Services Private Limited Full time ₹ 2,50,000 - ₹ 7,50,000 per year

    Overview:Semantic Technologies and Agritech Services Pvt. Ltd., a leading technology firm established in 2014, specializes in cutting-edge agricultural solutions backed by big data analysis, digital technology, GIS Mapping, Satellite/Drone Imagery, and Weather Data. We're currently seeking a multi-skilled Remote Sensing Executive with an agricultural...

  • Data Modeler

    4 days ago

    pune, India Abacus Insights Full time

    About UsAbacus Insights is changing the way healthcare works for you. We're on a mission to unlock the power of data so health plans can enable the right care at the right time—making life better for millions of people. No more data silos, no more inefficiencies. Just smarter care, lower costs, and better experiences.Backed by $100M from top VCs, we're...

  • Data Modeler

    3 weeks ago

    Pune, India Best Infosystems Ltd. Full time

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