Data Engineer

TalentAlly; Washington (District of Columbia); On-site; USD 93,000 - 160,000; Full time

Benefits offered by this job

Health, dental & vision insurance

Retirement plan

Paid vacation & holidays

Professional development

Job summary

Goodwin is seeking a Data Engineer to join the Global Operations Team. You will build and optimize data pipelines and models powering analytics across the firm, collaborating with data engineers and product owners on governance and scalable solutions.

You should have 2+ years in data engineering, strong SQL skills, Python experience, and hands-on with Snowflake/Databricks/BigQuery or Redshift. Familiarity with legal databases and ETL tools is a plus, with Agile collaboration as a core practice.

Qualifications

• Bachelor's degree in Computer Science or related field preferred.
• 2+ years of experience in data engineering or related role.
• Strong SQL skills, including complex joins and window functions.
• Experience with Python for data engineering, scripting, or automation.
• Hands-on experience with at least one cloud data platform (Snowflake/Databricks/BigQuery/Redshift).
• Understanding of core data modeling concepts (fact/dimension tables).
• Experience using Git for source control.
• Exposure to law firm databases such as Aderant Expert, Foundation, or iManage is a plus.
• Familiarity with ETL/ELT tools like dbt or Airflow.

Responsibilities

• Build, test, and maintain data pipelines and data models across source systems and analytics platforms.
• Support ETL/ELT processes to ensure data accuracy and timeliness; troubleshoot data issues.
• Collaborate to implement data governance with testable code and monitorable jobs.
• Document data pipelines, schemas, and processes for team knowledge sharing.
• Participate in Agile ceremonies and use Git for code changes.

Skills

SQL

Python

Data modeling

Problem-solving

Independent work

Collaborative work

Education

Bachelor's degree in Computer Science

Tools

Snowflake

Databricks

BigQuery

Redshift

dbt

Airflow

Git

Aderant Expert/Foundation/iManage

Job description

Join Goodwin’s Global Operations Team, and make a real impact on a global scale. At Goodwin, we work with some of the world’s most successful and innovative investors, entrepreneurs and disruptors in the life sciences, private equity, real estate, technology and financial industries, and where they converge. As part of the Global Operations Team – all business professionals at the firm – you’ll collaborate with colleagues from varied backgrounds and experiences, fostering an environment where cross‑functional learning, networking, and collaboration are at the core of what we do.Here, we’re not just supporting a law firm; we’re partnering with attorneys and clients to deliver cutting‑edge solutions in high‑stakes litigation and dispute resolution, world‑class regulatory compliance and advisory services, and complex transactions. Our commitment to integrity, ingenuity, agility, and ambition drives us, and we’re proud to have been recognised as the “Best Business Team” by The American Lawyer. This is your opportunity to grow professionally in a dynamic, global environment, surrounded by forward‑thinking peers.As part of a growing data function, the Data Engineer will help build, maintain, and improve the data pipelines and platforms that power the Firm's analytics and reporting. This role works closely with senior data engineers and business stakeholders to support the Firm's ongoing data modernization efforts.

What You Will Do:

• Build, test, and maintain data pipelines and data models using orchestration and transformation tools to move and transform data across source systems, warehouses, and analytics platforms.
• Support the development and maintenance of ETL/ELT processes, ensuring data is accurate, timely, and reliable; troubleshoot and resolve data quality issues as they arise.
• Collaborate with data engineers and product owners to implement data governance practices: testable code, proper error handling, and rerunnable jobs with monitoring/observability in place.
• Contribute to documentation of data pipelines, schemas, and processes to support team knowledge‑sharing.
• Participate in Agile ceremonies (sprint planning, stand‑ups, retros) and use Git for all code changes.

Who You Are:

• Bachelor's degree in Computer Science or a related field is preferred.
• 2+ years of experience in a data engineering or related technical role.
• Strong SQL skills, including joins, aggregations, CTEs, and window functions.
• Experience with Python for data engineering, scripting, or automation tasks.
• Hands‑on experience with at least one cloud data platform (e.g., Snowflake, Databricks, BigQuery, or Redshift).
• Understanding of core data modeling concepts (fact tables, dimension tables, schema design).
• Experience using Git or similar tools for source control.
• Strong problem‑solving skills and attention to data accuracy and detail.
• Ability to work both independently and collaboratively across teams.
• Exposure to law firm application databases such as Aderant Expert, Foundation, or iManage a plus.
• Familiarity with ETL/ELT tools such as dbt, Airflow or similar transformation /orchestration frameworks.
• Familiarity with AI/LLM technologies as applied to data engineering.

Benefits and More

• Health, dental, and vision insurance
• Life and disability insurance
• Retirement & Savings Plan
• Emergency back‑up child and adult care
• Paid vacation, sick time off, and holidays
• Professional development and career advancement opportunities
• Employee recognition and reward programs
• Employee wellness and assistance programs
• Employee discounts and perks

This position is eligible for overtime: No

The target salary range for this position varies by location and is commensurate with relevant experience: Boston $92,900 - $139,500 | Los Angeles $99,900 - $149,900 | New York $99,900 - $149,900 | Orange County $99,900 - $149,900 | Philadelphia $92,900 - $139,500 | San Diego $99,900 - $149,900 | San Francisco $106,800 - $160,300 | Santa Monica $99,900 - $149,900