Analytics Engineering Lead

Rent the Runway•Brooklyn, NY

2d•Hybrid

About The Position

We are seeking an Analytics Engineering Lead to take ownership of our core dbt data model, establish modeling best practices, and build the foundation of a scalable Analytics Engineering team. This role requires a strong individual contributor who is also capable of acting as a technical leader – defining architectural direction, reviewing and guiding contributions from analysts, and partnering closely with Data Engineering on ingestion, orchestration, and performance. This is a hands-on leadership role : you will assess the current model, identify areas to simplify and refactor, define a cohesive governance strategy, execute improvements directly, and build a roadmap to evolve the data model over time. As the function grows, this role will be involved in hiring and mentoring additional Analytics Engineers.

Requirements

5+ years owning dbt in production — designing model architecture, testing, documentation, enforcing standards, and reviewing PRs.
7+ years working with analytical data models and large-scale datasets in modern cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
Expert in SQL and in designing data models that support Looker explores and self-service analytics.
Comfortable working with large, high-complexity dbt model — with deep dependency graphs, layered logic, legacy components, and incremental refactoring needs.
Comfortable partnering with Data Engineering on ingestion, orchestration (Prefect), CI/CD, and data quality frameworks.
Experience defining and maintaining Git-based development workflows (branching strategy, PR review processes, testing gates, and controlled release/promotion).
Able to simplify complex data environments and make scalable architecture decisions.
Strong communicator who can influence across technical and non-technical stakeholders.
Thrives in high-ownership, fast-paced, iterative environments.

Nice To Haves

Looker / LookML semantic modeling experience.
Experience with event analytics and subscription lifecycle data (e.g., Heap , Mixpanel, Segment).
Experience working in a fast-growing environment where dbt models required refactoring for scale and maintainability.
Experience leading or contributing to a data warehouse migration .
Python for automation, testing, or internal tooling.

Responsibilities

Own the core dbt model: assess current architecture, identify bottlenecks, simplify complexity, and improve maintainability and performance.
Define the technical strategy for the Analytics Engineering function, establishing modeling standards, version control norms, documentation frameworks, and code review practices.
Review PRs from BI Analysts and guide contributions to ensure accuracy, performance, and adherence to modeling conventions.
Serve as the primary bridge between BI (analytics-facing) and Data Engineering (ingestion, orchestration, infrastructure).
Partner with Data Engineering to improve pipeline reliability, testing coverage, data freshness, and orchestration flows.
Lead and execute large-scale refactors , including preparation for and/or execution of the migration from Snowflake to BigQuery.
Improve and enforce data governanc e, including data quality checks, model ownership boundaries, and documentation.
Over time, recruit, onboard, and mentor additional Analytics Engineers to scale the function.
Operate with high ownership and autonomy , driving both strategy and execution.

Benefits

Paid Time Off including vacation, paid bereavement, and family sick leave - every employee needs time to take care of themselves and their family.
Universal Paid Parental Leave for both parents + flexible return to work program - because we know your newest family member(s) deserve your undivided attention.
Paid Sabbatical after 5 years of continuous service - Unplug, recharge, and have some fun!
Exclusive employee subscription and rental discounts - to ensure you experience the magic of renting the runway (and give us valued feedback!).
Comprehensive health, vision, dental, FSA and dependent care from day 1 of employment - Your health comes first and we’ve got you covered.
401k match - an investment in your future.
Company wide events and outings - our team spirit is no joke - we know how to have fun!
Hybrid work - individual contributors on our tech team follow a sprint schedule and generally alternate fully remote weeks and working remotely two days per week, in accordance with Company policies.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume