Cutshort logo
For Employers
Global analytics and digital solutions company  logo
Data Modeller
Global analytics and digital solutions company

Data Modeller at Global analytics and digital solutions company · Bengaluru (Bangalore), Pune, Gurugram, Noida · 8 - 14 years · ₹35L - ₹40L / yr · Posted 16 Nov 2026

Bean HR Consulting's logo

Data Modeller

at Global analytics and digital solutions company

Agency job
8 - 14 yrs
₹35L - ₹40L / yr
Bengaluru (Bangalore), Pune, Gurugram, Noida
Skills
Data modeling
SQL
Data Warehouse (DWH)

Responsibilities:

  • Design conceptual, logical, and physical data models.
  • Develop enterprise insurance canonical models.
  • Work closely with business SMEs.
  • Create dimensional models for reporting.
  • Support data governance and business glossary.
  • Design conformed dimensions.
  • Define data relationships and mapping.

Must Have Skills:

  • Data Modelling
  • ER Modelling
  • Policy 
  • Claims 
  • Billing 
  • Underwriting 
  • SQL
  • Data Warehouse

Preferred:

  • Reinsurance 
  • Bordereaux 
  • MGA
  • Broker 
  • Insurance Accounting
  • Snowflake 
  • Databricks
Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

Similar jobs (10)

analytics
Actively reviewing applications
analytics
Agency job
via Bean HR Consulting by snigdha Khurana
Gurugram, Pune, Bengaluru (Bangalore)
6 - 10 yrs
Best in industry
Data modeling
data model
Slowly changing dimensions
Dimensional modeling
ERwin
+1 more

Hiring: Data Modeler

Experience: 6+ years

Location: Bangalore/Gurugram/Pune


Required Skills

  • Hands-on experience in conceptual, logical, and physical data modeling.
  • Strong knowledge of ER modeling, dimensional modeling, star/snowflake schemas, fact/dimension tables, and SCDs.
  • Strong SQL skills for data profiling, validation, and quality checks.
  • Experience with source-to-target mapping, data dictionaries, metadata, and data lineage.
  • Proficiency in Erwin, ER/Studio, or similar modeling tools.
  • Exposure to Snowflake, Databricks, Redshift, SQL Server, or other data platforms.
  • Understanding of data governance, UAT, reconciliation, and Agile methodologies.
  • Strong analytical, documentation, and stakeholder management skills.


Preferred Qualifications

  • Experience in enterprise data warehousing or lakehouse modeling.
  • Knowledge of data products, data contracts, quality SLAs, and reusable datasets.
  • Exposure to dbt, data cataloging, metadata management, and governance tools.
  • Ability to work independently in a fast-paced environment.


If interested please share your cv at : snigdhaattheratebeanhr.com

Read more
Leading insurance company
Actively reviewing applications
Leading insurance company
Agency job
via Bean HR Consulting by snigdha Khurana
Bengaluru (Bangalore), Pune, Delhi, Gurugram, Noida, Ghaziabad, Faridabad
5 - 10 yrs
Best in industry
Data modeling
llyod
london
market

🚨 HIRING ALERT | DATA MODELLER – Property & Casualty INSURANCE / LLOYD’S MARKET

🚨🔹 Experience: 5–10 Years

🔹 Location: Delhi NCR | Pune | Bangalore

🔹 Notice Period: Only Serving/Immediate Joiners


Required Skills:

✅ P&;C Insurance; Lloyd’s Market (Mandatory)

✅ Data Modelling | ER Modelling

✅ Policy | Claims | Billing | Underwriting

✅ SQL | Data Warehouse

✅ Enterprise / Canonical / Dimensional Data Models


📩 Share CV: snigdhaattheratebeanhr.com


🔁 Know someone suitable? Please share this opportunity

Read more
This is confidential
This is confidential
Agency job
via Bean HR Consulting by SHINJANI TRIVEDI
icon

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.

Gurugram, Noida, Bengaluru (Bangalore), Pune
8 - 17 yrs
₹30L - ₹40L / yr
Google Cloud Platform (GCP)
Google Cloud Storage
Data architecture
Data modeling
Data mining

