Home › Companies › Fa Etvl Saasfaprod1 Fa Ocs Oraclecloud Com CX 1 › DE&A - Core - Advanced Data Engineering - Data Modeling
DE&A - Core - Advanced Data Engineering - Data Modeling
Fa Etvl Saasfaprod1 Fa Ocs Oraclecloud Com CX 1 · PUNE CAMPUS, Pune, Maharashtra, IN · Active · $5 · Oracle Recruiting Cloud / Fusion HCM
Job facts
| Field | Value |
|---|---|
| Company | Fa Etvl Saasfaprod1 Fa Ocs Oraclecloud Com CX 1 |
| Title | DE&A - Core - Advanced Data Engineering - Data Modeling |
| Normalized title | - |
| Department / team | - |
| Location | Maharashtra, IN, United States |
| Work model | - |
| Employment type | - |
| Salary | $5 |
| Status | active |
| ATS provider | Oracle Recruiting Cloud / Fusion HCM |
| Posted / first seen | 2026-06-18 / 2026-06-18 |
| Changed / last seen | 2026-06-22 / 2026-06-22 |
Related slices
| Page | What it contains | Open |
|---|---|---|
| Company jobs | Active postings from Fa Etvl Saasfaprod1 Fa Ocs Oraclecloud Com CX 1. | Open |
| Company breakdowns | Role, location, ATS, and work model facets for this company. | Open |
| ATS provider jobs | Active postings observed through Oracle Recruiting Cloud / Fusion HCM. | Open |
| Provider filtered search | The same provider as a filtered job collection. | Open |
| City jobs | Active postings in Maharashtra. | Open |
| Lifecycle events | Open, update, close, and reopen events for this posting. | Open |
| Original posting | Canonical source or apply URL captured from the ATS. | Open |
Linked records
| Company | Fa Etvl Saasfaprod1 Fa Ocs Oraclecloud Com CX 1 |
| Source | e5668812-cee6-401d-baad-f458a448f385 |
| ATS provider | Oracle Recruiting Cloud / Fusion HCM |
Description
Description
We are seeking a Data Modeler to design and implement scalable, enterprise-grade data models for an insurance client building a modern cloud-based data platform . The role focuses on structuring data across Raw, Silver, and Gold layers to support batch and real-time ingestion , enable efficient reporting , and drive report rationalization initiatives .
The ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis) .
Key Responsibilities
Data Modeling & Architecture
Design conceptual, logical, and physical data models aligned to business needs and insurance domain standards Define and implement models across medallion architecture (Raw, Silver, Gold layers) Create scalable and reusable data structures optimized for analytics and reporting Data Transformation & Layer Design
Collaborate with data engineering teams to implement models using DBT Design transformation logic to move data across Raw → Silver → Gold layers Ensure consistent data definitions, hierarchies, and business rules Insurance Domain Data Structuring
Model data for core insurance functions such as: Policy Claims Billing Customer / Party Align data models with industry standards and reporting requirements Data Integration Alignment
Work closely with engineers handling: Batch ingestion via AWS Glue Real-time streaming via Amazon Kinesis Ensure models support multi-source data ingestion and harmonization Reporting & Rationalization Support
Design optimized Gold layer datasets for reporting and self-service analytics (Power BI) Support report rationalization initiatives by standardizing and consolidating data models Enable consistent KPI definitions across reports Data Quality & Governance
Define data standards, naming conventions, and metadata structures Ensure data consistency, lineage, and traceability across layers Support governance, audit, and reconciliation requirements Performance & Optimization
Design models with a focus on query performance and scalability Work with engineering teams to optimize pipelines and data structures Apply best practices for partitioning, clustering, and efficient joins in Snowflake Required Skills & Experience
Core Technical Skills
Strong expertise in: Data Modeling (Dimensional, 3NF, Data Vault – preferred) Snowflake (schema design, performance considerations) DBT (model structuring and transformation logic) Advanced proficiency in SQL Understanding of medallion architecture (Raw, Silver, Gold layers) Data Platform & Integration
Familiarity with: AWS Glue (batch data pipelines) Amazon Kinesis (real-time streaming) Experience designing models for multi-source integrated data platforms Analytics & Reporting
Understanding of data consumption patterns for reporting and analytics Domain Expertise (Must)
Strong understanding of Insurance domain data models (Policy, Claims, Billing, Underwriting) Exposure to enterprise data platforms in insurance organizations Experience
5–10 years of experience in Data Modeling / Data Architecture Experience in cloud-based data platforms and modern data stack
Responsibilities
Data Modeller
Qualifications
Data Modeller
Company
At Zensar, we’re “experience-led everything” . We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures . Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus .
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Full job record
| Job ID | 855cec4f144dddb667eaf9ad2ad802a0a79cfa36 |
| Org ID | 5a37f742-8bcb-45fc-a5cb-7cda94e88572 |
| Source ID | e5668812-cee6-401d-baad-f458a448f385 |
| Board ID | e5668812-cee6-401d-baad-f458a448f385 |
| Provider | oracle_hcm |
| Provider Job Key | 146977 |
| Title | DE&A - Core - Advanced Data Engineering - Data Modeling |
| Normalized Title | — |
| Status | active |
| Active | yes |
| Location Text | PUNE CAMPUS, Pune, Maharashtra, IN |
| Department | — |
| Team | — |
| Employment Type | — |
| Workplace Type | — |
| Remote Policy | — |
| Country | United States |
| Region | IN |
| City | Maharashtra |
| Salary Raw | Description We are seeking a Data Modeler to design and implement scalable, enterprise-grade data models for an insurance client building a modern cloud-based data platform . The role focuses on structuring data across Raw, Silver, and Gold layers to support batch and real-time ingestion , enable efficient reporting , and drive report rationalization initiatives . The ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis) . Key Responsibilities Data Modeling & Architecture Design conceptual, logical, and physical data models aligned to business needs and insurance domain standards Define and implement models across medallion architecture (Raw, Silver, Gold layers) Create scalable and reusable data structures optimized for analytics and reporting Data Transformation & Layer Design Collaborate with data engineering teams to implement models using DBT Design transformation logic to move data across Raw → Silver → Gold layers Ensure consistent data definitions, hierarchies, and business rules Insurance Domain Data Structuring Model data for core insurance functions such as: Policy Claims Billing Customer / Party Align data models with industry standards and reporting requirements Data Integration Alignment Work closely with engineers handling: Batch ingestion via AWS Glue Real-time streaming via Amazon Kinesis Ensure models support multi-source data ingestion and harmonization Reporting & Rationalization Support Design optimized Gold layer datasets for reporting and self-service analytics (Power BI) Support report rationalization initiatives by standardizing and consolidating data models Enable consistent KPI definitions across reports Data Quality & Governance Define data standards, naming conventions, and metadata structures Ensure data consistency, lineage, and traceability across layers Support governance, audit, and reconciliation requirements Performance & Optimization Design models with a focus on query performance and scalability Work with engineering teams to optimize pipelines and data structures Apply best practices for partitioning, clustering, and efficient joins in Snowflake Required Skills & Experience Core Technical Skills Strong expertise in: Data Modeling (Dimensional, 3NF, Data Vault – preferred) Snowflake (schema design, performance considerations) DBT (model structuring and transformation logic) Advanced proficiency in SQL Understanding of medallion architecture (Raw, Silver, Gold layers) Data Platform & Integration Familiarity with: AWS Glue (batch data pipelines) Amazon Kinesis (real-time streaming) Experience designing models for multi-source integrated data platforms Analytics & Reporting Understanding of data consumption patterns for reporting and analytics Domain Expertise (Must) Strong understanding of Insurance domain data models (Policy, Claims, Billing, Underwriting) Exposure to enterprise data platforms in insurance organizations Experience 5–10 years of experience in Data Modeling / Data Architecture Experience in cloud-based data platforms and modern data stack Responsibilities Data Modeller Qualifications Data Modeller Company At Zensar, we’re “experience-led everything” . We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: Together, we shape experiences for better futures . Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is ONE with Client - a set of four core values that reflect who we are and how we work: One Zensar, Nurturing, Empowering, and Client Focus . Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself. We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status. |
| Salary Min | 4.8 |
| Salary Max | — |
| Salary Currency | USD |
| Salary Period | — |
| Source URL | https://fa-etvl-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/146977 |
| Apply URL | https://fa-etvl-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/146977 |
| First Seen At | 2026-06-18 11:46:56Z |
| Last Seen At | 2026-06-22 15:25:45Z |
| Last Checked At | 2026-06-22 15:25:45Z |
| Last Changed At | 2026-06-22 15:25:45Z |
| Inactive At | — |
| Source Posted At | 2026-06-18 06:52:04Z |
| Source Updated At | — |
| Raw Payload Uri | s3://job-postings-prod-raw-590183727216/raw/provider=oracle_hcm/board=fa-etvl-saasfaprod1.fa.ocs.oraclecloud.com|CX_1/date=2026-06-22/2026-06-22T15-24-22-600Z-2fee4eb51ab9fee905363616e840ee2d9000c768d4f4588f8b91f2893e0d6aee.json |
Event Fields
{
"content_hash": "6e0814b0014bf2a45fb683c558bb7b8d3cf8ae4f683739bd5c131b8f1fa50c17",
"source_hash": "63af6189960f94940c488a8041ff4c8984b6b8c21985b3e90f3c5bfa8750fae0",
"last_changed_at": "2026-06-22T15:25:45.947Z",
"active_status": "active"
}Parsed Structured
{
"dedupe": null,
"language": "en",
"location": {
"raw": "PUNE CAMPUS, Pune, Maharashtra, IN",
"city": "Maharashtra",
"region": "IN",
"country": "United States",
"is_remote": false,
"confidence": 0.9
},
"salary_max": null,
"salary_min": 4.8,
"inferred_at": "2026-06-22T15:25:45.321Z",
"launch_scope": {
"reason": "english_us_canada",
"included": true,
"language": "en",
"location": {
"raw": "PUNE CAMPUS, Pune, Maharashtra, IN",
"city": "Maharashtra",
"region": "IN",
"country": "United States",
"is_remote": false,
"confidence": 0.9
},
"countries": [
"United States"
]
},
"remote_policy": null,
"salary_period": null,
"workplace_type": null,
"salary_currency": "USD"
}Extensions
{}Native Structured
{
"detail": {
"Id": "146977",
"Title": "DE&A - Core - Advanced Data Engineering - Data Modeling",
"media": [],
"skills": [],
"JobType": null,
"Category": null,
"JobGrade": null,
"JobLevel": null,
"JobShift": "Day Job",
"WorkDays": null,
"WorkHours": null,
"WorkYears": null,
"Department": null,
"HotJobFlag": false,
"StudyLevel": null,
"WorkMonths": null,
"WorkerType": null,
"GeographyId": 100000012279676,
"JobFamilyId": null,
"JobFunction": null,
"JobSchedule": null,
"BusinessUnit": null,
"ContractType": null,
"Organization": null,
"TrendingFlag": true,
"workLocation": [
{
"Country": "IN",
"Region1": null,
"Region2": "Maharashtra",
"Region3": null,
"Building": null,
"Latitude": "18.55488",
"Longitude": "73.92782",
"LocationId": 300000007701886,
"PostalCode": "411014",
"TownOrCity": "Pune",
"AddressLine1": "Plot No. 4, MIDC, Kharadi",
"AddressLine2": "Off Nagar Road,",
"AddressLine3": null,
"AddressLine4": null,
"LocationName": "PUNE CAMPUS"
}
],
"ContentLocale": "en",
"HiringManager": null,
"LegalEmployer": null,
"RequisitionId": 300001943210559,
"WorkplaceType": "",
"BusinessUnitId": 300000007812035,
"OrganizationId": 1,
"GeographyNodeId": 300000250949657,
"JobFunctionCode": null,
"LegalEmployerId": 300000007701009,
"PrimaryLocation": "Pune, Maharashtra, India",
"RequisitionType": "Professional (Lateral, Experienced, Subcon Hiring)",
"NumberOfOpenings": null,
"WorkplaceTypeCode": null,
"BeFirstToApplyFlag": false,
"otherWorkLocations": [],
"secondaryLocations": [],
"ExternalContactName": null,
"ShortDescriptionStr": "We are seeking a Data Modeler to design and implement scalable, enterprise-grade data models for an insurance client building a modern cloud-based data platform. The role focuses on structuring data across Raw, Silver, and Gold layers to support batch and real-time ingestion, enable efficient reporting, and drive report rationalization initiatives.\nThe ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis).\n \nKey Responsibilities\nData Modeling & Architecture\n•\tDesign conceptual, logical, and physical data models aligned to business needs and insurance domain standards\n•\tDefine and implement models across medallion architecture (Raw, Silver, Gold layers)\n•\tCreate scalable and reusable data structures optimized for analytics and reporting\nData Transformation & Layer Design\n•\tCollaborate with data engineering teams to implement models using DBT\n•\tDesign tra",
"ExternalContactEmail": null,
"ExternalPostedEndDate": null,
"OtherRequisitionTitle": null,
"requisitionFlexFields": [
{
"Value": "Yes",
"Prompt": "Work from Anywhere",
"ControlType": "SingleChoiceList",
"SequenceNumber": 15
},
{
"Value": "5",
"Prompt": "Minimum Experience (In Years)",
"ControlType": "Decimal",
"SequenceNumber": 18
},
{
"Value": "10",
"Prompt": "Maximum Experience (In Years)",
"ControlType": "Decimal",
"SequenceNumber": 19
}
],
"ApplyWhenNotPostedFlag": false,
"DomesticTravelRequired": null,
"ExternalDescriptionStr": "<p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">We are seeking a <strong>Data Modeler</strong> to design and implement <strong>scalable, enterprise-grade data models</strong> for an insurance client building a <strong>modern cloud-based data platform</strong>. The role focuses on structuring data across <strong>Raw, Silver, and Gold layers</strong> to support <strong>batch and real-time ingestion</strong>, enable <strong>efficient reporting</strong>, and drive <strong>report rationalization initiatives</strong>.</span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">The ideal candidate will have strong expertise in <strong>data modeling (conceptual, logical, physical)</strong> and experience working with <strong>Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis)</strong>.</span></span></p><hr><p><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Key Responsibilities</strong></span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Modeling & Architecture</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Design <strong>conceptual, logical, and physical data models</strong> aligned to business needs and insurance domain standards</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Define and implement models across <strong>medallion architecture (Raw, Silver, Gold layers)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Create <strong>scalable and reusable data structures</strong> optimized for analytics and reporting</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Transformation & Layer Design</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Collaborate with data engineering teams to implement models using <strong>DBT</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Design transformation logic to move data across <strong>Raw → Silver → Gold layers</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Ensure consistent data definitions, hierarchies, and business rules</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Insurance Domain Data Structuring</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Model data for <strong>core insurance functions</strong> such as: </span></span><ul style=\"list-style-type: circle;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Policy</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Claims</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Billing</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Customer / Party</span></span></li></ul></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Align data models with <strong>industry standards and reporting requirements</strong></span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Integration Alignment</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Work closely with engineers handling: </span></span><ul style=\"list-style-type: circle;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Batch ingestion via AWS Glue</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Real-time streaming via Amazon Kinesis</strong></span></span></li></ul></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Ensure models support <strong>multi-source data ingestion</strong> and harmonization</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Reporting & Rationalization Support</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Design optimized <strong>Gold layer datasets</strong> for reporting and self-service analytics (Power BI)</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Support <strong>report rationalization initiatives</strong> by standardizing and consolidating data models</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Enable consistent KPI definitions across reports</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Quality & Governance</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Define data standards, naming conventions, and metadata structures</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Ensure <strong>data consistency, lineage, and traceability</strong> across layers</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Support governance, audit, and reconciliation requirements</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Performance & Optimization</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Design models with a focus on <strong>query performance and scalability</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Work with engineering teams to <strong>optimize pipelines and data structures</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Apply best practices for <strong>partitioning, clustering, and efficient joins</strong> in Snowflake</span></span></li></ul><hr><p><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Required Skills & Experience</strong></span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Core Technical Skills</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Strong expertise in: </span></span><ul style=\"list-style-type: circle;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Data Modeling (Dimensional, 3NF, Data Vault – preferred)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Snowflake (schema design, performance considerations)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>DBT (model structuring and transformation logic)</strong></span></span></li></ul></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Advanced proficiency in <strong>SQL</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Understanding of <strong>medallion architecture (Raw, Silver, Gold layers)</strong></span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Platform & Integration</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Familiarity with: </span></span><ul style=\"list-style-type: circle;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>AWS Glue (batch data pipelines)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Amazon Kinesis (real-time streaming)</strong></span></span></li></ul></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Experience designing models for <strong>multi-source integrated data platforms</strong></span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Analytics & Reporting</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Understanding of <strong>data consumption patterns for reporting and analytics</strong></span></span></li></ul><hr><p><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Domain Expertise (Must)</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Strong understanding of <strong>Insurance domain data models</strong> (Policy, Claims, Billing, Underwriting)</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Exposure to <strong>enterprise data platforms in insurance organizations</strong></span></span></li></ul><hr><p><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Experience</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">5–10 years of experience in <strong>Data Modeling / Data Architecture</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: "Segoe UI", sans-serif;\"><span style=\"font-size: 10.5pt;\">Experience in <strong>cloud-based data platforms and modern data stack</strong></span></span></li></ul><p> </p>",
"ObjectVerNumberProfile": null,
"PrimaryLocationCountry": "IN",
"CorporateDescriptionStr": "At Zensar, we’re <i>“experience-led everything”</i>. We are committed to conceptualizing, designing, engineering, marketing, and managing digital solutions and experiences for over 130 leading enterprises. We are a company driven by a bold purpose: <i>Together, we shape experiences for better futures</i>. Whether for our clients, our people, or the world around us, this belief powers everything we do. At the heart of our culture is <i>ONE with Client</i> - a set of four core values that reflect who we are and how we work: <i>One Zensar, Nurturing, Empowering, and Client Focus</i>.<br/><br/> Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore <a href=\"https://www.zensar.com/careers/\" target=\"_blank\">Life at Zensar</a> and join us to <a href=\"https://www.youtube.com/embed/i2NZsiQqVnU?autoplay=1&fs=1\" target=\"_blank\">Grow. Own. Achieve. Learn.</a> to be the best version of yourself.<br/><br/> We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.",
"ExternalPostedStartDate": "2026-06-18T06:52:04+00:00",
"ExternalQualificationsStr": "<p>Data Modeller</p>",
"InternalQualificationsStr": "<p>Data Modeller</p>",
"OrganizationDescriptionStr": "",
"primaryLocationCoordinates": [
{
"Latitude": "18.50421",
"Longitude": "73.85286",
"CountryCode": "IN",
"GeographyId": 100000012279676,
"GeographyNodeId": 300000250949657
}
],
"ExternalResponsibilitiesStr": "<p>Data Modeller</p>",
"InternalResponsibilitiesStr": "<p>Data Modeller</p>",
"InternationalTravelRequired": null
},
"list_job": {
"Id": "146977",
"Title": "DE&A - Core - Advanced Data Engineering - Data Modeling",
"JobType": null,
"Distance": 1781740800000,
"JobShift": null,
"Language": "US",
"WorkDays": null,
"JobFamily": null,
"Relevancy": 8,
"WorkHours": null,
"Department": null,
"HotJobFlag": false,
"PostedDate": "2026-06-18",
"StudyLevel": null,
"WorkerType": null,
"GeographyId": 100000012279676,
"JobFunction": null,
"JobSchedule": null,
"BusinessUnit": null,
"ContractType": null,
"ManagerLevel": null,
"Organization": null,
"TrendingFlag": true,
"workLocation": [
{
"Country": "IN",
"Region1": null,
"Region2": "Maharashtra",
"Region3": null,
"Building": null,
"Latitude": 18.55488,
"Longitude": 73.92782,
"LocationId": 300000007701886,
"PostalCode": "411014",
"TownOrCity": "Pune",
"AddressLine1": "Plot No. 4, MIDC, Kharadi",
"AddressLine2": "Off Nagar Road,",
"AddressLine3": null,
"AddressLine4": null,
"LocationName": "PUNE CAMPUS"
}
],
"LegalEmployer": null,
"MediaThumbURL": null,
"WorkplaceType": "",
"BusinessUnitId": 300000007812035,
"OrganizationId": 1,
"PostingEndDate": null,
"LegalEmployerId": 300000007701009,
"PrimaryLocation": "Pune, Maharashtra, India",
"WorkDurationYears": null,
"WorkplaceTypeCode": null,
"BeFirstToApplyFlag": false,
"WorkDurationMonths": null,
"otherWorkLocations": [],
"secondaryLocations": [],
"ShortDescriptionStr": "We are seeking a Data Modeler to design and implement scalable, enterprise-grade data models for an insurance client building a modern cloud-based data platform. The role focuses on structuring data across Raw, Silver, and Gold layers to support batch and real-time ingestion, enable efficient reporting, and drive report rationalization initiatives.\nThe ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis).\n \nKey Responsibilities\nData Modeling & Architecture\n•\tDesign conceptual, logical, and physical data models aligned to business needs and insurance domain standards\n•\tDefine and implement models across medallion architecture (Raw, Silver, Gold layers)\n•\tCreate scalable and reusable data structures optimized for analytics and reporting\nData Transformation & Layer Design\n•\tCollaborate with data engineering teams to implement models using DBT\n•\tDesign tra",
"requisitionFlexFields": [],
"DomesticTravelRequired": null,
"PrimaryLocationCountry": "IN",
"ExternalQualificationsStr": null,
"ExternalResponsibilitiesStr": null,
"InternationalTravelRequired": null
},
"detail_meta": {
"url": "https://fa-etvl-saasfaprod1.fa.ocs.oraclecloud.com/hcmRestApi/resources/latest/recruitingCEJobRequisitionDetails?expand=all&onlyData=true&finder=ById;Id=%22146977%22,siteNumber=CX_1",
"http_status": 200,
"content_type": "application/json",
"response_bytes": 19233
},
"detail_errors": []
}Get this page with API
Rendered from the bluedoor Job Postings API. Reproduce it:
GET https://api.bluedoor.sh/job-postings/v1/jobs/855cec4f144dddb667eaf9ad2ad802a0a79cfa36?include=descriptionJSONGET https://api.bluedoor.sh/job-postings/v1/orgs/5a37f742-8bcb-45fc-a5cb-7cda94e88572JSONGET https://api.bluedoor.sh/job-postings/v1/sources/e5668812-cee6-401d-baad-f458a448f385JSONGET https://api.bluedoor.sh/job-postings/v1/jobs/855cec4f144dddb667eaf9ad2ad802a0a79cfa36/eventsJSON