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

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

Similar jobs (10)
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

🚨 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
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
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.
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.
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
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

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
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
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.
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
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.
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
Applications on this job are not being reviewed actively. You may apply but please follow up with the company via other channels too.
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!