IMMEDIATE JOINERS ONLY


Key Responsibilities:

1                   Data Flow Mapping & Lineage

2                   Design and produce end-to-end data flow maps for critical data items – from market source/core systems, through Data Lake staging, zone 2 and consumption zone 3, to downstream reporting, dashboards and analytics use cases.

3                   Document data lineage and transformations for critical data elements identified in the Master Data Requirements exercise, ensuring traceability that is audit-defensible and supports regulatory, governance and AI-readiness needs.

4                   Map data availability by country/Data Lake against the Product Hierarchy (to profit-centre level), building the consolidated Commercial Data Landscape view of what exists, where it sits (source only, staging, or consumption) and what is not captured at all.

5                   Document cross-system dependencies and cross-border data flows, flagging data residency, privacy and regulatory considerations to the appropriate governance forums.

6                   Data Inventory, Data Model Alignment & Gap Analysis

•                    Own and mature the data asset inventory, catalogue and data dictionary aligned to the consolidated Master Data Requirements Template – resolving “Not Specified”, “TBD” and “validation required” availability statuses through structured validation with Market IT and Data Engineering.

•                    Align business data requirements to the conceptual and logical data model of the target Data Lakehouse, ensuring the dependency between data model design and lineage tracking of critical data items is explicitly documented.

•                    Perform gap and hydration analysis by market and product, quantifying the scale of data that must be brought into the Data Lakes and providing sizing input to the Data Foundation Lead, DAE architects and Data Engineering delivery plans.

•                    Contribute to the Data Consolidation Plan towards a single source of truth, including recommended sequencing based on business priority (Top 200 fields, Horizon 1–3 priorities).

•                    Stakeholder Engagement & Workshops

•                    Work hand-in-hand with the Data Foundation Lead, Data & Analytics Programme Manager, Data Engineers, DAE/infrastructure architects, Local Market IT and Business stakeholders (Regional and Market) as the connective tissue between business data needs and technical implementation.

•                    Plan and facilitate structured interviews and cross-functional validation workshops with business, technology and data stakeholders to corroborate actual operating data flows against documented processes – establishing a fact-based, evidence-backed view rather than relying on documentation alone.

•                    Translate ambiguous business asks into clear data definitions, mapping rules and acceptance criteria that Data Engineering can build against, and play back findings to senior stakeholders in clear, visual, decision-oriented formats.

•                    Manage competing priorities across multiple markets with tact, keeping momentum in an environment of constrained capacity and differing local system landscapes.

•                    Governance, Ownership & Documentation

•                    Produce and maintain the Data Ownership & Accountability Matrix – mapping data owners, stewards and custodians per data asset and highlighting ownership gaps for remediation.

•                    Classify data assets by sensitivity and business function, aligning to Data Protection Policy, PDPA and applicable regulatory expectations (e.g. MAS guidelines) in partnership with Risk & Compliance.

•                    Ensure all data flow maps, lineage records and inventory artefacts are version-controlled, audit-ready and handed over cleanly into BAU data governance processes.

•                    Produce source to Datalake mapping document and data catalogue for missing data elements to complete Datalake hydration

 

Key Skills

•                    Data flow mapping and lineage documentation – proven ability to draw clear, accurate source-to-consumption data flow maps across complex multi-system, multi-market landscapes.

•                    Data architecture and modelling – strong grasp of conceptual/logical data models, data lake/lakehouse zone architectures (staging, conformed, consumption), data marts and MDM concepts.

•                    Data inventory, catalogue, dictionary and metadata management; familiarity with lineage/catalogue tooling (e.g. Purview, Collibra) and diagramming tools (e.g. Visio, ErWin, Lucidchart).

•                    Hands-on data profiling and validation skills (SQL essential) to verify what actually exists in source systems and lake zones.

•                    Strong stakeholder management – this is critical: able to build trust and drive outcomes across regional leadership, market business teams, Market IT and engineering, and to facilitate effective cross-functional workshops.

