Data-modeller-build

6 months ago

Bengaluru Karnataka, India Titan Company Full time

Data Modeller - BI ( Project Manager)

**Unique Job Role**
Data Modeller - BI

**Function**
Digital

**Reporting to**
Senior Manager - IT

**Business**
All

**Grade**
L5/L6

**Date**
11-Nov-2022
Job Details
Technical Lead in the Data Architecture Domain, Responsible for the design and creation of standard and benchmark data models using Layered Scalable Architecture concepts to deliver the Data Marts across all Businesses of Titan. This includes complexities like several decades of Business Data, External Data, high volume, complex structure, Performance & Costs.
Should have expertise in RDBMS concepts, data warehousing, modelling and agile concepts and have strong hands on experience in SQL
External Interfaces
Internal Interfaces
- Qualitest
- Empower sys / Aliment
- Tableau India Pvt Ltd
- Alpharithm
- CRG
- AWS
- SAP
- IBM
- Google
- Technical consultants of BI
- Functional consultants / Business Analysts
- Business users
- Testing Team
- Development Team
Job Requirements
Education
- Scenario 1: Engineering
- Scenario 2: MCA Graduation
Relevant Experience
- Scenario 1: >4 Years
- Scenario 2: >6 Years
Behavioural Skills
- Good Communication & Interpersonal skills
- Excellent Analytical skills
- Problem solving/troubleshooting
- Excellent Team player
Knowledge
- Strong Technical knowledge of SQL, RDBMS, Data Warehousing and Modelling
- Minimum 3 projects implementation experience in Retail/Manufacturing/HR/Finance domains
- Good Knowledge on ETL tools ( min 1 tool)
- Good process knowledge of minimum one Domain
- Experience in Project management - atleast 3 medium to complex project
Process Contributions
Process Contribution
Process Outcome
Performance Measure
Digital: Business KPI for Various Personas
1. Ability to translate requirements / functional specifications to Technical Specifications and the Business KPI/ metrics based on user requirements.
2. Calculation of various derived KPI/metrics using logic shared by business
3. Understanding the Granularity of Data for various KPI/metrics.
- Technical Specification
- Metrics calculation using SQL functions / Stored Procedure
- Dimension to Measure Matrix
- Technical Specification Document of KPI/Metrics for various functions
- Algorithm and Pseudo code to build the data mart layers
Digital: Data Requirement and Source Mapping
1. Data
2. Understanding Data granularity and availability of Data in source system
- Mapping of Data WRT source system
- Arrive availability of Data/Granularity for various KPI/Metrics with source system
- Identify Gap wrt Data requirement.
- Data requirement Document (DRD)
Digital: Data modelling/ LSA Build
1. Arrive the various data elements and the logical data structure/tables
2. Identify the relationship between various data tables structure
3. Identify the primary key and the surrogate keys for various data structure
4. Arrive the layers of data to be provision - source staging to final harmonisation layer/reporting layer
- Conceptual/Logical data model
- ER diagram
- Data dictionary
- Data layers and purpose
- Build layers using SQL code with optimal performance
- Scalable Model when new requirements or modification of KPI/data comes up
- Ease of Design to accommodate changes
Digital: Testing strategy and data integrity
1. Identify the Test criteria’s for the various data layers
2. Arriving the test strategy along with required stake holder (Testing, ETL, Reporting team)
3. Identify area of improvements based on the internal and user feedback
- Testing criteria for data layers
- Process redefine for robustness
- Feedbacks and Data issues faced by users
Digital: Ease of Using data for Business
1. Identify the harmonisation layers for various business
2. Identify various mechanism for reducing the leadtimes for development of Dashboards
3. Identify various mechanism/approaches for enabling self service
4. Identify various mechanism for reducing the leadtimes for development of data consumptions layers ( Downstream/Ibots)
- Datamarts
- Data dictionary
- Harmonisation layers
- Lead time reduction in dashboard /consumption layer development
- Number of users/domains on self service

**Key Skills**:

- SQL, Python

  • Data Modeler

    6 months ago

    Bengaluru, India Aptus Data LAbs Full time

    **Job Information**: Number of Positions - 1Industry - TechnologyWork Experience - 5-8 yearsLast Activity Time - 12/02/2021 23:00City - Bangalore NorthState/Province - KarnatakaCountry - IndiaZip/Postal Code - 560002The data modeller designs, implements, and documents data architecture and data modelling solutions, which include the use of relational,...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India Sciens Technologies Full time

    Experience in designing,conceptualising and building data models. Experience in building relational,conceptual,physical or relational data model. Tech exp - ERWIN or ER Studio in building relational,conceptual,physical or relational data model. Tech exp - ERWIN or ER Studio **Salary**: From ₹2,000,000.00 per year Schedule: - Day shift - Monday to...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India Kyndryl Full time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The...

  • Data Modeler

    3 months ago

    Bengaluru, Karnataka, India emids Full time

    **Job Role: Data Modeler** **Experience: 6-8 yrs** **Job Location: Bangalore** **Notice Period: 15-30 days** **Skills to focus: Data Modelling, CDM, DB design & DWH** **Job Summary**: - We are seeking a 6 to 8 Years of experience Data Modeler to join our dynamic team. - This role will involve working extensively with SQL, DAX, Azure Data Platform, and...

  • Data Modeler

    1 month ago

    Bengaluru, Karnataka, India UST Global Full time

    9 - 12 Years- 1 Opening- Bangalore**Role description**: **Associate Data Architect I** **Who we are**: At UST, we help the world’s best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our client to co-create lasting change. Together, with over 30,000 employees in 25 countries, we...

  • Data Modeler

    3 months ago

    Bengaluru, Karnataka, India CAPCO Full time

    **ROLE DESCRIPTION** As a Finance Data Modeler, you'll work at the forefront of designing and development the finance data models in the Finance Data space which is crucial for the Finance Data program in building a self-service platform for the distribution of trusted data for Finance. In this role, you'll collaborate with Senior stakeholders in across...

  • Data Modeler

    3 weeks ago

    Bengaluru, Karnataka, India Kenvue Full time

    Description **Who We Are** At Kenvue, we realize the extraordinary power of everyday care. Built on over a century of heritage and rooted in science, we’re the house of iconic brands - including NEUTROGENA®, AVEENO®, TYLENOL®, LISTERINE®, JOHNSON’S® and BAND-AID® that you already know and love. Science is our passion; care is our talent. Our...

  • Data Modeling Specialist

    1 month ago

    Bengaluru, India The Modern Data Company Full time

    Job Description : We are seeking an experienced Data Modelling Specialist to lead the design and implementation of comprehensive data models that bridge the gap between business processes and data architecture. The ideal candidate will have a strong foundation in conceptual, logical, and physical data modelling and a deep understanding of business needs and...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India growel softech Full time

    Data Modeler 5+ Years Bangalore/Mumbai Max 20 LPA **Responsibilities**: - Develop and maintain conceptual, logical, and physical data models that align with business requirements. - Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and translate them into effective data models. - Design and...

  • Data Modeller

    2 months ago

    Bengaluru, Karnataka, India Virtusa Full time

    Data Modelling, Design and develop data models for CASA, Loan, and Credit Services, ensuring they meet business requirements and compliance standards. Create conceptual, logical, and physical data models that support the bank's strategic objectives. Ensure data models are optimized for performance, security, and scalability to support business operations and...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India DigitalCube Consultancy Full time

    **Data Modeller** **Job Type - Full time** **Location - Bangalore/ Mumbai, India** **Responsibilities**: - Develop and maintain conceptual, logical, and physical data models that align with business requirements. - Collaborate with business analysts, data scientists, and other stakeholders to understand data requirements and translate them into effective...

  • Data Modeler

    2 months ago

    Bengaluru, Karnataka, India NeoStats Full time

    **About the Job**: NeoStats is a new age, Data & Analytics firm offering contemporary solutions and infinite possibilities. Our mission is to create lasting competitive advantage for our clients by transforming them to world-class, data driven organizations. Established in 2022 to provide End to End Data & Analytics Services, we are headquartered out of UAE,...

  • Data Modeller

    4 months ago

    Bengaluru, Karnataka, India Fractal Analytics Full time

    It's fun to work in a company where people truly BELIEVE in what they are doing! - We're committed to bringing passion and customer focus to the business._ Responsibilities - Participate in requirements definition, analysis, and the design of logical and physical data models for Dimensional Data Model, NoSQL, or Graph Data Model. - Lead data discovery...

  • Data Modeler

    4 weeks ago

    Bengaluru, Karnataka, India NeoStats Full time

    **Job specification**:Expertise in structuring data and creating data marts will be essential in enabling our analytics teams to derive valuable insights and make data-driven decisions.**About the Job**: NeoStats is a new age, Data & Analytics firm offering contemporary solutions and infinite possibilities. Our mission is to create lasting competitive...

  • Gcp Data Science

    3 weeks ago

    Bengaluru, Karnataka, India NTT DATA Full time

    **Statistical Modeling**: Strong understanding of statistical techniques and experience leveraging BigQuery ML and Vertex AI for model development. **Machine Learning Algorithms**: Experience with GCP's pre-built ML APIs (e.g., Vision AI, Natural Language API) and custom model building using Vertex AI. **Feature Engineering**: Ability to create meaningful...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India Black & White Business Solutions Full time

    **Job Information**: Industry **IT Services*** Province **Karnataka*** City **Bangalore North*** Postal Code **560001*** Country **India*** - Position : Data Modeler Education : BE/BTech/ME/ MTech/ MSc/MCA Experience : 7-8 Years Location : Remote Notice : Immediate - 30 days Max **Job Description**: **Requirements**: - Proven experience in...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India Impetus Technologies Full time

    8+ years of experience - Hands-on experience in designing data models - Hands-on experience with SQLs - Hands of experience on Data warehousing and ETL concepts - Analyzing and translating business needs into long-term solution data models. - Evaluating existing data systems. - Working with the development team to create conceptual data models and data...

  • Data Modeler

    6 months ago

    Bengaluru, Karnataka, India CAPCO Full time

    **About Us** Joining Capco means joining an organization that is committed to an inclusive working environment where you’re encouraged to #BeYourselfAtWork. We celebrate individuality and recognise that diversity and inclusion, in all forms, is critical to success. It’s important to us that we recruit and develop as diverse a range of talent as we can....

  • Architect - Data Modelling

    6 months ago

    Bengaluru, Karnataka, India Symphoni HR Private Limited Full time

    nterested in understanding the role? As an Architect, your daily tasks involve tackling complex data management challenges to empower organizations with data-driven insights. Your responsibilities include engaging with clients to grasp business requirements, creating and maintaining data models, documenting data mappings, building data warehouses on the...

  • Data Modeller

    2 months ago

    Bengaluru, Karnataka, India Multisolution Business services Full time

    Job description: Data Modeller Exp 4-6 Yrs CTC- 12 to 14LPA, Bangalore Notice : Immediate to Max 15 days Database, Sqlwqueires, store processors, joinings, data sets, power bi, Strong sql, 60%, 40& power bi - data modeling, tax queries. Pay: ₹685,423.75 - ₹1,485,882.21 per year Schedule: - Day shift **Experience**: - Power BI: 4 years (required) -...