Remote Data Engineer: ETL, SQL & Warehousing

itD; San Francisco (CA); Remote; USD 83,000 - 124,000; Full time

Benefits offered by this job

Comprehensive medical benefits

401(k) plan

Paid holidays

More

Job summary

itD is seeking an experienced Data Engineer to build and modify high-complexity data pipelines, monitoring, and alerting systems for a legal-focused infrastructure team. The ideal candidate will bring deep expertise in SQL, Python, ETL/data pipelines, and data warehousing, with a track record of leading cross-functional data engineering initiatives from planning through delivery.

Remote with California preference; occasional onsite in San Francisco is welcome. Contract: 3 months.

Qualifications

• 5–7+ years of experience in data engineering or a closely related field.
• Expert-level SQL experience with relational or distributed query engines (Presto, PostgreSQL, MySQL).
• Expert-level Python programming experience.
• Expert-level experience building and managing ETL/data pipelines using Airflow or comparable technologies.
• Demonstrated experience leading data engineering efforts on large, cross-functional projects.
• Strong understanding of data privacy and security considerations in data engineering environments.

Responsibilities

• Build and modify high-complexity ETL and data pipelines to extract, transform, and process data from large-scale datasets.
• Develop and maintain monitoring and alerting systems to identify data, infrastructure, and workflow issues.
• Design data warehousing solutions and optimize queries and pipelines for large-scale data processing.
• Collaborate with attorneys, data scientists, engineers, and stakeholders to understand data requirements, sources, dependencies, and timelines.
• Lead end-to-end data engineering initiatives across cross-functional teams, including planning, documentation, stakeholder coordination, system design, and execution.
• Identify potential data and system issues early and implement reliable improvements.
• Communicate technical concepts and project status clearly to technical and non-technical audiences.

Skills

SQL

Python

ETL pipelines

Data warehousing

Education

Bachelor's degree

Job description

itD is seeking an experienced Data Engineer to build and modify high-complexity data pipelines, monitoring, and alerting systems for a legal-focused infrastructure team. The ideal candidate will bring deep expertise in SQL, Python, ETL/data pipelines, and data warehousing, with a track record of leading cross-functional data engineering initiatives from planning through delivery.

Remote with California preference; occasional onsite in San Francisco is welcome. Contract: 3 months.