Lumiq - Data Modeler - Erwin/SQL

1 day ago

Noida India LUMIQ Full time

Job Description Role Description The Data Modeler at LUMIQ will play a pivotal role in translating complex business requirements into data models that align with the client's architectural guidelines and industry best practices. If you possess a blend of analytical prowess, deep understanding of data structures, and the ability to communicate effectively with both technical and non-technical stakeholders, this role awaits you. Responsibilities - Develop the logical data model based on the understanding of the conceptual model and conduct data profiling with the objective of delivering high-quality data models and high-quality data within the limits of standards defined by Lumiq, client, and industry. - In collaboration with the Lead Data Modeler / Architect, analyze the requirements and create a clarification list, if required. - Define data requirements based on an understanding of the same In collaboration with the Lead, create a conceptual model based on the understanding of the business processes Map KPIs to the conceptual model, if required Validate the conceptual model with Manager, SMEs, etc. - Create a logical model (capturing the descriptions of entities, tables, columns, etc.) based on the conceptual model Create tables and relationships between the tables Map conceptual to the logical model to ensure the coverage Identify the entities and their properties. - Define the attributes and domain (data types) - Create a physical model based on functional/ non-functional requirements for small and simple projects. - Seek review inputs from the Lead / Manager / Architect on the logical and physical model. - Define the data dictionary/ business glossary based on the model developed, if required. - Define the data governance model to ensure the data quality - Interact with SMEs (business) and architects to validate whether the data model is aligned with the technology suggested for the project. - Interact with the Architect to gather reporting requirements and create models based on the same Participate in Data Model Health Assessments. - Assist Sr. Data Modeler in the creation of questionnaires, analyze the AS-IS data model for data structure, conformance to industry standards, best practices, and make recommendations for solution/roadmap. - Provide technical guidance to the design/ development team in understanding the data mode. Qualifications - Very Good knowledge of Dimensional/Relation Data Modeling. - At least 7+ years of Data Modeling experience working in large databases. - Worked on ERWIN, DeZign etc modelling tool. - Knowledge in RDBMS Concepts, Data Analysis, and good SQL knowledge. - Should be technically strong in relational databases and able to provide design approaches. - Prior experience in working in a large Enterprise Data Warehouse is expected. - Experience in Banking, Health and Life Insurance domain is preferable. - Ability to coordinate and explain with business users to get the requirements. - Should have very good and clear communication skills. - Should have experience of working in an Onsite-offshore model. - Experience of working in projects involving multiple time zones and onsite-offshore models and with multiple vendors. - Excellent written and verbal communication skills. (ref:hirist.tech)

  • Data Modeler

    6 days ago

    Noida, India Lumiq Full time

    **About us**: We’re weaving a success story for those who are passionate about using technology to be part of a revolution — one that’s continuously enabling enterprises to bring more value to their partners and customers alike. **Responsibilities**: - Develop the logical data model based on the understanding of the conceptual model and conduct data...

  • AWS Data Engineer

    2 hours ago

    Noida, India Lumiq Full time

    AWS Data Engineer Location: Noida 5 Days WFO Who we are: LUMIQ is the leading Data and Analytics company in the Financial Services and Insurance (FSI) industry. We are trusted by the world's largest FSIs, including insurers, banks, AMCs, and NBFCs, to address their data challenges. Our clients include 40+ enterprises with over $10B in deposits/AUM,...

  • AWS Data Engineer

    3 weeks ago

    Noida, India Lumiq Full time

    AWS Data Engineer Location: Noida 5 Days WFO Who we are: LUMIQ is the leading Data and Analytics company in the Financial Services and Insurance (FSI) industry. We are trusted by the world's largest FSIs, including insurers, banks, AMCs, and NBFCs, to address their data challenges. Our clients include 40+ enterprises with over $10B in deposits/AUM,...

  • Lead Data Engineer

    6 days ago

    Noida, India Lumiq Full time

    Who we are: LUMIQ is the leading Data and Analytics company in the Financial Services and Insurance (FSI) industry. We are trusted by the world's largest FSIs, including insurers, banks, AMCs, and NBFCs, to address their data challenges. Our clients include 40+ enterprises with over $10B in deposits/AUM, collectively representing about 1B customers globally....

  • Lead Data Engineer

    3 weeks ago

    Noida, India Lumiq Full time

    Who we are: LUMIQ is the leading Data and Analytics company in the Financial Services and Insurance (FSI) industry. We are trusted by the world's largest FSIs, including insurers, banks, AMCs, and NBFCs, to address their data challenges. Our clients include 40+ enterprises with over $10B in deposits/AUM, collectively representing about 1B customers globally....

  • Lead Data Engineer

    6 days ago

    Noida, Uttar Pradesh, India LUMIQ Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Who we are:LUMIQ is the leading Data and Analytics company in the Financial Services and Insurance (FSI) industry. We are trusted by the world's largest FSIs, including insurers, banks, AMCs, and NBFCs, to address their data challenges. Our clients include 40+ enterprises with over $10B in deposits/AUM, collectively representing about 1B customers...

  • Data Modeller

    3 days ago

    Pune, India Virtusa Full time

    Job Description Job Description Strong understanding of DBMS (e.g., SQL Server, Oracle) and SQL proficiency Experience with data modeling and design tools like ER Studio, Power Designer, or Erwin is often required. Familiarity with data integration and ETL processes Knowledge of data warehousing concepts Should have strong skills in DBMS & SQL Hands on data...

  • Data Modeller

    2 weeks ago

    India Inumellas Consultancy Services Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Exp YrsLoc - Pan IndiaCompany - MNCPosition - Permanent FTE Must Have - Logical/physical data modeling, ER modeling, SQL, data warehousing, normalization, dimensional modeling, metadata management, data governance, and tools like ERwin .

  • Data Modeler

    4 weeks ago

    Chennai, India Virtusa Full time

    Job Description Role: Data Modelers Experience: 5+ years Work Mode: Hybrid Work Timing: 2 PM to 11PM Location: Chennai & Hyderabad Primary Skills: Data Modelers Job Responsibilities: Candidate should have Data Modeling experience, Erwin data modelling tool Experience with AWS and Redshift database models is a plus Designing L2 Layer experience for Large Data...

  • Data Modeler

    3 days ago

    Bengaluru, India Recro Full time

    Job Description Job Description We are looking for a Data Modeler who can design and maintain Conceptual, Logical & Physical data models and work closely with business and data engineering teams. Key Responsibilities - Build and maintain ER diagrams & database designs (ERWIN / ER Studio) - Convert business requirements data models, data mappings & functional...