•                    Insurance domain knowledge – ideally commercial and specialty lines, with an understanding of policy, claims, reinsurance and underwriting data.

•                    Data quality, governance and privacy concepts, including cross-border data considerations.

•                    Clear written and visual communication – able to make complex data landscapes understandable to executives.

 

Experience & Qualification Requirements:

•                    8+ years’ experience in data architecture, data business analysis or information architecture roles, with at least:

•                    3+ years documenting data flows, lineage or data landscapes across multi-system / multi-market environments.

•                    Experience in Insurance or Financial Services, ideally within data foundation, data lake or data governance programmes.

•                    Demonstrated delivery of data inventory / data mapping / current-state data landscape assessments involving both business and IT stakeholders.

•                    Relevant certification (e.g. DAMA CDMP, TOGAF, cloud data platform certifications) preferred.


 



 

Read more
Fx31labs
Actively reviewing applications
Darshana Jadhav
Posted by Darshana Jadhav
Remote only
7 - 12 yrs
₹20L - ₹30L / yr
Data engineering
Data architecture
Data Warehouse (DWH)
Data modeling

Job Title: Senior Data Architect

Experience: 7+ Years

Location: India (Ahmedabad / Hybrid/Remote)

Job Summary

We are looking for an experienced Senior Data Architect to support the modernization and enhancement of Enterprise Analytic Data Warehouse (ADW). The candidate will be responsible for evaluating existing data architecture, designing scalable data models, assessing data integration across clinical, operational and financial domains, and establishing data governance and data quality standards.

Key Responsibilities

  • Assess and review the existing Enterprise Analytic Data Warehouse architecture, database structures and data integration processes.
  • Design and improve enterprise data models covering clinical, operational, financial and revenue-cycle information.
  • Define data architecture standards, database structures, data relationships and integration strategies.
  • Evaluate data flows between source systems and the data warehouse.
  • Design and review source-to-target mappings and data lineage.
  • Identify architectural gaps affecting data completeness, consistency, integrity and reporting accuracy.
  • Establish standardized data definitions, data governance practices and metadata management.
  • Ensure consistent patient, facility, payer and other critical identifiers across different datasets.
  • Support integration of billing, claims, payment, denial and accounts receivable (AR) data.
  • Work with SQL and Python-based data processing solutions to investigate and validate data structures.
  • Recommend improvements to warehouse scalability, performance, reliability and maintainability.
  • Develop a prioritized architecture and modernization roadmap for future implementation.
  • Coordinate with data engineers, analytics engineers and business stakeholders.

Required Technical Skills

  • Strong experience in Data Architecture and Enterprise Data Warehousing.
  • Advanced SQL and relational database concepts.
  • Experience with data modelling (conceptual, logical and physical).
  • Knowledge of ETL/ELT pipelines and data integration.
  • Experience with data profiling, data lineage and metadata management.
  • Understanding of data governance, data quality and data validation frameworks.
  • Experience working with large and complex datasets.
  • Python knowledge for data analysis and validation.
  • Experience with cloud-based data platforms or modern data warehouse technologies.

Preferred Skills

  • Experience with Databricks, Azure, AWS or similar cloud data platforms.
  • Experience with healthcare data warehouses.
  • Knowledge of clinical, financial, billing and claims datasets.
  • Understanding of HIPAA, PHI and healthcare data security principles.
  • Experience with healthcare analytics, reimbursement and revenue-cycle data.


Read more
Raah Techservices
icon

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.

Bengaluru (Bangalore), Mumbai
5 - 10 yrs
₹5L - ₹30L / yr
Ab Initio
Data modeling
Data integration
Hadoop
Informatica
+1 more

We are looking for Data engineer with strong expertise in Data warehousing to join our team.


Key skills : ab initio, ssis , Informatica, Hadoop and Teradata

Read more
Digital Marketing Company - WFH
Actively reviewing applications
Digital Marketing Company - WFH
Agency job
via Destiny HR Group Services by DestinyHR GroupServices
Remote only
8 - 15 yrs
₹18L - ₹32L / yr
skill iconPython
Cloud Computing
Snow flake schema
DevOps
SQL
+2 more

