Data Engineer III-6377

itD Tech; Menlo Park (CA); On-site; USD 140,000 - 180,000; Full time

Job summary

itD is seeking a Data Engineer III to build, optimize, and maintain scalable data pipelines and analytics-ready datasets powering critical operational decisions. You will support workforce measurement, reporting, and backfills, with emphasis on reliable ETL/ELT workflows and high-quality data infrastructure.

The role requires strong SQL/Python expertise, experience with Hive/Spark environments, and workflow orchestration using Dataswarm or Airflow.

Qualifications

• Strong proficiency in advanced SQL (Presto, Trino, or Spark SQL).
• Basic to intermediate Python programming for production ETL/ELT development.
• Experience building and maintaining large-scale data pipelines across Hive/Spark environments.
• Strong understanding of data warehousing fundamentals and query performance optimization.
• Experience with pipeline orchestration tools such as Dataswarm or Airflow.
• Experience troubleshooting pipeline failures and managing historical backfills.
• Understanding of data pipeline monitoring and SLA requirements.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using SQL and Python for analytics and reporting.
• Build, optimize, and maintain data workflows across Hive/Spark-based data warehouses.
• Develop and manage pipeline orchestration workflows with Dataswarm, Airflow, or equivalent tools.
• Create analytics-ready datasets and data models supporting workforce measurement and reporting.
• Monitor pipeline health, implement data quality checks, and ensure SLAs are met.
• Maintain and improve legacy pipelines and automate manual workflows to boost efficiency.
• Collaborate with data scientists, analysts, and stakeholders to translate requirements into reliable data solutions.

Skills

Advanced SQL

Python programming

Hive/Spark DW

Data warehousing

Workflow orchestration

Data quality checks

Backfills

Tools

Dataswarm

Airflow

Job description

itD is seeking a Data Engineer III to build, optimize, and maintain scalable data pipelines and analytics-ready datasets that power critical operational decisions across Meta’s Global Response Ecosystem. This role will support workforce measurement, response ecosystem reporting, pipeline automation, and historical data backfills, helping global operations teams make informed, data-driven decisions. The ideal candidate will bring strong expertise in SQL, Python, large-scale data engineering, and pipeline orchestration, with a proven ability to develop reliable ETL/ELT workflows and maintain high-quality data infrastructure.

Pay Rate: DOE

Duration: 6 Months
We provide comprehensive medical benefits, a 401k plan, paid holidays, and more.
Please note that we are only considering direct W2 candidates at this time, as we are unable to offer sponsorship.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines using advanced SQL and Python to support large-scale analytics and reporting requirements.
• Build, optimize, and maintain data workflows across Hive/Spark-based data warehouse environments, ensuring performance, accuracy, and reliability.
• Develop and manage pipeline orchestration workflows using Dataswarm, Airflow, or equivalent tools, including scheduling, backfills, and failure troubleshooting.
• Create and maintain analytics-ready datasets and data models supporting workforce measurement, staffing, capacity, and productivity reporting.
• Monitor pipeline health, implement data quality checks, and establish monitoring practices to ensure data accuracy and adherence to service-level agreements (SLAs).
• Maintain and improve legacy data pipelines, automate manual workflows, and develop self-service datasets to improve operational efficiency.
• Partner with data scientists, data architects, analysts, and operations stakeholders to translate business requirements into reliable data solutions and support reporting and dashboard development.

Internal Responsibilities

• Attend regular internal practice community meetings.
• Collaborate with your itD practice team on industry thought leadership.
• Complete client case studies and learning material (blogs, media material).
• Build out material to contribute to the Digital Transformation practice.
• Attend internal itD networking events (in person and virtual).
• Work with leadership on career fast-track opportunities.

Required Qualifications and Skills

• Strong proficiency in advanced SQL, including Presto, Trino, or Spark SQL.
• Basic to intermediate Python programming experience for production ETL/ELT development.
• Experience building, optimizing, and maintaining large-scale data pipelines across Hive/Spark-based data warehouse environments.
• Strong understanding of data warehousing fundamentals, including partitioning, incremental loads, data modeling, and query performance optimization.
• Experience with pipeline orchestration tools such as Dataswarm, Airflow, or equivalent platforms.
• Experience troubleshooting pipeline failures, managing historical backfills, implementing data quality checks, and maintaining reliable workflows.
• Understanding of data pipeline monitoring, reliability, and SLA requirements.

Preferred Qualifications and Skills

• Experience supporting dashboard backends using Unidash, Tableau, or similar reporting platforms.
• Familiarity with operations and support analytics, including workforce, capacity, staffing, and productivity metrics.
• Experience with Git, version control, code reviews, and technical documentation.
• Experience automating manual workflows and building self-service datasets.
• Exposure to data quality frameworks, anomaly detection, and SLA alerting.
• Experience working with data scientists, analysts, and business stakeholders in large-scale data environments.
• Familiarity with data engineering process certifications such as Six Sigma, CBPP, BPM, ISO 20000, ITIL, or CMMI.

Education