5 months ago
Responsibilities
- Own the foundational warehouse data model, including core entities, grain, slowly changing dimensions, snapshot strategy, and staging and mart conventions.
- Define and implement standards for testing, documentation, orchestration, alerting, and data infrastructure operations.
- Design, maintain, and troubleshoot ingestion pipelines from internal and external sources using Fivetran, dbt, and Python.
- Implement data quality checks, monitoring, alerting, role-based access, and audit controls.
- Partner with the Head of Data and Analytics to evaluate the long-term data platform and lead any resulting warehouse consolidation or migration end to end.
Requirements
- 5+ years of experience in Data Engineering, including experience as the most senior data engineer on a team or workstream.
- Production experience with dbt, a cloud warehouse or lakehouse, and modern orchestration and ingestion tooling.
- Strong dimensional modeling experience, including selecting between Kimball, Inmon, or hybrid approaches and designing type-1 and type-2 slowly changing dimensions in production.
- Experience establishing documentation, testing, and alerting standards on a team that previously lacked them.
- Preferred: experience building data infrastructure under regulatory constraints at an RIA, broker-dealer, bank, or organization shaped by SOC 2 or Reg S-P.
- Preferred: experience using AI to accelerate pipeline development, modeling, and debugging while verifying results.
- Preferred: end-to-end warehouse consolidation or platform migration experience involving architectural ownership.
Benefits
- 100% employer-covered medical insurance for employees, 75% coverage for dependents, plus dental and vision coverage.
- 401(k) retirement savings program.
- Paid time off and most federal holidays.
- Comprehensive parental leave.
- Select meals covered throughout the week.
- Monthly movement stipend.
- Early exercise eligibility and professional development support.
- Salary and equity refreshes based on performance through annual compensation reviews.
- After two years, the Boomerang Program allows employees to take time away to start a company while Range holds their spot for six months; equity vesting pauses during the leave and resumes upon return.
- Based at Range’s headquarters in McLean, VA, with an in-office Monday-through-Friday schedule; relocation may be discussed.
Tech Stack
dbtPython
Categories
Data Engineering
About Range
Range builds an all-in-one wealth management platform paired with expert advisory services for high earners, covering investments, retirement, estate, tax, and insurance planning. It combines software and human advisors to simplify complex personal finance through a unified dashboard and AI-assisted workflows. Founded in 2020 and headquartered in McLean, Virginia, the company operates as a privately held financial services firm.