5 days ago
Arlington, VA, USASenior
Base Salary
$96k - $154k/yr
Responsibilities
- Develop ELT ingestion and transformation pipelines on Snowflake and dbt across layered medallion architecture zones.
- Model staging, conformed core entities, dimensional models, and product-level serving structures using approved grain, key, naming, and semantic standards.
- Implement data contracts, governed entity definitions, certified semantic definitions, data-quality tests, source-freshness checks, reconciliations, validation queries, and pipeline observability.
- Migrate legacy analytics workflows such as Alteryx to Snowflake and dbt, including parity testing and legacy-asset retirement support.
- Contribute to reusable ingestion frameworks, transformation patterns, and common serving structures rather than one-off solutions.
- Use Git workflows, peer review, CI/CD, environment promotion, automated testing, and documentation to deliver operable production code.
- Profile and tune query performance, Snowflake compute cost, warehouse sizing, and clustering choices.
- Support production systems through observability, incident response, root-cause analysis, and durable corrective actions.
- Deliver work against approved designs and acceptance criteria, produce developer-verification evidence, and close validation defects promptly.
- Collaborate with distributed internal and consulting-partner engineers across onshore and offshore locations, communicating clearly across time zones.
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 production experience with Snowflake, including 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 models, incremental models, tests, documentation, macros, shared multi-developer projects, 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 bronze/silver/gold or equivalent layered warehouse architecture, including grain discipline and conformed entities.
- Engineering fundamentals including Git, code review, CI/CD, environment promotion, and automated testing.
- A strong data-quality and verification mindset, including thorough testing, reconciliation, and complete verification evidence.
- Clear written communication for design notes, pull-request descriptions, and technical documentation.
- Preferred experience migrating Alteryx, SSIS, SAS, stored-procedure estates, or similar legacy analytics workloads to modern cloud platforms with parity testing.
- Preferred experience in financial services, lending, banking, fintech, or regulated environments involving sensitive data classifications and audit expectations.
- Consulting or client-facing delivery experience with tight timelines and contractual acceptance criteria is preferred.
- Orchestration experience with Airflow, Dagster, or similar, plus CDC, ingestion tooling, streaming, or near-real-time patterns is preferred.
- Exposure to data catalogs, lineage tooling, semantic or BI layers such as Tableau or Sigma, and ML/AI data needs is preferred.
- SnowPro or dbt certifications are valued but do not substitute for demonstrated delivery experience.
Benefits
- Competitive base salary range of $96,300-$154,400 annually, plus eligibility for up to 10% annual incentive compensation.
- Medical, dental, employer-paid vision, disability, supplemental life, accident, and hospitalization insurance options, including UnitedHealthcare and Mutual of Omaha offerings.
- Flexible Spending Account, Lifestyle Spending Account, commuter benefits, and wellness and discount programs including LifeBalance and Plum Benefits.
- Company-paid maternity and parental leave, paid time off, and sick time.
- Tuition reimbursement of up to $5,000 annually, conference and career-development opportunities, and 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 they reside in states 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.