Home › Companies › Fa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2 › Lead 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
| Field | Value |
|---|---|
| Company | Fa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2 |
| Title | Lead Data Engineer – Snowflake |
| Normalized title | - |
| Department / team | Data Analytics |
| Location | United States |
| Work model | Hybrid / Hybrid |
| Employment type | Full Time |
| Salary | - |
| Status | active |
| ATS provider | Oracle Recruiting Cloud / Fusion HCM |
| Posted / first seen | 2026-06-22 / 2026-06-22 |
| Changed / last seen | 2026-06-22 / 2026-06-22 |
Related slices
| Page | What it contains | Open |
|---|---|---|
| Company jobs | Active postings from Fa Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2. | 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 |
| Department jobs | Active postings in Data Analytics. | Open |
| Work model jobs | Active Hybrid postings. | 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 Ewjt Saasfaprod1 Fa Ocs Oraclecloud Com Cx 2 |
| Source | 907773df-d032-42dc-b60a-978734f5ac21 |
| ATS provider | Oracle 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 ID | 32913ba47bca4a376ffc018eca0bc1d52004d4eb |
| Org ID | 3ea3b397-9a23-408a-8421-50fd1d902746 |
| Source ID | 907773df-d032-42dc-b60a-978734f5ac21 |
| Board ID | 907773df-d032-42dc-b60a-978734f5ac21 |
| Provider | oracle_hcm |
| Provider Job Key | 15859 |
| Title | Lead Data Engineer – Snowflake |
| Normalized Title | — |
| Status | active |
| Active | yes |
| Location Text | United States; Exl -Pennsylvania |
| Department | Data Analytics |
| Team | — |
| Employment Type | full_time |
| Workplace Type | hybrid |
| Remote Policy | hybrid |
| Country | United States |
| Region | — |
| City | — |
| Salary Raw | 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. |
| Salary Min | — |
| Salary Max | — |
| Salary Currency | — |
| Salary Period | day |
| Source URL | https://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/cx_2/job/15859 |
| Apply URL | https://fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/cx_2/job/15859 |
| First Seen At | 2026-06-22 14:47:23Z |
| Last Seen At | 2026-06-22 14:47:23Z |
| Last Checked At | 2026-06-22 14:47:23Z |
| Last Changed At | 2026-06-22 14:47:23Z |
| Inactive At | — |
| Source Posted At | 2026-06-22 13:21:57Z |
| Source Updated At | — |
| Raw Payload Uri | s3://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 & EXPERIENCE</strong></p>\n<p><strong>Technical Skills (Must Have)</strong></p>\n<p>● 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).</p>\n<p>● Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.</p>\n<p>● Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).</p>\n<p>● Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.</p>\n<p>● Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.</p>\n<p>● Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.</p>\n<p>● Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.</p>\n<p>● Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).</p>\n<p> </p>\n<p><strong>Delivery & Leadership Skills</strong></p>\n<p>● Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.</p>\n<p>● Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.</p>\n<p>● Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.</p>\n<p>● Experience working in a client-facing consulting or managed services model is strongly preferred.</p>\n<p>● Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging.</p>\n<p> </p>\n<p><strong>PREFERRED BACKGROUND</strong></p>\n<p>● 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>● Snowflake SnowPro Core or Advanced Data Engineer certification.</p>\n<p>● Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement.</p>\n<p>● Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks).</p>\n<p>● Familiarity with Snowflake Snowpark, Streams & Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns.</p>\n<p>● Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context.</p>\n<p> </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> </p>\n<p>● Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath.</p>\n<p>● 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>● 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>● 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 & EXPERIENCE</strong></p>\n<p><strong>Technical Skills (Must Have)</strong></p>\n<p>● 8+ years of data engineering experience; minimum 3 years hands-on with Snowflake (architecture, SQL dialect, performance tuning, RBAC).</p>\n<p>● Proven experience migrating Teradata workloads to Snowflake — including BTEQ/ANSI SQL translation, macro conversion, and stored procedure migration.</p>\n<p>● Strong PySpark and Python skills; experience working with Databricks is required (MLOps pipelines a strong plus).</p>\n<p>● Working knowledge of Apache Airflow — DAG management, variable configuration, connection updates across environments.</p>\n<p>● Familiarity with IICS (Informatica Intelligent Cloud Services) and/or SSIS (.dtsx) pipelines in a migration context.</p>\n<p>● Solid understanding of data lake and object store patterns (Minio, S3, ADLS) and how they integrate with Snowflake external stages.</p>\n<p>● Experience with SQL Server, Teradata, and/or Netezza as source platforms is required.</p>\n<p>● Strong Git proficiency; experience with CI/CD pipelines and code change coordination across environments (dev → parallel → prod).</p>\n<p> </p>\n<p><strong>Delivery & Leadership Skills</strong></p>\n<p>● Proven experience leading a team of 5+ engineers in a fast-paced, time-bound migration or repointing program.</p>\n<p>● Ability to manage scope across complexity bands (S/M/L scripts) and balance team capacity against tight delivery timelines.</p>\n<p>● Strong stakeholder management — able to communicate migration status, risks, and escalation paths clearly to both technical and business audiences.</p>\n<p>● Experience working in a client-facing consulting or managed services model is strongly preferred.</p>\n<p>● Comfortable coordinating with an SI Partner — understanding scope boundaries, handoff points, and utility dependencies without micromanaging.</p>\n<p> </p>\n<p><strong>PREFERRED BACKGROUND</strong></p>\n<p>● 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>● Snowflake SnowPro Core or Advanced Data Engineer certification.</p>\n<p>● Prior experience delivering migrations within an EXL, consulting firm, or analytics-driven managed services engagement.</p>\n<p>● Exposure to data observability and reconciliation tooling (Great Expectations, Monte Carlo, or custom validation frameworks).</p>\n<p>● Familiarity with Snowflake Snowpark, Streams & Tasks, or Dynamic Tables for replacing legacy Teradata batch patterns.</p>\n<p>● Experience with Databricks Unity Catalog or MLOps frameworks in an enterprise telecom context.</p>\n<p> </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> </p>\n<p>● Someone who can read a Teradata BTEQ script and a Snowflake execution plan in the same breath.</p>\n<p>● 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>● 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>● 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> </p>\n<p><strong>KEY RESPONSIBILITIES</strong></p>\n<p><strong>Repointing Execution & Delivery</strong></p>\n<p>● 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>● Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).</p>\n<p>● Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.</p>\n<p>● Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.</p>\n<p>● Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.</p>\n<p>● Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.</p>\n<p> </p>\n<p><strong>Team Leadership</strong></p>\n<p>● 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>● 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>● Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.</p>\n<p>● Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences.</p>\n<p>● Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.</p>\n<p> </p>\n<p><strong>Validation, Reconciliation & Quality</strong></p>\n<p>● 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>● Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.</p>\n<p>● 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>● Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.</p>\n<p>● Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.</p>\n<p> </p>\n<p><strong>Stakeholder & SI Partner Coordination</strong></p>\n<p>● 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>● 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>● Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.</p>\n<p><span>● 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> </p>\n<p><strong>KEY RESPONSIBILITIES</strong></p>\n<p><strong>Repointing Execution & Delivery</strong></p>\n<p>● 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>● Execute SQL syntax conversion for Teradata BTEQ scripts to Snowflake-compatible SQL, leveraging utility frameworks provided by the SI Partner (Infosys).</p>\n<p>● Drive Airflow variable and connection updates across all migrated workflows, ensuring pipelines point to Snowflake endpoints post-cutover.</p>\n<p>● Manage the script modification and change management process, coordinating production-to-parallel sync within the required 1-business-day SLA.</p>\n<p>● Own the deployment and sign-off process for each migration wave, maintaining runbooks and go/no-go checklists per domain group.</p>\n<p>● Manage data copy requests for Minio-related assets and coordinate initial load and incremental sync activities with the SI Partner.</p>\n<p> </p>\n<p><strong>Team Leadership</strong></p>\n<p>● 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>● 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>● Review code changes, validate SQL conversion quality, and enforce engineering standards before submission to EBI team for review.</p>\n<p>● Mentor junior engineers on Snowflake-specific constructs (virtual warehouses, stages, Snowpark, streams & tasks) and Teradata-to-Snowflake syntax differences.</p>\n<p>● Conduct daily stand-ups and provide weekly migration status reports to the Program Manager and client stakeholders.</p>\n<p> </p>\n<p><strong>Validation, Reconciliation & Quality</strong></p>\n<p>● 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>● Drive automation of unit testing and validation frameworks in collaboration with the SI Partner, tracking outcomes in the centralized validation dashboard.</p>\n<p>● 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>● Ensure UAT sign-off from the EBI Data team on each domain group before scheduling production cutover.</p>\n<p>● Conduct performance and load testing on migrated Snowflake workloads; incorporate SI Partner guidance on query optimization and warehouse sizing.</p>\n<p> </p>\n<p><strong>Stakeholder & SI Partner Coordination</strong></p>\n<p>● 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>● 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>● Translate migration risks and data reconciliation issues into clear business-impact language for non-technical stakeholders.</p>\n<p><span>● 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=descriptionJSONGET https://api.bluedoor.sh/job-postings/v1/orgs/3ea3b397-9a23-408a-8421-50fd1d902746JSONGET https://api.bluedoor.sh/job-postings/v1/sources/907773df-d032-42dc-b60a-978734f5ac21JSONGET https://api.bluedoor.sh/job-postings/v1/jobs/32913ba47bca4a376ffc018eca0bc1d52004d4eb/eventsJSON