bluedoor data·Job Postings API·bluedoor.sh ↗

HomeCompaniesFa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2Lead Data Engineer – Snowflake

Lead Data Engineer – Snowflake

Fa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2 · United States; Exl -Pennsylvania · Hybrid · Active · Oracle Recruiting Cloud / Fusion HCM

Job facts

FieldValue
CompanyFa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2
TitleLead Data Engineer – Snowflake
Normalized title-
Department / teamData Analytics
LocationUnited States
Work modelHybrid / Hybrid
Employment typeFull Time
Salary-
Statusactive
ATS providerOracle Recruiting Cloud / Fusion HCM
Posted / first seen2026-06-22 / 2026-06-22
Changed / last seen2026-06-22 / 2026-06-22

Related slices

PageWhat it containsOpen
Company jobsActive postings from Fa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2.Open
Company breakdownsRole, location, ATS, and work model facets for this company.Open
ATS provider jobsActive postings observed through Oracle Recruiting Cloud / Fusion HCM.Open
Provider filtered searchThe same provider as a filtered job collection.Open
Department jobsActive postings in Data Analytics.Open
Work model jobsActive Hybrid postings.Open
Lifecycle eventsOpen, update, close, and reopen events for this posting.Open
Original postingCanonical source or apply URL captured from the ATS.Open

Linked records

CompanyFa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2
Source907773df-d032-42dc-b60a-978734f5ac21
ATS providerOracle Recruiting Cloud / Fusion HCM

Description

Description We are seeking an experienced Senior Data Engineer to serve as the onshore technical lead for the EXL augmented support team. In this role, you will lead a team of 6–8 Data Engineers (onshore/offshore) through the full repointing lifecycle: SQL syntax conversion (Teradata to Snowflake), Airflow variable and connection updates, script modification, parallel run validation, and production cutover. You will be the primary technical interface between EXL engineers, the client's EBI data team, and the SI Partner (Infosys) who provides SQL conversion utilities and infrastructure. Responsibilities Role: Lead Data Engineer – Snowflake Location: Philadelphia, PA (Hybrid) Type: FTE KEY RESPONSIBILITIES Repointing Execution & Delivery ● Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake. ● Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys). ● Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover. ● Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA. ● Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group. ● Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner. Team Leadership ● Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams. ● Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly. ● Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review. ● Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences. ● Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders. Validation, Reconciliation & Quality ● Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow. ● Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard. ● Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed. ● Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover. ● Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing. Stakeholder & SI Partner Coordination ● Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews. ● Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off. ● Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders. ● Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository. Qualifications REQUIRED SKILLS & EXPERIENCE Technical Skills (Must Have) ● 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC). ● Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration. ● Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus). ● Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments. ● Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context. ● Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages. ● Experience with SQL Server, Teradata, and/or Netezza as source platforms is required. ● Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod). Delivery & Leadership Skills ● Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program. ● Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines. ● Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences. ● Experience working in a client-facing consulting or managed services model is strongly preferred. ● Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging. PREFERRED BACKGROUND ● Domain experience in US Telecom — CDR processing, subscriber data, network inventory, or revenue assurance datasets aligned to EBI workloads (NRD, Compensation, TechOps, CB, etc.). ● Snowflake SnowPro Core or Advanced Data Engineer certification. ● Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement. ● Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks). ● Familiarity with Snowflake Snowpark, Streams & Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns. ● Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context. WHAT WE'RE LOOKING FOR A hands-on technical lead who can walk into a live migration program, immediately understand script-level complexity, own execution accountability, and keep a distributed team moving at pace — without needing the SI Partner to hold their hand. ● Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath. ● A communicator who can run a 15-minute daily sync with EBI stakeholders and translate yesterday’s reconciliation failures into a clear resolution path. ● A leader who treats the 593-script scope not as a backlog item but as a delivery commitment with a hard October 2026 deadline. ● A professional who understands the rhythm of parallel run validation — tolerates expected data mismatches, drives iterative reconciliation, and knows when to escalate versus resolve.

Full job record

