Data Engineer
3d Design Tools
Apache Airflow
Aws Data Warehouse
Big Data
Bigdata
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Lakehouse
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Science Ops
Data Transforms
Data Warehouse
Data Warehousing
Database
Databases
Databricks
ETL
Etl/elt
Google Cloud Bigquery
Informatica
Information Technology (IT)
Programming Languages
Rendering Engines
Snowflake
Software Development
SQL
Job Description
The Data Engineer role at Goodwin Procter LLP focuses on building and improving data pipelines and platforms that support the Firm’s analytics and reporting needs. The position works with senior data engineers and business stakeholders on ETL/ELT development, governance practices, documentation, and Agile delivery.
Key Responsibilities
- 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 ETL/ELT process development and maintenance, maintaining data that 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, including testable code, appropriate error handling, and rerunnable jobs with monitoring and observability.
- Contribute to documentation for data pipelines, schemas, and processes to support team knowledge sharing.
- Participate in Agile ceremonies such as sprint planning, stand-ups, and retros, and use Git for all code changes.
Required Qualifications
- Bachelor’s degree in Computer Science or a related field (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, 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 tools 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 tools such as dbt, Airflow, or similar transformation and orchestration frameworks.
- Familiarity with AI/LLM technologies as applied to data engineering.
Technologies
- SQL
- Python
- Snowflake
- Databricks
- BigQuery
- Redshift
- Git
- ETL/ELT
- dbt
- Airflow
Location and Schedule
Boston, MA (onsite).
Overtime eligibility: No.
Compensation
Target salary range (varies by location): Commensurate with relevant experience.
- Boston: USD 92,900 - 139,500 per year
- Los Angeles: USD 99,900 - 149,900 per year
- New York: USD 99,900 - 149,900 per year
- Orange County: USD 99,900 - 149,900 per year
- Philadelphia: USD 92,900 - 139,500 per year
- San Diego: USD 99,900 - 149,900 per year
- San Francisco: USD 106,800 - 160,300 per year
- Santa Monica: USD 99,900 - 149,900 per year
Benefits
- Health, dental, and vision insurance
- Life and disability insurance
- Retirement and 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