Data Modeller

3 days ago


Hyderabad Delhi NCR Pune, India Wipzo Systech Private Limited Full time

Job Description

Job Title: Data Modeler

Exp.: 8+ years

Location: Pune, Gurugram, Hyderabad

Job Summary

The data architect designs, implements, and documents data architecture and enterprise data modelling solutions, which include the use of relational, dimensional, and NoSQL databases.

These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.

The successful candidate will: Provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective.

Be responsible for the development of conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).

Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively. Leadership not only in the conventional sense, but also within a team we expect people to be leaders.

Candidate should elicit leadership qualities such as Innovation, Critical thinking, optimism/positivity, Communication, Time Management, Collaboration, Problem-solving, Acting Independently, Knowledge sharing and Approachable.

Essential Duties:

- Understand and translate business needs into data models supporting longterm solutions.
- Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
- Create and maintain conceptual, logical and physical data models using best practices to ensure high data quality and reduced redundancy, along with corresponding metadata.
- Optimize and update logical and physical data models to support new and existing projects.
- Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
- Recommend opportunities for reuse of data models in new environments.
- Perform reverse engineering of physical data models from databases and SQL scripts.
- Evaluate data models and physical databases for variances and discrepancies.
- Validate business data objects for accuracy and completeness.
- Analyse data-related system integration challenges and propose appropriate solutions.
- Develop data models according to company standards. Guide System Analysts, Engineers, Programmers and others on project limitations and capabilities, performance requirements and interfaces.
- Review modifications to existing software to improve efficiency and performance.
- Examine new application design and recommend corrections if required.
- Assist with and support setting the data architecture direction (including data movement approach, architecture / technology strategy, and any other data-related considerations to ensure business value,) ensuring data architecture deliverables are developed, ensuring compliance to standards and guidelines, implementing the data architecture, and supporting technical developers at a project or business unit level.
- Coordinate and consult with the project manager, client business staff, client technical staff and project developers in data architecture best practices and anything else that is data related at the project or business unit levels.

Required Qualifications:

- 7-10 Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, PowerDesigner etc.
- Minimum of 8 years of data architecture, data modelling or similar experience
- 5-7 years of management experience required
- 5-7 years consulting experience preferred
- Experience working with dimensionally modelled data
- Bachelors degree or equivalent experience, Masters Degree Preferred 2021 ExlService Holdings, Inc. All rights reserved
- Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures
- Experience in data analysis and profiling
- Strong data warehousing and OLTP systems from an integration perspective
- Strong understanding of data integration best practices and concepts
- Strong SQL skills required scripting preferred
- Strong Knowledge of all phases of the system development life cycle
- Experience with major database and big data platforms (e.g. RDS, Aurora, Redshift, Databricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)
- Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
- Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data.

Preferred Skills & Experience:

- Design data models in ERWin:Use relational, dimensional, and NoSQL databases to design data models that meet business requirements
- Collaborate with others:Work with Business Representatives, Product owner, and Data Analysts to ensure data models meet business needs
- Ensure data quality:Ensure data models are scalable, efficient, and adherent to standardsusing Data Vault 2.0 Methodology
- Communication: Lead design discussions and create data models to integrate data in the Global Data Warehouse
- Data Governance: Understand and be able to use Collibra; Reference Data Management for all data related information.
- Document solutions:Be able to document solution design and present model to Project Team.
- Good to have:Commercial Insurance Domain knowledge and relevant work experience with Data Vault implementation
- Involved in documenting user requirements, business process and translation of business process into technical documents.
- Created Data Architect designs/documents for business processing requirements.
- Analyzed and audited Requirements & Business Processes.
- Prepared Business Matrix diagram to identify business processes, dimensions, facts, conformed dimensions, junk and degenerate dimensions.
- Worked as a part of the review and collaboration sessions regarding business processes, canonical (BOM) modeling.
- Profile the source system data to identify the business process and business requirement with operational system data.
- Designed/captured the business processes & then mapped them to the conceptual data model.
- Involved in modeling business processes through UML diagrams using Rational Rose.
- Prepared Test Scenarios based on understanding of business process flow.
- Assisted in process model development, identifying business process needs and requirements and modeling into useable, business-driven data processes.
- Participate in requirement gathering, design review and code review meetings Analyse business process and optimize existing extract stored procedures.
- Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted table/columns as part of data analysis responsibility.
- Reviewed Entities and relationships in the engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
- Conducted logical data analysis and data modeling joint application design (JAD) sessions, documented data-related standards.
- Performed data analysis to support mapping and transformation of data from legacy systems to physical data models.
- Gather accurate data by data analysis and functional analysis.
- Conduct logical data modeling and data analysis.
- Involved in developing SQL queries for extracting data from test and production databases to perform data analysis and data quality checks.
- Worked with tools like TOAD for data analysis, SQL assistant, Tortoise SVN and red gate's SQL compare.
- Developed robust and efficient oracle PL/SQL procedures, packages and functions that were useful for day to day data analysis.
- Conducted data analysis on application views, functions and triggers, and tuned for performance, fixed missing/wrongly mapped data.
- Involved in the data mapping, data analysis and Gap analysis between the Legacy systems and the Vendor Packages.
- Performed Data Profiling and Data Analysis using SQL queries looking for Data issues, Data anomalies.
- Defined Data architecture Strategy, Data Management Strategy, data standards, Data architectural.
- Consolidated and generated database standards and naming conventions to enhance Enterprise Data Architecture processes.
- Developed an activity centered data architecture and a process architecture for automated data extraction.
- Analyzed, documented and articulated the customer's current data warehouse/data mart architecture.
- Generated Logical Data Models for old databases using Reverse engineering and documented in order to implement Forward Engineering procedures.
- Designed and implemented procedures for mapping interface data between legacy systems and a new implementation.
- Revised and rewrote their design specifications, established internal procedures for product certification.
- Designed standards and procedures to manage metadata in a structured and unstructured data environments.
- Mentored existing staff on data administrative processes procedures and standards.
- Created standards and procedures for metadata collection and repository maintenance.
- Designed and developed several complex database procedures, packages.
- Developed business specific custom reports using PL/SQL procedures.
- Established auditing procedures to ensure data integrity.
- Developed stored procedures to implement business logic.
- Design Functional Testing Standard Operating Procedures.
- Worked with different team to provide them with the essential stored procedures and packages and the required access to the data.
- Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers, cursors and user defined functions.

