Data Engineer
Job Description
Goodwin Procter LLP is seeking a Data Engineer to help power reliable analytics and reporting. This onsite role in Boston, MA focuses on building and improving data pipelines and platforms, partnering with senior data engineers and business stakeholders on data modernization, governance, and Agile delivery.
The Data Engineer will work on ETL/ELT development, data models, and orchestration and transformation processes to keep data accurate, timely, and trustworthy across source systems, warehouses, and analytics platforms.
What you will do
- Build, test, and maintain data pipelines and data models using orchestration and transformation tools to move and transform data across systems.
- Support ETL/ELT processes to ensure data is accurate, timely, and reliable, and troubleshoot data quality issues as they arise.
- Collaborate with data engineers and product owners to implement data governance practices, including testable code, proper error handling, and rerunnable jobs with monitoring/observability.
- Contribute to documentation for 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.
What you bring
- 2+ years of experience in a data engineering or related technical role.
- SQL strength, including joins, aggregations, CTEs, and window functions.
- Experience using Python for data engineering, scripting, or automation tasks.
- Hands-on experience with at least one cloud data platform such as Snowflake, Databricks, BigQuery, or Redshift.
- Understanding of core data modeling concepts, including fact tables, dimension tables, and schema design.
- Experience using Git (or similar) for source control.
- Strong problem-solving skills and attention to data accuracy and detail.
- Ability to work independently and collaboratively across teams.
- Exposure to law firm application databases such as Aderant Expert, Foundation, or iManage is a plus.
- Familiarity with ETL/ELT and transformation/orchestration tools such as dbt and Airflow.
- Familiarity with AI/LLM technologies as applied to data engineering.
- A Bachelor’s degree in Computer Science or a related field is preferred.
Tools you will work with
SQL, Python, Snowflake, Databricks, BigQuery, Redshift, Git, ETL/ELT, dbt, Airflow
Benefits
- 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
Salary: USD 92,900 - 139,500 per year (Boston). Target salary range varies by location and is commensurate with relevant experience.
Overtime: No
Location: Boston, MA (onsite)