Software Development Engineer 2- Data Engineering

Summary

WEX is seeking a Software Development Engineer 2 to support data engineering and data architecture for its Customer Data Platform. The role involves designing Snowflake data models and dbt pipelines, making architecture decisions, aligning stakeholders, mentoring junior engineers, ensuring data quality, and implementing AI-augmented engineering workflows.

Responsibilities

• Design and build robust data models in Snowflake using dbt, spanning from staging through to production data marts, ensuring they are resilient, cost-effective, and maintainable
• Integrate, stage, and reconcile data from multiple complex source systems (e.g., Siebel CRM, Enterprise Data Warehouse (EDW) snapshots, portfolio health hubs) into a unified Customer Data Platform
• Add field enhancements and manage the evolution of the CDP Mart to power downstream segmentation and outbound journeys
• Own feature-level architecture decisions and author Architecture Decision Records (ADRs)—evaluating alternative technical approaches and documenting recommended paths for technical sign-off
• Manage the dbt "lakefront" project structure, establishing model ownership, group permissions, and approved-team configurations to safely enable team self-service and decentralized model changes
• Contribute to the evolution of team "Golden Paths", service communication standards, and data orchestration workflows
• Translate complex commercial and marketing rules
• Perform deep-dive data discovery, technical feasibility assessments, and data volume analysis to quantify business impact and ensure scalability before committing to a build
• Partner actively across engineering, analytics, product, and business stakeholders to reconcile conflicting business logic, align definitions, and drive consensus toward a single source of truth
• Lead feature-level demonstrations and facilitate technical alignment workshops with product managers and cross-functional teams to resolve ambiguity
• Mentor Level 1 engineers through pair programming, structured knowledge-sharing sessions, and constructive, empathetic code/configuration reviews
• Take ownership of feature-level data quality, designing automated regression tests and verification checks to balance risk versus test coverage
• Implement, debug, and leverage AI-augmented engineering workflows (e.g., GitHub Copilot, basic LLM integrations, or automated prompt configurations) to optimize pipeline efficiency and code readability while verifying all outputs against strict enterprise standards

Skills

• 3-5 years of professional experience in data engineering, data warehousing, or a software development engineering role focusing on data
• Proven track record of independently designing and building highly scalable data models and staging environments inside Snowflake
• Strong hands-on experience managing dbt projects, testing, documentation, and source-control-driven data pipelines
• Proficient experience utilizing CI/CD automation tools, managing branches, and executing automated code/data quality gates
• Strong analytical capability to break down abstract business constraints into concrete data exclusions, filtering matrixes, and performance-tuned queries
• Direct hands-on experience or familiarity with Salesforce Data360 / DataCloud (CDP) ingestion, mapping, and orchestration patterns

Qualifications

Must Haves

• 3-5 years of professional experience in data engineering, data warehousing, or a software development engineering role focusing on data
• Proven track record of independently designing and building highly scalable data models and staging environments inside Snowflake
• Strong hands-on experience managing dbt projects, testing, documentation, and source-control-driven data pipelines
• Proficient experience utilizing CI/CD automation tools, managing branches, and executing automated code/data quality gates
• Strong analytical capability to break down abstract business constraints into concrete data exclusions, filtering matrixes, and performance-tuned queries

Nice to Haves

• Direct hands-on experience or familiarity with Salesforce Data360 / DataCloud (CDP) ingestion, mapping, and orchestration patterns

Benefits

• 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.
• Health, dental and vision insurances
• Retirement savings plan
• Paid time off
• Health savings account
• Flexible spending accounts
• Life insurance
• Disability insurance
• Tuition reimbursement