Staff Data Engineer

About the Team

The Health & Benefits (H&B) Data Products & Reporting team delivers scalable, high-quality data products and reporting solutions for WEX’s H&B business.
We operate downstream of the Enterprise Data Platform , consuming curated and conformed data to power Snowflake , ThoughtSpot , Power BI , and API-driven reporting experiences.

Our goal is to transform complex data into accurate, accessible, and actionable insights — empowering clients, operations, and product teams through data-driven decision making.

Role Overview

As a Staff Data Engineer , you will serve as a key technical leader in designing and implementing data and reporting solutions across the Snowflake consumption layer and our reporting ecosystem.
You’ll work closely with the Data Platform , Product , and Analytics teams to build reliable data pipelines, reporting models, APIs, and self-service tools that ensure trust, transparency, and performance in our data products.

This role combines data platform expertise with reporting system design — ideal for someone who can bridge upstream data architecture with downstream business intelligence needs.

Key Responsibilities

Architecture & Design

• Architect and implement scalable reporting data models in Snowflake to support ThoughtSpot and Power BI consumption.

• Design and maintain robust semantic models , data sharing mechanisms , and APIs for downstream consumers.

• Partner with the Data Platform team to align ingestion, conformance, and consumption patterns across ADLS , Iceberg , Airflow , and IICS .

• Define and implement data governance , quality validation , and security standards across reporting pipelines.

Delivery & Ownership

• Build performant, reusable data transformations and APIs for reporting and dashboards.

• Integrate with Snowflake Data Sharing , webhooks , and REST/GraphQL endpoints to deliver customer-facing insights.

• Lead proof-of-concepts for new reporting frameworks and data sharing capabilities.

• Ensure reliability, accuracy, and auditability across all data presented to end users.

Quality & Observability

• Implement data validation and quality frameworks (e.g., dbt tests, Great Expectations).

• Monitor data freshness and pipeline health through observability tools and Snowflake monitoring.

• Collaborate with DAAS and Platform teams to triage and resolve data quality issues.

Collaboration & Mentorship

• Partner with product managers, analysts, and business stakeholders to translate requirements into scalable data solutions.

• Mentor engineers in data modeling, performance tuning, and best practices for Snowflake and BI systems.

• Contribute to documentation, standards, and architecture reviews.

Qualifications

Required

• Strong experience in data engineering, data products, or BI systems.

• Deep expertise in:

  • Snowflake – modeling, performance optimization, RBAC, and data sharing.

  • SQL – advanced queries, window functions, analytical optimizations.

  • ThoughtSpot / Power BI – data modeling, embedding, semantic layer design.

  • Python / PySpark – data transformations and automation.

  • Airflow , Informatica IICS , or equivalent for orchestration.

  • Azure ecosystem – ADLS, ADF, and related services.

• Strong understanding of data modeling patterns (star schema, Iceberg, medallion architecture).

• Familiarity with Kafka / Debezium for CDC-based ingestion.

• Experience building or consuming REST / GraphQL APIs for data products.

• Bachelor's degree in Computer Science, Software Engineering, or a related technical field

• A Master's or PhD in Computer Science, Data Science, Machine Learning, Artificial Intelligence or Statistics is a strong plus.

Preferred

• Hands-on with dbt , Great Expectations , or similar data quality frameworks.

• Experience embedding analytics through ThoughtSpot Everywhere or APIs.

• Knowledge of Iceberg table management , webhooks , and event-driven pipelines .

• Background in healthcare, benefits, or financial data domains.

What Success Looks Like

• Scalable and trusted data models powering H&B reporting and dashboards.

• Seamless collaboration with the Data Platform team ensuring quality and timeliness of data.

• Reporting pipelines that are observable, cost-efficient, and secure.

• Business users empowered with timely and accurate insights.

Why Join Us

You’ll be part of a mission-driven team building the next generation of data and analytics platforms for Health & Benefits at Wex.
Work hands-on with modern technologies (Snowflake, ThoughtSpot, Airflow, Iceberg, Kafka, IICS, APIs) to deliver real-world impact through high-quality data and reporting solutions.