5 days ago
Arlington, VA, USASenior
Base Salary
$96k - $154k/yr
Responsibilities
- Develop ELT ingestion and transformation pipelines using Snowflake and dbt across layered medallion architecture zones.
- Model staging, conformed core entities, dimensional models, product-level models, and governed serving structures for BI, API, ML, and AI consumption.
- Implement data contracts, conformed entities, certified semantic definitions, dbt tests, freshness checks, reconciliation queries, validation, and pipeline observability.
- Migrate legacy analytics workflows such as Alteryx onto dbt and Snowflake, including parity testing and retirement support for legacy assets.
- Use Git workflows, peer review, CI/CD, environment promotion, documentation, automated testing, and approved platform engineering standards.
- Tune query performance and Snowflake compute costs through profiling, warehouse sizing, query efficiency, and clustering decisions.
- Support production systems through failure diagnosis, incident and root-cause analysis, and durable corrective actions.
- Deliver work against approved designs and acceptance gates, produce verification evidence, resolve defects, and collaborate with distributed internal and partner engineering teams.
- Senior Data Engineers may own complex workstreams, lead technical design, review code, mentor team members, and drive difficult migrations or production issues to closure.
Requirements
- At least 5 years of hands-on data engineering experience building production data pipelines and warehouse models.
- Senior-level candidates considered at 8+ years must demonstrate workstream-level technical leadership, design ownership, code-review responsibility, and mentoring.
- Strong hands-on Snowflake experience with warehouse and database objects, performance- and cost-aware SQL, role-based access concepts, tasks or streams, and production-scale loading and unloading.
- Production dbt experience with layered projects, incremental models, tests, documentation, macros, shared multi-developer workflows, and CI.
- Expert SQL skills including complex transformations, window functions, and performance tuning.
- Solid Python experience for ingestion utilities, API integrations, automation, and orchestration code.
- Experience with layered or medallion warehouse architecture, grain discipline, conformed entities, certified metrics, semantic definitions, or data contracts.
- Engineering fundamentals including Git, code review, CI/CD, environment promotion, and automated testing.
- Strong data quality and verification practices, including thorough testing, reconciliation, and complete developer verification evidence.
- Clear written communication for design notes, pull request descriptions, and documentation across time zones.
- Experience migrating legacy analytics workloads such as Alteryx, SSIS, SAS, stored-procedure estates, or similar, including parity testing.
- Experience in financial services, lending, banking, fintech, or another regulated environment with sensitive data classifications and audit expectations is an additional qualification.
- Consulting or client-facing delivery experience under tight timelines and contractual acceptance criteria is an additional qualification.
- Orchestration experience with Airflow, Dagster, or similar, plus CDC, ingestion tooling, streaming, or near-real-time patterns, is an additional qualification.
- Exposure to data catalogs, lineage tooling, semantic or BI layers such as Tableau or Sigma, and ML/AI data needs is an additional qualification.
- SnowPro or dbt certifications are valued but do not substitute for demonstrated delivery experience.
Benefits
- Competitive base salary range of $96,300-$154,400, plus eligibility for up to 10% annual incentive compensation.
- Medical, dental, employer-paid vision, disability, supplemental life, accident, and hospitalization insurance options.
- Flexible Spending Account, Lifestyle Spending Account, commuter benefits, and wellness programs including Calm App, UHC rewards, Real Appeal, and Quit For Life.
- Company-paid maternity and parental leave, paid time off, and sick time.
- LifeBalance membership, pet and car insurance discounts, LegalShield, and other lifestyle discounts.
- Tuition reimbursement of up to $5,000 annually, plus relevant conferences and career development opportunities through Kapitus Academy.
- Travel reimbursement for work-related travel.
- 401(k) plan managed through Fidelity with a 25% company match on contributions up to 6% of annual salary.
- Remote candidates may be considered if residing in a state where Kapitus or a subsidiary has an established physical presence.
About Kapitus
Kapitus provides financing to U.S. small businesses as both a direct lender and a marketplace that connects applicants to a network of funding partners. Its products include working-capital term loans, revenue-based financing, equipment financing, and lines of credit delivered through an online application and broker channels. Founded in 2006 and headquartered in Arlington, Virginia, Kapitus is privately held and part of InterVest Capital Partners.