Analytics Engineer

Analytics Engineer III

What you will achieve

You will take ownership of how Addgene's data is structured, documented, and maintained, and establish the standards and practices that define how the organization works with data. Your work will build a data warehouse that earns trust by deploying engineering best practices where they are currently missing, validating the datasets that drive decisions, and enabling anyone on the team to understand how any result was produced.

Director of Data Science

October 2026

$117,000 - $120,000 annually + our amazing benefits (see below)!

This is a hybrid position that requires at least two days a week onsite at our Watertown, Massachusetts Headquarters. Our beautiful office space has free, ample parking with a complimentary shuttle from Harvard Square and is on multiple bus lines, with the cost of public transit covered by Addgene for those onsite at least twice a week.

Our data team functions as an internal core facility, serving partners across scientific, commercial, and business development functions. We are looking for an Analytics Engineer who will take ownership of the infrastructure that powers our data, bringing engineering discipline, sound judgment and responsibility for the systems they build and maintain.

This is a role for someone who finds satisfaction in making messy things reliable. You will inherit a complex data environment, and your job will be to understand it thoroughly, and implement deliberate improvements. The work is technical at its core, but requires deep analytical thinking that catches problems before they surface and ability to push tasks forward to completion.

To succeed in this role, your work will span three areas:

• Take end-to-end ownership of our Big Query data warehouse, including organization, documentation, and maintenance
• Apply software engineering best practices for data transformation and modeling, bringing consistency and version control to how tables and views are built and updated
• Assess internal data sources not yet represented in the warehouse and design pipelines to ingest, validate, and integrate them
• Build and support reliable datasets as the foundation for dashboards and reporting
• Manage tasks, assess priority and scope, and set realistic expectations

• Create and maintain data quality checks that catch problems before they reach downstream users
• Develop and operationalize a shared data lexicon to establish consistent definitions that can be applied across tables, dashboards, and reports
• Expand instructions for Big Query tables and views to improve the reliability and usefulness of AI-assisted data access
• Write reliable, readable Python for wrangling, transformation, and reporting tasks

• Build and maintain robust data pipelines that bring critical internal data sources into the warehouse reliably and on schedule
• Improve the coverage and resilience of existing pipelines, reducing fragility and increasing the value of our data
• Contribute to code review, applying and upholding engineering standards across the team's codebase
• Identify opportunities to automate manual or repetitive processes, freeing team capacity for higher-value work

• 5+ years of experience in an analytics engineering role
• A Master's degree in Computer Science or a related field is preferred; a Bachelor's degree with equivalent professional experience is also acceptable
• Hands-on experience owning and managing a data warehouse, such as Big Query or comparable platform, with track record of not just maintaining what exists, but making decisions about how it should be structured and rationale behind it
• Experience with dbt for data transformation and warehouse management is highly preferred
• Strong proficiency with SQL, including complex queries, joins and aggregations
• Proficient with Python for data engineering tasks (pipeline development, scripting, automation)
• Experience with data validation, quality assurance, and documentation practices
• Familiarity with AI tools or agents in data engineering context
• Interest in the life sciences and a willingness to develop working knowledge of the science behind the data related to your work
• Demonstrated ability to identify problems proactively, and follow through without close supervision
• Experience in a small, cross-functional team where priorities shift and individual…