Job description

ABOUT ROCKET MONEY 🔮 Rocket Money’s mission is to empower people to live their best financial lives. Rocket Money offers members a unique understanding of their finances and a suite of valuable services that save them time and money – ultimately giving them a leg up on their financial journey. ABOUT THE TEAM 🤝 The Analytics Engineering team's mission is to make data consistent, trustworthy, and easy to use. We build the dimensional models that power business decisions, and we own the integrity of the data those decisions rest on. We work in a semi-embedded structure: Analytics Engineers sit close to the Data Analyst teams they support while remaining part of a central Analytics Engineering practice. Day to day, that means translating business questions into technical requirements, modeling ingested source data into shapes the business can actually use, and partnering with engineering teams on the upstream data we depend on. We're looking for a Senior Analytics Engineer to help shape that architecture as it grows. You'll build and iterate on our star schema, surfacing models that Data Analysts and stakeholders across the business can self-serve against with confidence. Done well, this work raises the data literacy of the entire company — and we take that seriously. IN THIS ROLE, YOU'LL 🤹 Be a trusted builder, architect, and consultant on the analytics data we surface to our stakeholders. You'll learn the intricacies of our source data, how we transform it, how we monitor for integrity, and continue to move the needle on the partnership needed to maximize value for the business. You will: Design and build dimensional models that scale (we use dbt + BigQuery) Translate ambiguous business questions into dimensions, facts, and grain decisions that hold up as the business changes Make tradeoffs between normalization, performance, and usability, and document the reasoning behind them Reduce technical debt in the dbt project: model layering, naming and testing standards, macro reuse, and incremental strategy Own data quality and monitoring for the models you build Define what "correct" means for each model and instrument data quality checks to monitor it Build and improve the alerting and triage process so data issues are caught proactively Lead root-cause investigations on data discrepancies across the pipeline, from source event or system of record through to the analytics layer Partner with Data Engineering and product engineering teams on upstream contracts and instrumentation quality Be the connective tissue between source data and business definitions Support technical definition of core business measurement and drive alignment when stakeholders disagree Partner with Data Analysts and BI to ensure models enable stakeholder self-service analysis Translate business needs into technical requirements and prioritize work against them Raise the bar on the team through code review, design review, and documentation ABOUT YOU 🦄 5+ years of experience in analytics engineering, data engineering, or related roles. Deep data modeling expertise. You have designed dimensional models from scratch and integrated them into a cohesive analytics architecture to serve your stakeholders. You understand grain, SCD types, and fact table design tradeoffs. You can handle complex modeling scenarios, such as conforming dimensions across business use cases, modeling many-to-many relationships, handling late-arriving and restated data, and keeping models usable as the source systems evolve. You treat data quality as a design problem, not a cleanup task. You have built testing and monitoring into pipelines, defined SLAs or expectations with data owners, and managed the on-call/triage side of keeping data trustworthy. You judge your work by its usability to your stakeholders over the long-term, not just by speed of delivery, underlying architecture elegance, or immediate use case. Production dbt experience. You understand model materialization strategies, testing, macros, and how to keep a growing project maintainable. 2+ years of experience with BI tools (Looker preferred) and an understanding of how modeling choices shape what's possible in the analytics layer. Strong cross-functional communication skills and the ability to influence stakeholder & business decisions. Strong problem decomposition: you can understand the underlying problem in requests that you receive and align them with our modeling roadmap and architecture. Bonus points if: You have worked with finance or financial services data — transactions, subscriptions, revenue recognition, ledgers, or reconciliation against a system of record. You have experience with our stack (BigQuery, dbt Cloud, Looker, Amplitude, DeepNote) You have experience with data governance, lineage, or catalog tooling You're familiar with Agile process & sprint cycles You have experience in mobile app or product analytics WE OFFER 💫 Health, Dental & Vision Plans Life Insurance Long/Short Term Disability Competitive Pay 401k Matching Team Member Stock Purchasing Program (TMSPP) Learning & Development Opportunities Tuition Reimbursement Unlimited PTO Daily Lunch, Snacks & Coffee (in-office only) Commuter benefits (in-office only) Additional information: Salary range of $150,000 - $190,000 + bonus + benefits. Base pay offered may vary depending on job-related knowledge, skills, and experience. Rocket Money, Inc. is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability. Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Requirements

Must-haves

Design and build dimensional models that scale (we use dbt + BigQuery)
Translate ambiguous business questions into dimensions, facts, and grain decisions that hold up as the business changes
Make tradeoffs between normalization, performance, and usability, and document the reasoning behind them
Reduce technical debt in the dbt project: model layering, naming and testing standards, macro reuse, and incremental strategy
Own data quality and monitoring for the models you build
Define what "correct" means for each model and instrument data quality checks to monitor it
Build and improve the alerting and triage process so data issues are caught proactively
Lead root-cause investigations on data discrepancies across the pipeline, from source event or system of record through to the analytics layer
Partner with Data Engineering and product engineering teams on upstream contracts and instrumentation quality
Be the connective tissue between source data and business definitions
Support technical definition of core business measurement and drive alignment when stakeholders disagree
Partner with Data Analysts and BI to ensure models enable stakeholder self-service analysis
Translate business needs into technical requirements and prioritize work against them
Raise the bar on the team through code review, design review, and documentation
5+ years of experience in analytics engineering, data engineering, or related roles.
You judge your work by its usability to your stakeholders over the long-term, not just by speed of delivery, underlying architecture elegance, or immediate use case.
Production dbt experience. You understand model materialization strategies, testing, macros, and how to keep a growing project maintainable.
Strong cross-functional communication skills and the ability to influence stakeholder & business decisions.
Strong problem decomposition: you can understand the underlying problem in requests that you receive and align them with our modeling roadmap and architecture.
You have worked with finance or financial services data — transactions, subscriptions, revenue recognition, ledgers, or reconciliation against a system of record.
You have experience with our stack (BigQuery, dbt Cloud, Looker, Amplitude, DeepNote)
You have experience with data governance, lineage, or catalog tooling
You're familiar with Agile process & sprint cycles

Nice-to-haves

2+ years of experience with BI tools (Looker preferred) and an understanding of how modeling choices shape what's possible in the analytics layer.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

restagile

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto