Data-modeller-build

2 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

    2 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

    2 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

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

    1 week ago

    Bengaluru, Karnataka, India ANZ Banking Group Full time

    **Req ID**: 61900 **Department**: Risk Enterprise Data Risk **Division**: Risk **Location**: Bengaluru About the role To bring thought leadership and experience in uplifting data management practices at ANZ What will your day look like Supporting the Snr Mgr - Data Risk Taxonomy, enable the design, development, and maintenance of the semantic based...

  • Data Modeler

    2 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 Modeler

    2 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

    1 month 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

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

  • Architect - Data Modelling

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

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

  • Data Modeller

    2 months ago

    Bengaluru, Karnataka, India Tata Consultancy Services Full time

    Associate have to play Data Modeller Role - Hands on experience on Hadoop, GCP, Datastage & Oracle will be preferred. - Credit Risk Data Modelling experience will be preferred Qualifications :Undergraduate

  • Data Modeler

    3 weeks ago

    Bengaluru, India Wipro Full time

    Senior Lead Data Modeler Responsibilities Own and Lead Data Modeling Activities. Support and development of Organizational Data Strategy and data management in line with business objectives. Align architecture and model with business requirements. Lead the Data Governance as per organization strategies and standards. Evaluate data model based on existing...

  • Data Modeler

    7 days ago

    Bengaluru, India Xcelyst Full time

    Role : Data ModellerJob Description :Job Title : Data Modeller/ Data ArchitectOverall Years of Relevant Experience : 6-10 Years mandatory hands-on experienceLocation : Preferably BangaloreNotice Period : Immediate Joiner - 30 Days Roles & Responsibilities :- Experience in working with SME's to build Conceptual Data models- Convert business requirements...

  • Building Information Modeler

    1 month ago

    Bengaluru, Karnataka, India CDM Smith Full time

    The Civil 3D Modeler is expected to perform variety of design/drafting activities including preparing/updating plan/profile drawings for pipeline, road alignment, grading using corridor modelling, pressure/gravity pipe network and ground terrain modelling. Also, Civil 3d Modeler, should establish guidelines and procedures for standards to be used on project...

  • Data Governance Data Modeller

    1 week ago

    Bengaluru, Karnataka, India Right Advisors Private Limited Full time

    **Experience - 4 to 8 Years** **Budget : 24 LPA** **Notice - immediate to 30 days max.** **Education : B.Tech/Any Science related** The Data Governance Data Modeler will work within the Data & Architecture to model data relating to critical business processes and regulatory reporting requirements, as required under the Data Management policy. Data is...

  • Data Modeler

    3 weeks ago

    Bengaluru, India Birlasoft Full time

    Job Title: Data Modelling LeadLocation: Bangalore/Hyderabad/ Pune/NoidaCompany Description: Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run...

  • Data Modeler

    2 months ago

    Bengaluru, India CGI Group, Inc. Full time

    **Position Description**: Core Skill - Hands-on experience Data Modeling using Erwin & related tools. - Expertise in development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). - Strong knowledge on INMON model Vs KIMBALL and layered...

  • Data Modeler

    3 weeks ago

    Bengaluru, India Birlasoft Full time

    Job Title: Data Modelling LeadLocation: Bangalore/Hyderabad/ Pune/NoidaCompany Description: Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run...

  • Data Modeler

    3 weeks ago

    Bengaluru, India Birlasoft Full time

    Job Title: Data Modelling LeadLocation: Bangalore/Hyderabad/ Pune/NoidaCompany Description: Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run...

  • Data Modeler

    1 week ago

    Bengaluru, India Birlasoft Full time

    Job Title: Data Modelling LeadLocation: Bangalore/Hyderabad/ Pune/NoidaCompany Description: Birlasoft, a powerhouse where domain expertise, enterprise solutions, and digital technologies converge to redefine business processes. We take pride in our consultative and design thinking approach, driving societal progress by enabling our customers to run...