This position does not offer visa sponsorship now or in the future.

iCapital is seeking an exceptional Data Engineer to help scale the data foundations that power the business. This individual will design, build, and optimize the data pipelines and infrastructure that enable data to be a strategic asset across the organization. This role is highly collaborative and will partner with the Product, Engineering, Analytics teams and business stakeholders to quickly understand evolving challenges and deliver scalable, maintainable, and high‑quality solutions.

Data sits at the core of iCapital’s operations. The firm relies on clean, reliable, well‑structured data to drive decision‑making, enhance client experiences, and support a rapidly growing product suite. This individual will be responsible for moving and transforming data and developing a deep understanding of the business context behind it and help teams act on insights.

Responsibilities

• Develop and automate large scale, high-performance data platform pipelines and infrastructure to drive iCapital business growth and enable data-driven decision making.
• Design and develop reusable components and frameworks for ingestion, cleansing, and data quality.
• Streamline the ingestion of raw data from various sources into our Data Lake and Data Warehouse.
• Design data models for optimal storage and retrieval that represent the tangible business domains across iCapital’s ecosystem.
• Coordinate closely with the Operations, Sales, and Product Development teams daily to push iCapital’s FinTech strategy and improve the overall profitability of the business.

Qualifications

• 6-10 years of professional experience in a data engineering or data-driven software engineering role
• Exceptional Python and SQL skills
• Extensive experience with orchestration frameworks (Prefect, Airflow, Dagster, etc.)
• Deep understanding of OLAP (Snowflake, Databricks) and OLTP (PostgreSQL, MongoDB) databases and ELT frameworks (dbt, dlthub)
• Experience developing and deploying code to Cloud environments (AWS, GCP, Azure)
• Possess a strong grasp of object-oriented and functional programming and an ability to write easy-to-scale, high-quality code
• Experience leveraging stream processing frameworks (Kafka, Flink, Spark)
• Knowledge of infrastructure-as-code frameworks (terraform or cloud formation)
• Detail-oriented and able to multitask and work in a fast-paced environment
• Able to work independently while also being a strong team player
• Excellent written and verbal communication
• Passionate about learning and mastering cutting-edge technologies
• Professional experience with JVM based languages such as Scala, Java, and Kotlin is preferred
• Knowledge of financial markets and financial instruments is preferred

Benefits

The base salary range for this role is $100,000 to $135,000.  iCapital offers a compensation package which includes salary, equity for all full-time employees, and an annual performance bonus. Employees also receive a comprehensive benefits package that includes an employer matched retirement plan, generously subsidized healthcare with 100% employer paid dental, vision, telemedicine, and virtual mental health counseling, parental leave, and unlimited paid time off (PTO).

We believe the best ideas and innovation happen when we are together. Employees in this role will work in the office Monday-Thursday, with the flexibility to work remotely on Friday.

For additional information on iCapital, please visit https://www.icapitalnetwork.com/about-us  Twitter: @icapitalnetwork | LinkedIn: https://www.linkedin.com/company/icapital-network-inc | Awards Disclaimer: https://www.icapitalnetwork.com/about-us/recognition/

iCapital is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

We Are Route

When shoppers hit "buy," a great customer experience doesn’t end, it’s just getting started. For too long, everything after checkout has been the weakest link in ecommerce: confusing tracking, lost or damaged packages, clunky returns, and missed opportunities to turn first-time buyers into lifelong fans. That's why we built Route.

Our mission is simple: we create shopper confidence that fuels brand growth. Route is the leading post-purchase platform for modern ecommerce, trusted by thousands of brands and protecting more than $20 billion in gross merchandise value to date. From package protection and industry-leading order tracking to returns and exchanges, cash back loyalty, and engaging product recommendations, Route brings every moment after checkout into one powerful platform, empowering shoppers with visibility and peace of mind while giving merchants loyalty that lasts well beyond the first sale.