Designation: Data Architect



Reporting: VP, Engineering



Desired Experience: 12 – 18 Years



Qualification: BE/ B Tech/ M Tech/ MCA and any Graduate.



Job Location: Noida Sec-6 (Nearest Metro Station 15)



(WFH/Work from Home Available)



Total Employees: 100+ Members



Working Days: Monday to Friday



Key Responsibilities

  • Define, own, and evolve the enterprise data architecture
  • Design scalable, secure, high-performance end-to-end data platforms
  • Establish data modeling standards (conceptual, logical, physical)
  • Act as architectural authority for data pipelines, APIs, and integrations
  • Ensure platform design meets security, compliance, availability, and cost-efficiency standards
  • Define and enforce data governance, data quality, metadata, lineage, and master data principles
  • Collaborate with Data Engineers for implementation of architecture designs
  • Align data architecture with product roadmaps and business priorities
  • Define standards for data sharing, data products, and external data exposure
  • Contribute to long-term data platform roadmap and technology adoption
  • Support leadership with architecture reviews and strategic decisions

Required Experience & Technical Expertise

Experience

  • 12+ years in Data domain
  • 3–5 years as Data Architect / Lead Data Role
  • Experience designing enterprise-scale data platforms

Data Architecture & Modeling

  • Deep expertise in Data Modeling & Data Warehousing
  • Advanced SQL knowledge
  • Strong experience with Snowflake & modern cloud data stacks
  • Experience with relational and cloud-native databases

Security & Compliance

  • Knowledge of Data Security (Dynamic Masking, Row-Level Security, Access Control)
  • Strong understanding of GDPR & Data Privacy regulations

Integration & Engineering

  • Experience with streaming & event-driven architectures
  • APIs & integration patterns (REST, event-based systems)
  • Familiarity with CI/CD, DevOps & Infrastructure-as-Code in data environments
  • Architecture reviews & technology evaluations

Key Technical Skills (Must Have)

  • Snowflake
  • Matillion (or equivalent data integration tools)
  • Python
  • SQL
  • REST APIs & Event-driven integrations
  • Power BI / Qlik / Tableau
  • Experience with CRM / Marketing Automation / PIM platforms
  • Agile & Continuous Delivery practices

Personal Skills

  • Strong architectural mindset with focus on scalability
  • Collaborative leadership ability
  • Analytical and business-oriented thinking
  • Strong communication skills (technical & non-technical stakeholders)
  • Proactive, autonomous, and accountable

Why Join Us?

  • Work with best-in-class data & cloud technologies
  • Influence core data architecture of a global digital platform
  • Strong engineering culture focused on ownership & quality
  • Hybrid work model (mostly remote)
  • 25+ years of industry leadership with strong growth trajectory

 Please fill the following details:

 

1) Current CTC

 

2) Expected CTC

 

3) Notice Period

 

4) Current Location

 

5) Reason of Change

 

6) Years of Experience

 

Kindly provide us the references for the same openings.



WhatsApp your CV at 7 5 0 3 8 6 6 1 9 6

Read more
Wissen Technology
at Wissen Technology
4 recruiters
Vishakha Walunj
Posted by Vishakha Walunj
icon

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.

Pune
8 - 15 yrs
Best in industry
skill iconPython
PySpark
databricks
skill iconAmazon Web Services (AWS)
SQL

Data Architect – Databricks & AWS

  • Strong experience in Data Architecture, Data Engineering, Databricks, Apache Spark/PySpark, Python, and Advanced SQL.
  • Design and implement scalable ETL/ELT pipelines, data platforms, and Lakehouse architectures using Medallion Architecture.
  • Experience with Databricks, Databricks Workflows, Unity Catalog OR Databricks Jobs
  • Strong knowledge of Delta Lake, Databricks Workflows, Delta Live Tables (DLT), and dimensional data modeling.
  • Hands-on experience with AWS services such as S3, Glue, IAM, Lambda, and CloudWatch.
  • Experience with Apache Airflow, Data Warehouse concepts, Git/CI-CD, performance optimization, and data quality.
  • Good to have exposure to Kafka/Structured Streaming, Unity Catalog, and modern data governance.
