5 days ago
Arlington, VA, USASenior
Base Salary
$96k - $154k/yr
Responsibilities
- Develop ELT ingestion and transformation pipelines on Snowflake and dbt across bronze, silver, gold, conformed, dimensional, and product-level layers.
- Implement governed data contracts, entity definitions, keys, relationships, semantic definitions, and reusable serving structures for BI, APIs, ML, and AI.
- Migrate legacy analytics workflows such as Alteryx to dbt and Snowflake, including parity testing and legacy asset retirement support.
- Implement dbt tests, source freshness checks, reconciliation queries, validation, and pipeline observability as part of production data pipelines.
- Build and maintain reusable ingestion frameworks, transformation patterns, and shared serving structures.
- Use Git workflows, peer review, CI/CD, environment promotion, automated testing, and documentation.
- Tune query performance and Snowflake compute costs through profiling, warehouse sizing, query efficiency, and clustering decisions.
- Support production systems through observability, incident response, root-cause analysis, and durable corrective actions.
- Deliver work against approved designs and acceptance gates, produce verification evidence, and close validation defects.
- Collaborate with distributed internal and partner engineering teams, communicate risks and ambiguity, estimate work, and manage delivery variance.
Requirements
- At least 5 years of hands-on data engineering experience building production pipelines and warehouse models.
- Strong production experience with Snowflake, including warehouse and database objects, performance- and cost-aware SQL, role-based access concepts, tasks and streams or equivalent patterns, and production-scale loading and unloading.
- Production dbt experience with layered models, incremental models, tests, documentation, macros, shared 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.
- Experience with bronze/silver/gold or equivalent layered warehouse architecture, grain discipline, and conformed entities.
- Experience with Git, code review, CI/CD, environment promotion, and automated testing.
- Strong data quality, reconciliation, verification, written communication, and documentation practices.
- Experience migrating legacy analytics workloads such as Alteryx, SSIS, SAS, or stored-procedure estates is preferred.
- Experience in financial services, lending, banking, fintech, or regulated environments is preferred.
- Consulting or client-facing delivery experience with tight timelines and contractual acceptance criteria is preferred.
- Experience with Airflow, Dagster, CDC or ingestion tooling, streaming or near-real-time patterns, data catalogs, lineage tooling, Tableau, Sigma, semantic or BI layers, and ML/AI data needs is preferred.
- SnowPro or dbt certifications are valued.
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, life, accident, hospitalization, flexible spending, lifestyle spending, commuter, and wellness benefits.
- Company-paid maternity and parental leave, paid time off, and sick time.
- 401(k) plan through Fidelity with a 25% match on contributions up to 6% of annual salary.
- Up to $5,000 annually in tuition reimbursement, conference and career development opportunities, and travel reimbursement for work-related travel.
- Additional discount programs covering pets, cars, travel, entertainment, fitness, financial services, and lifestyle activities.
- Qualified 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.