Data Warehouse Lead & Analytics Engineer

Addgene USA; Watertown (MA); Hybrid; USD 117,000 - 120,000; Full time

Benefits offered by this job

Health benefits

PTO 22 days

401(k) match

Professional development stipend

Lifestyle stipend

Transit coverage

Onsite wellness

Pet insurance

Financial planning

Job summary

Addgene USA is seeking an Analytics Engineer III to own and evolve our data warehouse, ensuring clean, well-documented datasets for trustworthy decision-making. You will build pipelines, validate data quality, and apply engineering best practices across the data stack.

This role sits in a hybrid office setting in Watertown, MA, reporting to the Director of Data Science. The ideal candidate has 5+ years in analytics engineering, strong BigQuery, SQL, Python, and dbt experience, and is motivated

Qualifications

• 5+ years in an analytics engineering role with data warehouse ownership.
• Experience with BigQuery or similar platform; strong SQL.
• Proficient in Python for ETL and data pipelines; familiar with dbt.

Responsibilities

• Own and maintain the data warehouse infrastructure and data models.
• Develop and enforce data quality checks and documentation standards.
• Build and maintain robust data pipelines to feed dashboards and reports.
• Contribute to code reviews and uphold engineering standards.
• Identify and automate repetitive data tasks to improve efficiency.

Skills

BigQuery

SQL

Python

dbt

Data quality

Data validation

Data warehousing

Problem solving

Team collaboration

Proactive initiative

Education

Master's degree in Computer Science or related field

Bachelor's degree with equivalent experience

Tools

BigQuery

dbt

Python

Git

Airflow

Job description

Addgene USA is seeking an Analytics Engineer III to own and evolve our data warehouse, ensuring clean, well-documented datasets for trustworthy decision-making. You will build pipelines, validate data quality, and apply engineering best practices across the data stack.

This role sits in a hybrid office setting in Watertown, MA, reporting to the Director of Data Science. The ideal candidate has 5+ years in analytics engineering, strong BigQuery, SQL, Python, and dbt experience, and is motivated