Sr Data Modeller

Lumiq; Dadri; On-site; INR 1,500,000 - 2,100,000; Full time

Benefits offered by this job

Group Medical Policies

Maternity Leave

Upskilling Opportunities

Job summary

LUMIQ is seeking a seasoned Data Modeler to translate business requirements into scalable data models. You will work with architects to define logical and conceptual models, map KPIs, and ensure alignment with industry standards. Strong communication with business users and global teams is essential.

Ideal candidates have 7+ years in data modeling, experience with ERWIN/DeZign, and a solid grasp of data governance within an enterprise data warehouse context.

Qualifications

• 7+ years of data modeling experience in large databases.
• Strong knowledge of dimensional and relational modeling.
• Proficient in SQL and data warehousing concepts.

Responsibilities

• Develop logical data models from conceptual models and profile data.
• Collaborate with lead data modeler/architect to clarify requirements.
• Create conceptual, logical and physical models aligned with client standards.
• Define data attributes, domains and data dictionaries.
• Validate models with SMEs and architects and ensure governance.

Skills

Dimensional Modeling

Relational Modeling

SQL Proficiency

Data Warehousing

Onsite-offshore Collaboration

Tools

ERWIN

DeZign

Job description

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.

Our expertise lies in creating next-gen data technology products to help FSI enterprises organize, manage, and effectively use data. We have consistently challenged the status quo, introducing many industry-firsts like the first enterprise data platform in Asia on cloud for a regulated entity.

Founded in 2013, LUMIQ has now completed a decade of innovation, backed by Info Edge Ventures (a JV between Temasek Holdings of Singapore and Naukri) and US-based Season 2 Ventures.

Role Description:

The Data Modeler at LUMIQ will play a pivotal role in translating complex business requirements into data modelsthat 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 bothtechnical 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 ofstandards 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 thetechnology suggested for the project.


• Interact with the Architect to gather reporting requirements and create models based on the sameParticipate 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 withmultiple vendors.


• Excellent written and verbal communication skills.

What do you get:

• Opportunity to contribute to an entrepreneurial culture and exposure to the startup hustler culture.


• Competitive Salary Packages.


• Group Medical Policies.


• Maternity Leave.


• Opportunities for upskilling and exposure to the latest technologies.