Data Engineer IV - Legal Data at SGS Consulting Remote

SGS Consulting; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

Itlearn360 is seeking a skilled Data Engineer IV to work remotely. In this role, you will build ETL pipelines, collaborate with attorneys, and work cross-functionally to launch new systems.

The ideal candidate has 5-6 years of experience in SQL and Python, with a strong preference for candidates on the West Coast, although occasional office visits are not mandatory.

Qualifications

• At least 5-6 years of experience with SQL and Python-based pipeline development.

Responsibilities

• Building ETL pipelines for data extraction and transformation.
• Collaborating with attorneys and data scientists for data requirements.
• Working cross-functionally to launch new systems and products.

Skills

SQL

Python

Experience building ETL pipelines

Volunteer work or internship with a law firm

Experience with remediating data loss

Job description

Data Engineer IV – Legal Data job at SGS Consulting. Remote.

Job Responsibilities

• Building ETL pipelines: Engineers are responsible for scheduling and querying massive tables, ensuring efficient data extraction and transformation.
• Collaborating with attorneys: Work closely with attorneys and Data Scientists to understand what data is needed, where it is located, when it is required, and which tables are relevant.
• Cross‑functional collaboration: Collaborate with various XFN teams to launch new systems and products. Responsibilities include preparing documentation, coordinating with multiple stakeholders, developing a plan for system building, identifying collaborators, and ensuring successful execution.
• Beyond YOE, due to the technical complexity of the role, we'd ideally find someone with experience working on data warehousing and building (and leading end-to-end projects to build) high‑complexity monitoring and alerting systems.
• We're a very XFN‑heavy team, so someone who is highly communicative, collaborative, comfortable navigating ambiguity, tenacious in finding answers, and cognizant of privacy/security would do very well in this role.
• Strong preference for someone based on the west coast, with slight preference for someone who could occasionally come into the SF office, but that's not required.
• Tenacity and curiosity.

Skills

• SQL.
• Python.
• Experience building ETL pipelines.
• Volunteer work or internship with a law firm or experience in privacy.
• Experience with remediating data loss.

Education/Experience

• We're looking for someone senior, with at least 5‑6 years of experience with SQL and Python‑based pipeline development (DataSwarm, Airflow, etc.).