Manager, Cloud Data Engineering and BI reporting

Software Development Manager III, Cloud Data Engineering and BI reporting

At WEX, we simplify the business of running a business.  Our WEX Health & Benefits solutions reduce complexity and help manage costs of benefits administration for our clients and partners.  We are looking for passionate technologists, collaborators, and problem solvers to join our Health & Benefits Technology team as we build the next generation of employer benefits solutions and services.

As a Software Engineering Manager on the WEX Health & Benefits Technology team, you will lead a team that partners closely with Product Managers and customers to learn about the challenges employers face while navigating the competitive employee benefits landscape.  You will become a domain expert, designing solutions that solve problems in ways our customers love and work for our business.  You will lead teams who build the highest quality software in the latest technologies and test driven development practices.

Responsibilities:

• Lead, mentor, and manage your team through the successful delivery of valuable customer software.

• Stay current with emerging technologies and industry trends to drive innovation and strengthen TDD and BDD processes.

• Collaborate closely with Product Management by providing technical guidance on software design.

• Guide your team on best practices, coding standards, and design principles.

• Conduct performance reviews, set goals, and support professional development for team members.

• Measure, inspect, and drive decisions using data.

• Design, test, code, and instrument new solutions.

• Support live applications, promote proactive monitoring, rapid incident response and troubleshooting, and continuous improvement.

• Analyze existing systems and processes to identify bottlenecks and opportunities for improvements.

• Understand how your domain fits into and contributes to the overall company.

• Influence priority, expectations, and timelines within your domain.

• Set short-term (~monthly) goals for your team to deliver on priorities.

• Focus on instrumentation and team efficiency and performance measurables

• Contribute to long term vision and the strategy to achieve the vision for the technology organization

• Interact and communicate effectively with peer groups, non-technical organizations, and middle management.

• Drive collaboration across technology teams to foster innovation and follow guidelines around re-usability of frameworks and governance of architecture patterns

Role Overview

As Software Development Manager, you will serve as a key technical leader in designing and implementing data and reporting solutions across the Azure Cloud, Snowflake 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 Azure Cloud, 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 Core 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 Azure Cloud, Snowflake and BI systems.

• Contribute to documentation, standards, and architecture reviews.

Qualifications

Required

• 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.

• At least 5 years of management or supervisory experience.

• At least 8+ years of experience in data engineering, data products, or BI systems.

• Deep expertise in:

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

  • 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.

• 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.

Preferred

• Experience 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 with modern technologies (Snowflake, ThoughtSpot, Airflow, Iceberg, Kafka, IICS, APIs) to deliver real-world impact through high-quality data and reporting solutions.

The base pay range represents the anticipated low and high end of the pay range for this position. Actual pay rates will vary and will be based on various factors, such as your qualifications, skills, competencies, and proficiency for the role. Base pay is one component of WEX's total compensation package. Most sales positions are eligible for commission under the terms of an applicable plan. Non-sales roles are typically eligible for a quarterly or annual bonus based on their role and applicable plan. WEX's comprehensive and market competitive benefits are designed to support your personal and professional well-being. Benefits include health, dental and vision insurances, retirement savings plan, paid time off, health savings account, flexible spending accounts, life insurance, disability insurance, tuition reimbursement, and more. For more information, check out the "About Us" section.Pay Range: $143,000.00 - $190,000.00