Job ID32913ba47bca4a376ffc018eca0bc1d52004d4eb
Org ID3ea3b397-9a23-408a-8421-50fd1d902746
Source ID907773df-d032-42dc-b60a-978734f5ac21
Board ID907773df-d032-42dc-b60a-978734f5ac21
Provideroracle_hcm
Provider Job Key15859
TitleLead Data Engineer – Snowflake
Normalized Title
Statusactive
Activeyes
Location TextUnited States; Exl -Pennsylvania
DepartmentData Analytics
Team
Employment Typefull_time
Workplace Typehybrid
Remote Policyhybrid
CountryUnited States
Region
City
Salary RawDescription We are seeking an experienced Senior Data Engineer to serve as the onshore technical lead for the EXL augmented support team. In this role, you will lead a team of 6–8 Data Engineers (onshore/offshore) through the full repointing lifecycle: SQL syntax conversion (Teradata to Snowflake), Airflow variable and connection updates, script modification, parallel run validation, and production cutover. You will be the primary technical interface between EXL engineers, the client's EBI data team, and the SI Partner (Infosys) who provides SQL conversion utilities and infrastructure. Responsibilities Role: Lead Data Engineer – Snowflake Location: Philadelphia, PA (Hybrid) Type: FTE KEY RESPONSIBILITIES Repointing Execution & Delivery ● Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake. ● Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys). ● Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover. ● Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA. ● Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group. ● Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner. Team Leadership ● Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams. ● Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly. ● Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review. ● Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences. ● Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders. Validation, Reconciliation & Quality ● Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow. ● Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard. ● Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed. ● Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover. ● Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing. Stakeholder & SI Partner Coordination ● Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews. ● Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off. ● Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders. ● Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository. Qualifications REQUIRED SKILLS & EXPERIENCE Technical Skills (Must Have) ● 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC). ● Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration. ● Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus). ● Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments. ● Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context. ● Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages. ● Experience with SQL Server, Teradata, and/or Netezza as source platforms is required. ● Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod). Delivery & Leadership Skills ● Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program. ● Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines. ● Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences. ● Experience working in a client-facing consulting or managed services model is strongly preferred. ● Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging. PREFERRED BACKGROUND ● Domain experience in US Telecom — CDR processing, subscriber data, network inventory, or revenue assurance datasets aligned to EBI workloads (NRD, Compensation, TechOps, CB, etc.). ● Snowflake SnowPro Core or Advanced Data Engineer certification. ● Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement. ● Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks). ● Familiarity with Snowflake Snowpark, Streams & Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns. ● Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context. WHAT WE'RE LOOKING FOR A hands-on technical lead who can walk into a live migration program, immediately understand script-level complexity, own execution accountability, and keep a distributed team moving at pace — without needing the SI Partner to hold their hand. ● Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath. ● A communicator who can run a 15-minute daily sync with EBI stakeholders and translate yesterday’s reconciliation failures into a clear resolution path. ● A leader who treats the 593-script scope not as a backlog item but as a delivery commitment with a hard October 2026 deadline. ● A professional who understands the rhythm of parallel run validation — tolerates expected data mismatches, drives iterative reconciliation, and knows when to escalate versus resolve.
Salary Min
Salary Max
Salary Currency
Salary Periodday
Source URLhttps://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/cx_2/job/15859
Apply URLhttps://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/cx_2/job/15859
First Seen At2026-06-22 14:47:23Z
Last Seen At2026-06-22 14:47:23Z
Last Checked At2026-06-22 14:47:23Z
Last Changed At2026-06-22 14:47:23Z
Inactive At
Source Posted At2026-06-22 13:21:57Z
Source Updated At
Raw Payload Uris3://job-postings-prod-raw-590183727216/raw/provider=oracle_hcm/board=fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com|cx_2/date=2026-06-22/2026-06-22T14-45-36-291Z-717b700d77bda720765a1f8b2cb3f73294d43032364f10faf31b860148f4429a.json
Event Fields
{
  "content_hash": "163d1362d8d76d27d52782faccbe66df73dbee8b1a0a824d39da7d305c92c1e0",
  "source_hash": "da2fde673995a686785d6ae562929915d74ea8e9a27b0523850a8310b9f55eb5",
  "last_changed_at": "2026-06-22T14:47:23.264Z",
  "active_status": "active"
}
Parsed Structured
{
  "dedupe": null,
  "language": "en",
  "location": {
    "raw": "United States",
    "city": null,
    "region": null,
    "country": "United States",
    "is_remote": false,
    "confidence": 0.8
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-22T14:47:22.482Z",
  "launch_scope": {
    "reason": "english_us_canada",
    "included": true,
    "language": "en",
    "location": {
      "raw": "United States",
      "city": null,
      "region": null,
      "country": "United States",
      "is_remote": false,
      "confidence": 0.8
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": "hybrid",
  "salary_period": "day",
  "workplace_type": "hybrid",
  "salary_currency": null
}
Extensions
{}
Native Structured
{
  "detail": {
    "Id": "15859",
    "Title": "Lead Data Engineer – Snowflake",
    "media": [],
    "skills": [
      {
        "Skill": "Attention To Consistency",
        "SkillId": "300003950461832",
        "SectionId": "300000135879451",
        "SkillType": "SOFT_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Innovation Oriented Mindset",
        "SkillId": "300003950461833",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Internal Communications",
        "SkillId": "300003950461834",
        "SectionId": "300000135879451",
        "SkillType": "SOFT_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Interpersonal Relationship Building",
        "SkillId": "300003950461835",
        "SectionId": "300000135879451",
        "SkillType": "SOFT_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Leadership Capabilities",
        "SkillId": "300003950461836",
        "SectionId": "300000135879451",
        "SkillType": "SOFT_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Resource Management",
        "SkillId": "300003950461837",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Risk Management",
        "SkillId": "300003950461838",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Service Delivery Management",
        "SkillId": "300003950461839",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Stakeholder Management",
        "SkillId": "300003950461840",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Strategic Planning",
        "SkillId": "300003950461841",
        "SectionId": "300000135879451",
        "SkillType": "HARD_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      },
      {
        "Skill": "Working under Pressure",
        "SkillId": "300003950461842",
        "SectionId": "300000135879451",
        "SkillType": "SOFT_SKILL",
        "SectionName": "Skill",
        "ContentItemId": null
      }
    ],
    "JobType": null,
    "Category": "Data Analytics",
    "JobGrade": null,
    "JobLevel": null,
    "JobShift": null,
    "WorkDays": null,
    "WorkHours": null,
    "WorkYears": null,
    "Department": null,
    "HotJobFlag": false,
    "StudyLevel": "Bachelor's Degree",
    "WorkMonths": null,
    "WorkerType": null,
    "GeographyId": 300000000467584,
    "JobFamilyId": 300001172146126,
    "JobFunction": "Data Engineering",
    "JobSchedule": "Full time",
    "BusinessUnit": null,
    "ContractType": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [
      {
        "Country": null,
        "Region1": null,
        "Region2": null,
        "Region3": null,
        "Building": null,
        "Latitude": "",
        "Longitude": "",
        "LocationId": 300000002980538,
        "PostalCode": null,
        "TownOrCity": null,
        "AddressLine1": null,
        "AddressLine2": null,
        "AddressLine3": null,
        "AddressLine4": null,
        "LocationName": "Exl -Pennsylvania"
      }
    ],
    "ContentLocale": "en",
    "HiringManager": null,
    "LegalEmployer": null,
    "RequisitionId": 300003950461828,
    "WorkplaceType": "Hybrid",
    "BusinessUnitId": 300000002965433,
    "OrganizationId": 300000002988873,
    "GeographyNodeId": 300001186829838,
    "JobFunctionCode": "EXL_JFN_2007318629",
    "LegalEmployerId": 300000002988873,
    "PrimaryLocation": "United States",
    "RequisitionType": "Professional",
    "NumberOfOpenings": null,
    "WorkplaceTypeCode": "ORA_HYBRID",
    "BeFirstToApplyFlag": true,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ExternalContactName": null,
    "ShortDescriptionStr": "ROLE OVERVIEW\nEXL is supporting a large US telecom client (EBI Data Engineering) in a time-bound Snowflake migration program — repointing approximately 593 Teradata downstream scripts and 154 Databricks MLOps scripts to Snowflake across domains including NRD, Compensation, Foundational, TechOps, CB, Marketing, LAT, Sales, Finance, Digital, and Products.\n",
    "ExternalContactEmail": null,
    "ExternalPostedEndDate": null,
    "OtherRequisitionTitle": null,
    "requisitionFlexFields": [],
    "ApplyWhenNotPostedFlag": false,
    "DomesticTravelRequired": null,
    "ExternalDescriptionStr": "<p>We are seeking an experienced Senior Data Engineer to serve as the onshore technical lead for the EXL augmented support team. In this role, you will lead a team of 6–8 Data Engineers (onshore/offshore) through the full repointing lifecycle: SQL syntax conversion (Teradata to Snowflake), Airflow variable and connection updates, script modification, parallel run validation, and production cutover. You will be the primary technical interface between EXL engineers, the client's EBI data team, and the SI Partner (Infosys) who provides SQL conversion utilities and infrastructure.</p>",
    "ObjectVerNumberProfile": "1",
    "PrimaryLocationCountry": "US",
    "CorporateDescriptionStr": "",
    "ExternalPostedStartDate": "2026-06-22T13:21:57+00:00",
    "ExternalQualificationsStr": "<p><strong>REQUIRED SKILLS &amp; EXPERIENCE</strong></p>\n<p><strong>Technical Skills (Must Have)</strong></p>\n<p>●&nbsp;&nbsp; 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).</p>\n<p>●&nbsp;&nbsp; Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.</p>\n<p>●&nbsp;&nbsp; Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).</p>\n<p>●&nbsp;&nbsp; Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.</p>\n<p>●&nbsp;&nbsp; Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.</p>\n<p>●&nbsp;&nbsp; Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.</p>\n<p>●&nbsp;&nbsp; Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.</p>\n<p>●&nbsp;&nbsp; Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).</p>\n<p>&nbsp;</p>\n<p><strong>Delivery &amp; Leadership Skills</strong></p>\n<p>●&nbsp;&nbsp; Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.</p>\n<p>●&nbsp;&nbsp; Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.</p>\n<p>●&nbsp;&nbsp; Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.</p>\n<p>●&nbsp;&nbsp; Experience working in a client-facing consulting or managed services model is strongly preferred.</p>\n<p>●&nbsp;&nbsp; Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging.</p>\n<p>&nbsp;</p>\n<p><strong>PREFERRED BACKGROUND</strong></p>\n<p>●&nbsp;&nbsp; Domain experience in US Telecom — CDR processing, subscriber data, network inventory, or revenue assurance datasets aligned to EBI workloads (NRD, Compensation, TechOps, CB, etc.).</p>\n<p>●&nbsp;&nbsp; Snowflake SnowPro Core or Advanced Data Engineer certification.</p>\n<p>●&nbsp;&nbsp; Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement.</p>\n<p>●&nbsp;&nbsp; Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks).</p>\n<p>●&nbsp;&nbsp; Familiarity with Snowflake Snowpark, Streams &amp; Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns.</p>\n<p>●&nbsp;&nbsp; Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context.</p>\n<p>&nbsp;</p>\n<p><strong>WHAT WE'RE LOOKING FOR</strong></p>\n<p>A hands-on technical lead who can walk into a live migration program, immediately understand script-level complexity, own execution accountability, and keep a distributed team moving at pace — without needing the SI Partner to hold their hand.</p>\n<p>&nbsp;</p>\n<p>●&nbsp;&nbsp; Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath.</p>\n<p>●&nbsp;&nbsp; A communicator who can run a 15-minute daily sync with EBI stakeholders and translate yesterday’s reconciliation failures into a clear resolution path.</p>\n<p>●&nbsp;&nbsp; A leader who treats the 593-script scope not as a backlog item but as a delivery commitment with a hard October 2026 deadline.</p>\n<p><span>●&nbsp;&nbsp; A professional who understands the rhythm of parallel run validation — tolerates expected data mismatches, drives iterative reconciliation, and knows when to escalate versus resolve.</span></p>",
    "InternalQualificationsStr": "<p><strong>REQUIRED SKILLS &amp; EXPERIENCE</strong></p>\n<p><strong>Technical Skills (Must Have)</strong></p>\n<p>●&nbsp;&nbsp; 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).</p>\n<p>●&nbsp;&nbsp; Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.</p>\n<p>●&nbsp;&nbsp; Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).</p>\n<p>●&nbsp;&nbsp; Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.</p>\n<p>●&nbsp;&nbsp; Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.</p>\n<p>●&nbsp;&nbsp; Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.</p>\n<p>●&nbsp;&nbsp; Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.</p>\n<p>●&nbsp;&nbsp; Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).</p>\n<p>&nbsp;</p>\n<p><strong>Delivery &amp; Leadership Skills</strong></p>\n<p>●&nbsp;&nbsp; Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.</p>\n<p>●&nbsp;&nbsp; Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.</p>\n<p>●&nbsp;&nbsp; Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.</p>\n<p>●&nbsp;&nbsp; Experience working in a client-facing consulting or managed services model is strongly preferred.</p>\n<p>●&nbsp;&nbsp; Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging.</p>\n<p>&nbsp;</p>\n<p><strong>PREFERRED BACKGROUND</strong></p>\n<p>●&nbsp;&nbsp; Domain experience in US Telecom — CDR processing, subscriber data, network inventory, or revenue assurance datasets aligned to EBI workloads (NRD, Compensation, TechOps, CB, etc.).</p>\n<p>●&nbsp;&nbsp; Snowflake SnowPro Core or Advanced Data Engineer certification.</p>\n<p>●&nbsp;&nbsp; Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement.</p>\n<p>●&nbsp;&nbsp; Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks).</p>\n<p>●&nbsp;&nbsp; Familiarity with Snowflake Snowpark, Streams &amp; Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns.</p>\n<p>●&nbsp;&nbsp; Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context.</p>\n<p>&nbsp;</p>\n<p><strong>WHAT WE'RE LOOKING FOR</strong></p>\n<p>A hands-on technical lead who can walk into a live migration program, immediately understand script-level complexity, own execution accountability, and keep a distributed team moving at pace — without needing the SI Partner to hold their hand.</p>\n<p>&nbsp;</p>\n<p>●&nbsp;&nbsp; Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath.</p>\n<p>●&nbsp;&nbsp; A communicator who can run a 15-minute daily sync with EBI stakeholders and translate yesterday’s reconciliation failures into a clear resolution path.</p>\n<p>●&nbsp;&nbsp; A leader who treats the 593-script scope not as a backlog item but as a delivery commitment with a hard October 2026 deadline.</p>\n<p><span>●&nbsp;&nbsp; A professional who understands the rhythm of parallel run validation — tolerates expected data mismatches, drives iterative reconciliation, and knows when to escalate versus resolve.</span></p>",
    "OrganizationDescriptionStr": "",
    "primaryLocationCoordinates": [
      {
        "Latitude": "39.82844",
        "Longitude": "-98.57939",
        "CountryCode": "US",
        "GeographyId": 300000000467584,
        "GeographyNodeId": 300001186829838
      }
    ],
    "ExternalResponsibilitiesStr": "<p><strong>Role: Lead Data Engineer – Snowflake</strong></p>\n<p><strong>Location: Philadelphia, PA (Hybrid)</strong></p>\n<p><strong>Type: FTE</strong></p>\n<p>&nbsp;</p>\n<p><strong>KEY RESPONSIBILITIES</strong></p>\n<p><strong>Repointing Execution &amp; Delivery</strong></p>\n<p>●&nbsp;&nbsp; Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake.</p>\n<p>●&nbsp;&nbsp; Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).</p>\n<p>●&nbsp;&nbsp; Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.</p>\n<p>●&nbsp;&nbsp; Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.</p>\n<p>●&nbsp;&nbsp; Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.</p>\n<p>●&nbsp;&nbsp; Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.</p>\n<p>&nbsp;</p>\n<p><strong>Team Leadership</strong></p>\n<p>●&nbsp;&nbsp; Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams.</p>\n<p>●&nbsp;&nbsp; Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly.</p>\n<p>●&nbsp;&nbsp; Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.</p>\n<p>●&nbsp;&nbsp; Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams &amp; tasks) and Teradata-to-Snowflake syntax differences.</p>\n<p>●&nbsp;&nbsp; Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.</p>\n<p>&nbsp;</p>\n<p><strong>Validation, Reconciliation &amp; Quality</strong></p>\n<p>●&nbsp;&nbsp; Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow.</p>\n<p>●&nbsp;&nbsp; Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.</p>\n<p>●&nbsp;&nbsp; Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed.</p>\n<p>●&nbsp;&nbsp; Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.</p>\n<p>●&nbsp;&nbsp; Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.</p>\n<p>&nbsp;</p>\n<p><strong>Stakeholder &amp; SI Partner Coordination</strong></p>\n<p>●&nbsp;&nbsp; Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews.</p>\n<p>●&nbsp;&nbsp; Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off.</p>\n<p>●&nbsp;&nbsp; Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.</p>\n<p><span>●&nbsp;&nbsp; Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository.</span></p>",
    "InternalResponsibilitiesStr": "<p><strong>Role: Lead Data Engineer – Snowflake</strong></p>\n<p><strong>Location: Philadelphia, PA (Hybrid)</strong></p>\n<p><strong>Type: FTE</strong></p>\n<p>&nbsp;</p>\n<p><strong>KEY RESPONSIBILITIES</strong></p>\n<p><strong>Repointing Execution &amp; Delivery</strong></p>\n<p>●&nbsp;&nbsp; Lead script-level repointing across 593 downstream scripts (PySpark, BTEQ, Shell, SQL, IICS, SSIS) and 154 Databricks MLOps scripts from Teradata/SQL Server/Minio to Snowflake.</p>\n<p>●&nbsp;&nbsp; Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).</p>\n<p>●&nbsp;&nbsp; Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.</p>\n<p>●&nbsp;&nbsp; Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.</p>\n<p>●&nbsp;&nbsp; Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.</p>\n<p>●&nbsp;&nbsp; Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.</p>\n<p>&nbsp;</p>\n<p><strong>Team Leadership</strong></p>\n<p>●&nbsp;&nbsp; Lead and coordinate a team of 6–8 Data Engineer I and Data Engineer II resources (onshore and offshore) across parallel migration workstreams.</p>\n<p>●&nbsp;&nbsp; Assign scripts per complexity band (S/M/L) to team members, track daily progress against the LOE estimates, and escalate blockers promptly.</p>\n<p>●&nbsp;&nbsp; Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.</p>\n<p>●&nbsp;&nbsp; Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams &amp; tasks) and Teradata-to-Snowflake syntax differences.</p>\n<p>●&nbsp;&nbsp; Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.</p>\n<p>&nbsp;</p>\n<p><strong>Validation, Reconciliation &amp; Quality</strong></p>\n<p>●&nbsp;&nbsp; Own the parallel run and reconciliation cycle — execute data validation against Teradata source and Snowflake target, targeting sign-off within 2–3 reconciliation iterations per workflow.</p>\n<p>●&nbsp;&nbsp; Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.</p>\n<p>●&nbsp;&nbsp; Triage and root-cause data mismatches, performance gaps, and pipeline failures during the parallel run phase; coordinate resolution with SI Partner support as needed.</p>\n<p>●&nbsp;&nbsp; Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.</p>\n<p>●&nbsp;&nbsp; Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.</p>\n<p>&nbsp;</p>\n<p><strong>Stakeholder &amp; SI Partner Coordination</strong></p>\n<p>●&nbsp;&nbsp; Serve as the EXL technical point of contact with the EBI client team for the repointing workstream — attending daily syncs, steering calls, and design reviews.</p>\n<p>●&nbsp;&nbsp; Coordinate with Infosys (SI Partner) on alignment of major SQL conversion utilities prior to team execution, ensuring conversion frameworks are available at program kick-off.</p>\n<p>●&nbsp;&nbsp; Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.</p>\n<p><span>●&nbsp;&nbsp; Maintain shared documentation: migration decision log, runbooks, issue trackers, and lessons learned repository.</span></p>",
    "InternationalTravelRequired": null
  },
  "list_job": {
    "Id": "15859",
    "Title": "Lead Data Engineer – Snowflake",
    "JobType": null,
    "Distance": 1782086400000,
    "JobShift": null,
    "Language": "US",
    "WorkDays": null,
    "JobFamily": null,
    "Relevancy": 9,
    "WorkHours": null,
    "Department": null,
    "HotJobFlag": false,
    "PostedDate": "2026-06-22",
    "StudyLevel": null,
    "WorkerType": null,
    "GeographyId": 300000000467584,
    "JobFunction": null,
    "JobSchedule": null,
    "BusinessUnit": null,
    "ContractType": null,
    "ManagerLevel": null,
    "Organization": null,
    "TrendingFlag": false,
    "workLocation": [
      {
        "Country": null,
        "Region1": null,
        "Region2": null,
        "Region3": null,
        "Building": null,
        "Latitude": null,
        "Longitude": null,
        "LocationId": 300000002980538,
        "PostalCode": null,
        "TownOrCity": null,
        "AddressLine1": null,
        "AddressLine2": null,
        "AddressLine3": null,
        "AddressLine4": null,
        "LocationName": "Exl -Pennsylvania"
      }
    ],
    "LegalEmployer": null,
    "MediaThumbURL": null,
    "WorkplaceType": "Hybrid",
    "BusinessUnitId": 300000002965433,
    "OrganizationId": 300000002988873,
    "PostingEndDate": null,
    "LegalEmployerId": 300000002988873,
    "PrimaryLocation": "United States",
    "WorkDurationYears": null,
    "WorkplaceTypeCode": "ORA_HYBRID",
    "BeFirstToApplyFlag": true,
    "WorkDurationMonths": null,
    "otherWorkLocations": [],
    "secondaryLocations": [],
    "ShortDescriptionStr": "ROLE OVERVIEW\nEXL is supporting a large US telecom client (EBI Data Engineering) in a time-bound Snowflake migration program — repointing approximately 593 Teradata downstream scripts and 154 Databricks MLOps scripts to Snowflake across domains including NRD, Compensation, Foundational, TechOps, CB, Marketing, LAT, Sales, Finance, Digital, and Products.\n",
    "requisitionFlexFields": [],
    "DomesticTravelRequired": null,
    "PrimaryLocationCountry": "US",
    "ExternalQualificationsStr": null,
    "ExternalResponsibilitiesStr": null,
    "InternationalTravelRequired": null
  },
  "detail_meta": {
    "url": "https://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmRestApi/resources/latest/recruitingCEJobRequisitionDetails?expand=all&onlyData=true&finder=ById;Id=%2215859%22,siteNumber=cx_2",
    "http_status": 200,
    "content_type": "application/json",
    "response_bytes": 22304
  },
  "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/32913ba47bca4a376ffc018eca0bc1d52004d4eb?include=descriptionJSON
GET https://api.bluedoor.sh/job-postings/v1/orgs/3ea3b397-9a23-408a-8421-50fd1d902746JSON
GET https://api.bluedoor.sh/job-postings/v1/sources/907773df-d032-42dc-b60a-978734f5ac21JSON
GET https://api.bluedoor.sh/job-postings/v1/jobs/32913ba47bca4a376ffc018eca0bc1d52004d4eb/eventsJSON