Read more
Bean HR Consulting
Divya Sharma
Posted by Divya Sharma
icon

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.

Faridabad
4 - 10 yrs
₹10L - ₹20L / yr
Informatica
CDI
CAI
Application Integration
Data integration
+2 more

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

 

Job Description

Roles & Responsibilities

 

  • Lead project team members through all activities required to successfully deliver Informatica.
  • Define technical specifications for workflows and business rules.
  • Prepare detailed design documents for data migration.
  • Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
  • Train and mentor colleagues in Informatica implementation activities and best practices.
  • Support integration, system, and user acceptance testing.
  • Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
  • Profile & Analyze Source Data usage using ETL tool.
  • Automation, job scheduling, dependencies, monitoring.
  • Configure/Script Business rules and transformation rules in ETL
  • Data pipeline using IICS
  • Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
  • Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
  • Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
  • Experience in administering, supporting, and performance tuning using Informatica.


Read more
OIP Insurtech
Actively reviewing applications
at OIP Insurtech
2 candid answers
Katarina Vasic
Posted by Katarina Vasic
Remote only
5 - 10 yrs
₹11L - ₹15L / yr
SQL
PowerBI
skill iconPython

We’re looking for a dynamic and driven Data Analyst to join our team of technology enthusiasts. This role is crucial in transforming data into insights that support strategic decision-making and innovation within the insurance technology (InsurTech) space. If you’re passionate about working with data, understanding systems, and delivering value through analytics, we’d love to hear from you.


What We’re Looking For

  • Proven experience working as a Data Analyst or in a similar analytical role
  • 5+ Years of experience in the field
  • Strong command of SQL for querying and manipulating relational databases
  • Experience with Power BI for building impactful dashboards and reports
  • Familiarity with QlikView and Qlik Sense is a plus
  • Ability to communicate findings clearly to technical and non-technical stakeholders
  • Knowledge of Python or R for data manipulation is nice to have
  • Bachelor’s degree in Computer Science, Statistics, Mathematics, Economics, or a related field
  • Understanding of the insurance industry or InsurTech is a strong advantage

What You’ll Be Doing:

  • Delivering timely and insightful reports to support strategic decision-making
  • Working extensively with Policy Administration System (PAS) data to uncover patterns and trends
  • Ensuring data accuracy and consistency across reports and systems
  • Collaborating with clients, underwriters, and brokers to translate business needs into data solutions
  • Organizing and structuring datasets, contributing to data engineering workflows and pipelines
  • Producing analytics to support business development and market strategy
Read more
icon

Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.

Tirupati
4 - 15 yrs
₹7L - ₹25L / yr
SQL
MS-Excel
skill iconData Analytics
PowerBI

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.


Key Responsibilities

  • Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
  • Build and maintain data models to support business processes, reporting needs, and integration workflows.
  • Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
  • Work closely with cross-functional teams to gather data requirements and understand business logic.
  • Develop and execute integration test plans, including functional, data validation, and regression testing.
  • Support data migration activities, including extraction, transformation, and loading (ETL).
  • Monitor and troubleshoot integration issues, ensuring timely resolution.
  • Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
  • Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

  • 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
  • Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
  • Hands-on experience with data mapping, data modelling, and database schema design.
  • Proficiency in SQL (complex joins, stored procedures, performance tuning).
  • Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
  • Strong analytical and problem-solving skills.
  • Experience with API-based integrations (REST/SOAP) is a plus.
  • Familiarity with testing methodologies for integrations and data validation.
  • Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

  • Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
  • Knowledge of JSON, XML, CSV transformation.
  • Exposure to scripting languages (Python, Shell).
  • Experience in Agile/Scrum environments.
  • Prior involvement in ERP implementation or upgrade projects.

Competencies

  • Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
  • Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
  • Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
  • Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
  • Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

  • Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
  • Work on impactful projects that make a difference across industries.
  • Opportunities for professional growth and continuous learning.
  • Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!

Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos