DE&A - Core - Advanced Data Engineering - Advanced Data Engineering (Other)

{
  "content_hash": "e5007dc939ff26cdd2b9db41dbfa2f5c30e0e51d55e7181cf5fd4e8b455c9be7",
  "source_hash": "f9676109b6849d8ecdc338df451ee0a503e49b223c819f8188a7ee10770cc649",
  "last_changed_at": "2026-06-22T15:25:45.947Z",
  "active_status": "active"
}

{
  "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.318Z",
  "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"
}

{}

{
  "detail": {
    "Id": "146976",
    "Title": "DE&A - Core - Advanced Data Engineering - Advanced Data Engineering (Other)",
    "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": false,
    "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": 300001943190212,
    "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": true,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ExternalContactName": null,
    "ShortDescriptionStr": "Solution Architect – Data Migration & Analytics (Insurance)\nRole Summary\nWe are hiring a Solution Architect to lead a strategic data modernization program involving migration from 14+ source systems (including Guidewire InsuranceNow) into a Snowflake-based Data Warehouse leveraging dbt. The role also includes driving a report rationalization initiative, consolidating legacy reports into a streamlined Power BI analytics layer.\nThis is a high-impact role requiring strong expertise in data architecture, large-scale migration, and insurance domain transformation.\n \nKey Responsibilities\nArchitecture & Design\n•\tDefine end-to-end data architecture for ingesting structured and unstructured data into Snowflake.\n•\tArchitect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks.\n•\tEstablish scalable, secure, and performance-optimized data models.\nData Migration Leadership\n•\tDesign migration strategy for 14+ systems including InsuranceNow.\n•\tDefine data mapping,",
    "ExternalContactEmail": null,
    "ExternalPostedEndDate": null,
    "OtherRequisitionTitle": null,
    "requisitionFlexFields": [
      {
        "Value": "Yes",
        "Prompt": "Work from Anywhere",
        "ControlType": "SingleChoiceList",
        "SequenceNumber": 15
      },
      {
        "Value": "10",
        "Prompt": "Minimum Experience (In Years)",
        "ControlType": "Decimal",
        "SequenceNumber": 18
      },
      {
        "Value": "15",
        "Prompt": "Maximum Experience (In Years)",
        "ControlType": "Decimal",
        "SequenceNumber": 19
      }
    ],
    "ApplyWhenNotPostedFlag": false,
    "DomesticTravelRequired": null,
    "ExternalDescriptionStr": "<p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 24pt;\"><strong>Solution Architect – Data Migration &amp; Analytics (Insurance)</strong></span></span></p><p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Role Summary</strong></span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">We are hiring a <strong>Solution Architect</strong> to lead a strategic <strong>data modernization program</strong> involving migration from <strong>14+ source systems (including Guidewire InsuranceNow)</strong> into a <strong>Snowflake-based Data Warehouse leveraging dbt</strong>. The role also includes driving a <strong>report rationalization initiative</strong>, consolidating legacy reports into a streamlined <strong>Power BI analytics layer</strong>.</span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">This is a high-impact role requiring strong expertise in <strong>data architecture, large-scale migration, and insurance domain transformation</strong>.</span></span></p><hr><p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Key Responsibilities</strong></span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Architecture &amp; Design</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Define <strong>end-to-end data architecture</strong> for ingesting structured and unstructured data into <strong>Snowflake</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Architect <strong>layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold)</strong> using <strong>dbt-based ELT frameworks</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Establish scalable, secure, and performance-optimized data models.</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Data Migration Leadership</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Design migration strategy for <strong>14+ systems including InsuranceNow</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Define <strong>data mapping, transformation logic, and reconciliation frameworks</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Implement <strong>data quality controls, auditability, and parallel validation mechanisms</strong>.</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Analytics &amp; Reporting Modernization</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Lead <strong>report rationalization and consolidation</strong> initiative.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Design <strong>Power BI semantic layer</strong> and standardize KPIs.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Eliminate redundant reports and enable unified, business-friendly dashboards.</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Governance &amp; Quality</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Establish <strong>data governance, lineage, and metadata standards</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Ensure compliance with <strong>insurance regulatory and audit requirements</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Define <strong>quality KPIs and monitoring frameworks</strong>.</span></span></li></ul><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 13.5pt;\"><strong>Stakeholder Leadership</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Act as <strong>technical SME and advisor</strong> for business, data, and leadership teams.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Drive <strong>architecture governance, design reviews, and delivery alignment</strong>.</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Identify and mitigate risks in a complex multi-source migration program.</span></span></li></ul><hr><p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Required Experience</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">10+ years in <strong>data engineering / data architecture</strong>, with enterprise-scale programs</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Proven expertise in:&nbsp;</span></span><ul style=\"list-style-type: circle;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Snowflake &amp; dbt</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Multi-source data migration (10+ systems)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Data modeling (dimensional / data vault)</strong></span></span></li></ul></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Hands-on experience in <strong>Power BI and report consolidation</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Strong understanding of <strong>structured + unstructured data integration</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Experience with <strong>cloud platforms (Azure / AWS / GCP)</strong></span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\"><strong>Knowledge of Cortex AI&nbsp;</strong>is a plus</span></span></li></ul><hr><p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Domain Expertise</strong></span></span></p><ul style=\"list-style-type: disc;\"><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Insurance domain experience (<strong>P&amp;C preferred</strong>)</span></span></li><li style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">Understanding of <strong>policy, claims, billing, and customer data models</strong></span></span></li></ul><hr><p><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 18pt;\"><strong>Ideal Candidate Profile</strong></span></span></p><p style=\"line-height: 15pt;\"><span style=\"font-family: &quot;Segoe UI&quot;, sans-serif;\"><span style=\"font-size: 10.5pt;\">A <strong>hands-on architect and strategic thinker</strong> who can balance <strong>technical depth with business alignment</strong>, and has delivered <strong>large-scale data transformation programs in the insurance domain</strong>.</span></span></p><p>&nbsp;</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>&nbsp;and join us to <a href=\"https://www.youtube.com/embed/i2NZsiQqVnU?autoplay=1&amp;fs=1\" target=\"_blank\">Grow. Own. Achieve. Learn.</a>&nbsp;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:50:01+00:00",
    "ExternalQualificationsStr": "<p>Solution Designing experience</p>",
    "InternalQualificationsStr": "<p>Solution Designing experience</p>",
    "OrganizationDescriptionStr": "",
    "primaryLocationCoordinates": [
      {
        "Latitude": "18.50421",
        "Longitude": "73.85286",
        "CountryCode": "IN",
        "GeographyId": 100000012279676,
        "GeographyNodeId": 300000250949657
      }
    ],
    "ExternalResponsibilitiesStr": "<p>Architecture</p>",
    "InternalResponsibilitiesStr": "<p>Architecture</p>",
    "InternationalTravelRequired": null
  },
  "list_job": {
    "Id": "146976",
    "Title": "DE&A - Core - Advanced Data Engineering - Advanced Data Engineering (Other)",
    "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": false,
    "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": true,
    "WorkDurationMonths": null,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ShortDescriptionStr": "Solution Architect – Data Migration & Analytics (Insurance)\nRole Summary\nWe are hiring a Solution Architect to lead a strategic data modernization program involving migration from 14+ source systems (including Guidewire InsuranceNow) into a Snowflake-based Data Warehouse leveraging dbt. The role also includes driving a report rationalization initiative, consolidating legacy reports into a streamlined Power BI analytics layer.\nThis is a high-impact role requiring strong expertise in data architecture, large-scale migration, and insurance domain transformation.\n \nKey Responsibilities\nArchitecture & Design\n•\tDefine end-to-end data architecture for ingesting structured and unstructured data into Snowflake.\n•\tArchitect layered DWH (Raw/Bronze, Curated/Silver, Consumption/Gold) using dbt-based ELT frameworks.\n•\tEstablish scalable, secure, and performance-optimized data models.\nData Migration Leadership\n•\tDesign migration strategy for 14+ systems including InsuranceNow.\n•\tDefine data mapping,",
    "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=%22146976%22,siteNumber=CX_1",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 15750
  },
  "detail_errors": []
}