Staff Software Engineer
Core
Design and implement scalable data models, reporting pipelines, and APIs to power Snowflake, ThoughtSpot, and Power BI solutions for WEX's Health & Benefits business.
Role type
Staff Data Engineer (Reporting & Data Products)
Builds
Scalable reporting data models, semantic layers, APIs, and self-service tools for BI consumption
Domain
Financial Services / Health & Benefits / Data Engineering
Required skills
Snowflake architecture, SQL, Python/PySpark, Airflow/IICS orchestration, Azure ecosystem, REST/GraphQL APIs, data modeling patterns (star schema, Iceberg), CDC ingestion
Preferred skills
dbt, Great Expectations, ThoughtSpot Everywhere embedding, Iceberg table management, healthcare/financial domain knowledge
Technologies
Snowflake, ThoughtSpot, Power BI, Python, PySpark, Airflow, Informatica IICS, Azure ADLS, Kafka, Debezium, Iceberg, dbt, Great Expectations
Responsibilities
Architect scalable reporting data models in Snowflake; design semantic models and data sharing mechanisms; build performant data transformations and APIs; implement data validation and quality frameworks; mentor engineers on data modeling and performance tuning
Seniority
Staff, hands-on IC with strategic leadership