Skip to content

Senior Data Engineer

McLean, VAOnsite5+ YOE
Summary

Senior Data Engineer to own foundational data model, set standards for testing/documentation/alerting, build ingestion pipelines with dbt/Fivetran/Python, and architect governance for a regulated wealth management platform.

About the role

What you’ll do with us

  • Own the foundational data model. Design how our core entities look and are structured in the warehouse. Make the calls on grain, slowly changing dimensions, snapshot strategy, and the conventions our staging and mart layers are built on.
  • Set the standards. Define how we do testing, documentation, orchestration, and alerting across all our data infrastructure and bring our existing warehouses up to that bar.
  • Build and operate the ingestion layer. Design and maintain pipelines that move data reliably from internal and external sources into the warehouse, using Fivetran, dbt and Python where each fits best. Implement the data quality checks, alerting, and troubleshooting tools that let us catch issues before stakeholders do.
  • Architect for governance. Build role-based access, and audit controls into the foundation so that governance scales with the platform instead of being retrofitted later.
  • Help shape the platform decision. Partner with our Head of Data and Analytics on the evaluation and own the migration end-to-end once the decision is made.

What we're looking for

  • 5+ years of experience in Data Engineering, including time as the most senior data engineer on a team or workstream.
  • Production experience with a modern data toolset including dbt, a cloud warehouse or lakehouse, and modern orchestration and ingestion tooling.
  • Strong dimensional modeling fundamentals — defend a choice between Kimball, Inmon, or a hybrid based on the problem in front of you, and designed type-1/type-2 SCDs in production.
  • Track record of setting standards on documentation, testing and alerting on a team that didn't have them.

What will set you apart

  • Built data infrastructure under real regulatory constraints at an RIA, broker-dealer, bank or anywhere SOC 2 / Reg S-P / shaped what you built and how.
  • Leverage AI as a force multiplier in your own work. Developed real instincts for when to lean on it, when to verify, and where it actually accelerates pipeline development, modeling, and debugging.
  • Done a warehouse consolidation or platform migration end-to-end where you made the architectural calls and lived with the consequences.

Benefits

  • Health & Wellness: 100% employer-covered medical insurance for employees (75% for dependents), plus dental and vision coverage
  • 401(k): Retirement savings program to support your future
  • Paid Time Off: Dedicated time to reset and recharge plus most federal holidays
  • Parental Leave: Comprehensive leave policy for growing families
  • Meals: Select meals covered throughout the week
  • Fitness: Monthly movement stipend
  • Equity & Career Growth: Early exercise eligibility and a strong focus on professional development
  • Annual Compensation Reviews: Salary and equity refreshes based on performance
  • Boomerang Program: After two years at Range, you can take time away to start your own company. We’ll hold your spot for 6 months - and pause your equity vesting, which resumes if you return
Skills
dbtPythonFivetranDimensional ModelingKimballInmonSCD Type 1SCD Type 2Data GovernanceData QualityOrchestrationCloud Data WarehouseLakehouse