Staff Data Engineer
Description
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.