Since launching in 2018, Route has raised over $250 million from leading investors including Craft Ventures, Hedosophia, and Hanaco Ventures, and has grown into a complete post-purchase ecosystem loved by millions of shoppers and the brands they buy from. Throughout that growth, we've stayed committed to building innovative products that empower our customers and to fostering a people-first, values-driven culture that makes Route a place where great work and great people thrive.

We're looking for talented people across the ecommerce space to join us on the next chapter of this adventure. Don't just take our word for it, Discover what life at Route has to offer.

The team

The Data Engineering team (DAENGR) is the backbone of Route's data ecosystem. We are primarily responsible for the data infrastructure, quality, standards, frameworks, and architecture that power enterprise data, reporting, and analytics across the entire organization. We solve problems of poor data quality and limited accessibility, simplify reporting for teams outside of data engineering, and monitor the uptime, security, and consistency of the majority of Route's data lifecycle. We collaborate closely with every corner of the business to make data a first-class citizen at Route.

The opportunity

This is a rare chance to shape the data destiny of a young, fast-growing company at an inflection point. As Route moves into the AI era of data infrastructure, you'll have the opportunity to leave a lasting legacy — exploring new systems and designs, and building tools that genuinely change how Route operates day to day. We are actively migrating from legacy Snowflake pipelines into a modern Databricks-first architecture, building out an Enterprise Data Warehouse (EDW) with a normalized 3NF core, and laying the groundwork for AI-ready data systems. You'll be co-authoring the next chapter of data at Route.

The ideal candidate is organized and articulate in their thinking, able to adapt and compromise to keep pace with business needs, but firm enough to push back when security and data integrity are at stake. We aim to help Route improve profitability, cash flow, and return on investment by providing accurate data to make informed decisions and process improvements.

What you’ll do

• Build and maintain ELT pipelines that ingest data from systems.
• Co-own the mapping and migration of source data into the new 3NF EDW, ensuring data integrity, reducing redundancy, and maintaining automated unit and data tests.
• Develop data observability processes and monitoring dashboards to track pipeline health, freshness, and data quality across Databricks.
• Build new data and AI-powered tooling to improve the productivity of the data engineering team and broaden self-service data access for Route employees and external partners.
• Help harden the Integration Pipeline by automating deployment of shared staging and production infrastructure for new pipelines and managing dependency updates for dbt and CI templates.
• Support the full migration from Snowflake to Databricks, targeting completion by end of Q2 2027, including reporting services and ingest/egress jobs.
• Coordinate with engineering, analytics, product, and business teams to define and prioritize data requirements and ensure end-to-end data lifecycle coverage for existing and new products.
• Champion data democratization, help establish a company-wide data retention policy, and expand the foundation for a self-service Silver layer (EDW) that serves as a single source of truth.

What we’re looking for

• 5+ years of formal, professional data engineering experience
• 4+ years of SQL, fluency in complex transformations, window functions, query optimization
• 3+ years of python, data pipeline development, scripting, testing, and package management (Poetry)
• 2+ years of experience with AWS (e.g. - S3, RDS, DMS, DynamoDB) across data-related services
• 1+ years of experience using Databricks, our primary development platform for this role
• Experience using Terraform and GoLang
• PagerDuty / Grafana / Tableau, preferred experience
• Understanding of third normal form (3NF) data modeling and when to apply it
• Knowledge and application of data theory
• Working knowledge of data security practices and least-privilege access standards
• Experience with data access controls in cloud environments (IAM roles, catalog permissions, etc.)

Equal opportunity for all

Route is an Equal Opportunity Employer. We embrace diversity and equal opportunity in a serious way. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Total Rewards

We know our team works best when everyone feels happy, healthy, and supported. We offer to pay 95% - 100% of your health insurance premiums for you and your family, remote or hybrid work arrangements, unlimited PTO, 401k matching, formalized growth opportunities, learning & development, DEI programs & events, and so much more.

Pay Transparency

Salary for this role: $138,000 - $146,000

The cash compensation above includes base salary, and is not reflective of potential commission for employees in eligible roles, or annual bonus targets under Route’s bonus plan for eligible roles. In addition to cash compensation, all Route employees are eligible to participate in Routes equity incentive plan to receive stock options per the terms of the agreement. Some roles may also be eligible for overtime pay. Individual compensation packages are based on a few different factors unique to each candidate, including their career level, skills, experience, specific geographic location qualifications and other job-related reasons.

About the Role

We’re looking for a Senior Data Engineer to design, build, and optimize our data platforms so teams across the company can make fast, reliable, data-driven decisions. You’ll be a key technical leader, owning end-to-end data pipelines and modeling, and setting best practices around how we work with data.

You’ll work heavily with Databricks, Spark, SQL, and Python, building scalable data solutions that power analytics, reporting, and data products. Experience in payments or financial services is a strong plus.

What You’ll Do

• Design and build data pipelines
• Develop, maintain, and optimize ETL/ELT pipelines on Databricks and Spark.
• Integrate data from multiple internal and external sources into a centralized data platform.
• Own data modeling & architecture
• Design and maintain robust data models (e.g., star/snowflake schemas, data vault, dimensional models) to support analytics and self-service BI.
• Establish and enforce data modeling standards and documentation.
• Ensure data quality, reliability, and performance
• Implement data quality checks, validation frameworks, and monitoring.
• Tune queries and jobs for performance and cost efficiency in Databricks and downstream systems.
• Collaborate and lead
• Partner with data analysts, data scientists, and product/engineering teams to understand data needs and translate them into technical solutions.
• Provide technical leadership and mentorship to other data engineers; help review designs and code.
• Governance & best practices
• Contribute to and refine our data governance, security, and access control practices.
• Drive best practices around version control, CI/CD for data, and code standards.

Required Qualifications

• 7+ years of professional experience as a Data Engineer, Software Engineer, or similar role.
• Strong hands-on experience with Databricks (or a very similar cloud data platform) including cluster management, jobs, and notebooks.
• Advanced experience with Apache Spark for batch and/or streaming data processing.
• Expert-level SQL skills (complex joins, window functions, query optimization).
• Strong Python skills for data engineering (e.g., PySpark, data processing libraries, scripting).
• Proven experience in data modeling and designing schemas for analytics and reporting.
• Experience building and maintaining data pipelines in a cloud environment (AWS, Azure, or GCP).
• Strong understanding of data warehousing concepts, ETL/ELT best practices, and data lifecycle.
• Solid software engineering fundamentals: version control (git), testing, code reviews, and CI/CD.
• Excellent communication skills and the ability to collaborate with technical and non-technical stakeholders.

Nice to Have

• Experience in payments, fintech, banking, or broader financial services (e.g., transaction data, ledgers, risk, fraud, reconciliation).
• Experience with streaming technologies (e.g., Spark Structured Streaming, Kafka, Kinesis, or similar).
• Familiarity with dbt or similar transformations-as-code frameworks.
• Experience with orchestration tools (e.g., Airflow, Databricks Workflows).
• Knowledge of BI tools (e.g., Power BI, Tableau, Looker) and how data models power them.
• Exposure to machine learning workflows and supporting data science teams.
• Experience implementing data governance, lineage, and catalog tools.

What You’ll Bring

• A product mindset: you think about the end users of data and build with usability in mind.
• A bias for automation, reliability, and scalability over one-off solutions.
• Comfort with ambiguity, ownership of complex problems, and a desire to continuously improve the data ecosystem.

What We Offer

• 401k investment opportunity, with company match   
• Medical, Dental, and Vision Plans
• Paid Time Off   
• Paid Parental Leave
• Paid Volunteer Leave

Role Information: 

• Full-Time, On-site, Provo