WEX Inc. Logo

WEX Inc.

Software Development Engineer 2- Data Engineering

Posted 2 Months Ago
In-Office
Boston, MA, USA
96K-116K Annually
Mid level
In-Office
Boston, MA, USA
96K-116K Annually
Mid level
Build and own Snowflake data models and dbt pipelines for a Customer Data Platform supporting marketing segmentation and customer journeys. Integrate complex source systems, manage data architecture and governance, conduct data discovery, and translate business rules into scalable solutions. Collaborate with engineering, analytics, product, and business stakeholders; lead technical workshops; mentor junior engineers; and implement automated data quality testing, CI/CD workflows, and AI-augmented engineering practices.
The summary above was generated by AI

About the Role

Are you a technical artisan who thrives in collaborative environments and gets excited about solving the right problems, the right way? Do you believe in breaking down silos and fostering a culture of shared responsibility? Then this role is for you! In today's software development and data landscape, collaboration, end-to-end (E2E) accountability, problem-solving, and streamlined workflows are key to achieving efficiency and delivering high-quality solutions that solve customer problems and generate business outcomes.
 

We believe in the power of integrated engineering, where development, data quality, architecture, and agility skills blend together throughout the solution delivery pipeline.
 

As a Software Development Engineer 2 (SDE 2) focusing on Data Engineering & Data Architecture, you will be a champion for this approach. You will own the data pipelines and modeling that power our Customer Data Platform (CDP), directly feeding marketing/commercial segmentation and customer journeys. In this role, you will match the expectations of an Intermediate Individual Contributor (EAE 2), acting with independence to own specific modules, functional areas, and data models without constant oversight.
 

How you’ll make an impact

  • Domain: Data Engineering & Data Architecture for a Customer Data Platform (CDP) feeding marketing/commercial segmentation and journeys.

  • Primary Tech Stack: Snowflake, dbt (Data Build Tool), CI/CD Automation.

  • Preferred Tech Stack: Salesforce Core, Salesforce Data360 (DataCloud).

Experience you'll bring 

1. Data Modeling & Pipeline Engineering

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

2. Architecture & Technical Governance
  • 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.
     

3. Data Discovery & Complex Business Logic Execution
  • 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.
     

4. Stakeholder Alignment & Team Collaboration
  • 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.
     

5. Quality Assurance & AI-Augmented Workflows
  • 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.

Qualifications & Requirements

  • Experience: 3-5 years of professional experience in data engineering, data warehousing, or a software development engineering role focusing on data.

  • Snowflake Proficiency: Proven track record of independently designing and building highly scalable data models and staging environments inside Snowflake.

  • dbt (Data Build Tool): Strong hands-on experience managing dbt projects, testing, documentation, and source-control-driven data pipelines.

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

  • CI/CD & DevOps: Proficient experience utilizing CI/CD automation tools, managing branches, and executing automated code/data quality gates.

  • Problem-Solving: Strong analytical capability to break down abstract business constraints into concrete data exclusions, filtering matrixes, and performance-tuned queries.

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: $96,100.00 - $115,500.00

Similar Jobs

28 Minutes Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, consult customers on insurance needs, recommend appropriate coverages and products, and convert prospects into policyholders. The role includes paid training and Property and Casualty licensing support, customer relationship building, sales closing, and representing the Liberty Mutual brand. Employees must work a designated weekday and weekend schedule and maintain a compliant remote workspace with wired high-speed internet.
Top Skills: PcWired High-Speed Internet
28 Minutes Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, consult customers on insurance needs, recommend appropriate coverages and products, and convert prospects into policyholders. Represent the Liberty Mutual brand, deliver customer-focused service, close sales, and complete paid licensing and role training. Employees must maintain a remote workspace, work a weekday and weekend schedule, and obtain a Property and Casualty license after hire if not already licensed.
Top Skills: Cable InternetDsl InternetFiber InternetPcWired High-Speed Internet
28 Minutes Ago
Remote or Hybrid
45K-85K Annually
Junior
45K-85K Annually
Junior
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Handle inbound calls and warm leads, consult customers on insurance needs, recommend appropriate Property and Casualty coverage, and convert prospects into policyholders. The role involves representing the Liberty Mutual brand, communicating persuasively, meeting sales goals, completing paid licensing training, and providing customer-focused service. Employees must work a specified weekday and weekend schedule and maintain a compliant home-office setup with wired high-speed internet.
Top Skills: Pc ProficiencyWired High-Speed Internet

What you need to know about the Boston Tech Scene

Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.

Key Facts About Boston Tech

  • Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
  • Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
  • Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
  • Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account