Staff Data Engineer

WEX Inc.; São Paulo; Hybrid; BRL 260,000 - 360,000; Full time

Job summary

WEX Inc. is seeking a Staff Data Engineer in Brazil to design and implement scalable data and reporting solutions for Health & Benefits data products. You will build reliable data pipelines, semantic models, and APIs that power ThoughtSpot, Power BI, and downstream dashboards.

You will collaborate with Data Platform, Analytics, and product teams to ensure data trust, performance, and security, mentoring others in Snowflake and BI system design.

Qualifications

• Experience building data pipelines and BI data products.
• Deep Snowflake expertise including RBAC and data sharing.
• Strong SQL and data modeling skills (star schema, Iceberg).
• Experience with ThoughtSpot or Power BI embedding.
• Experience with dbt and data quality frameworks.

Responsibilities

• Architecture and implement scalable reporting data models in Snowflake.
• Design semantic models, data sharing, and APIs for downstream consumers.
• Lead governance, quality validation, and security standards across pipelines.
• Deliver reliable data transformations and APIs for dashboards.
• Collaborate with DAAS and Platform teams to resolve data quality issues.
• Mentor engineers in data modeling and BI system best practices.

Skills

Snowflake modeling

Power BI / ThoughtSpot

Python / PySpark

SQL advanced

Data governance

Education

Bachelor's degree in CS/SE

Master's or PhD in CS/DS is a strong plus

Tools

dbt

Great Expectations

Airflow

API design

Job 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

• 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.
• 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. WEX is a global commerce platform that helps businesses solve for operational complexities like employee benefits, managing and mobilizing fleets, and streamlining payments. With over 6,500 employees, we work with large and small companies in more than 200 countries and territories, and can tailor our services to meet the unique needs of their businesses. We hire people who share our passion for continuous innovation and client service that is unparalleled in the industry. Offering comprehensive and market competitive benefits, our offerings are designed to support your personal and professional well-being. If you’re looking for a growing career - come be part of WEX today.

Equal Opportunity

WEX is an equal opportunity employer committed to diversity and inclusion in the workplace.

All qualified applicants will receive consideration for employment without regard to sex, race, color, age, national origin, religion, sexual orientation, gender identity, protected veteran status, disability or other protected status.

WEX promotes a drug-free workplace. Qualified individuals with a disability have the right to request a reasonable accommodation. If you require a reasonable accommodation as a result of your disability at any point in the job application process, please submit your request through our Reasonable Accommodation Request Form. This form is for accommodation requests only and cannot be used to inquire about the status of applications.