Role:Data Science & Analytics - Other

Industry Type:IT Services & Consulting

Department:Data Science & Analytics

Employment Type:Full Time, Permanent

Role Category:Data Science & Analytics - Other

Education

UG:Any Graduate

PG:Any Postgraduate

Doctorate:Any Doctorate


  • Data Modeller

    4 days ago


    Bengaluru, Delhi, NCR, Pune, India Infogain Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Summary:We are looking for a Data Modeler to support our Data Engineering team in building and maintaining standardized data models and Single View of Customer models. The role involves preparing and visualizing data models, ensuring compliance with PACS DAWG standards, maintaining data dictionaries, and supporting NoSQL data modelling initiatives.Key...

  • Data Modeler

    2 days ago


    Bengaluru, Delhi, Hyderabad, NCR, India Teamlease Digital Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    Analyze and translate business requirements into conceptual and fully detailed logical data models.Create logical data models based on existing applications and databases.Identify opportunities to optimize and extend data models for evolving business needs.Ensure data models support efficient API-based data access.Collaborate with Business Analysts to map...

  • Data Modeller

    6 days ago


    Bengaluru, Delhi, Hyderabad, NCR, India Genpact Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the worlds biggest brands—and we have fun doing it. Now, we're calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.Transformation happens here. Come, be a part of our...


  • Delhi, NCR, India Neuronimbus Software Services Full time US$ 90,000 - US$ 1,20,000 per year

    Data Modeler AI/ML EnablementRemote | Contract/Freelancer | Duration: 1 to 2 MonthsStart: Immediate | Experience: 7+ YearsWere looking for experienced Data Modelers with a strong background in one or more industries:Telecom, Banking/Finance, Media, or Government.Key Responsibilities:Design conceptual/logical/physical data modelsCollaborate with AI/ML teams...


  • Delhi, NCR, Noida, Pune, India Tiger Analytics Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Role & responsibilitiesAs an Architect, you will work to solve some of the most complex and captivating data management problems that would enable them as a data-driven organization; Seamlessly switch between roles of an Individual Contributor, team member, and Data Modeling Architect as demanded by each project to define, design, and deliver actionable...

  • Data Modeller

    11 hours ago


    Hyderabad, Pune, India Purview Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    The data modeler designs, implements, and documents data architectures and data models for solutions, which include the use of application, relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, operations, machine learning, data science, and other business interests.The successful...


  • NCR, India Neuronimbus Software Services Full time

    Data Modeler AI/ML EnablementRemote | Contract/Freelancer | Duration: 1 to 2 MonthsStart: Immediate | Experience: 7+ Years Were looking for experienced Data Modelers with a strong background in one or more industries:Telecom, Banking/Finance, Media, or Government. Key Responsibilities: Design conceptual/logical/physical data models Collaborate with AI/ML...


  • Delhi, Gurugram, NCR, Pune, India Tiger Analytics Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Role & responsibilitiesUnderstand the Business Requirements and translate business requirements into conceptual, logical and physical Data models.Work as a principal advisor on data architecture, across various data requirements, aggregation data lake data models – data warehouse etc.Lead cross-functional teams, define data strategies, and leverage the...

  • Data Modeller

    6 hours ago


    Bengaluru, Hyderabad, Pune, India KPI Partners Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    We are seeking a skilled Data Modeller to join our team at KPI Partners. The ideal candidate will be responsible for designing and implementing data models that effectively meet the business needs of our clients while ensuring data integrity and optimization. Key Responsibilities: - Collaborate with stakeholders to gather requirements and understand data...


  • Delhi, Delhi, India INUMELLAS CONSULTANCY SERVICES PRIVATE LIMITED Full time

    Role - Data Modeler/Senior Data ModelerExp - 6 to 9 YrsLocations - Chennai, Hyderabad, Bengaluru, Delhi, PunePosition - PermanentCurious about the role? What your typical day would look like?As a Senior Data Engineer, you will work to solve some of the organizational data management problems that would enable them as a data-driven organization; Seamlessly...