Software Development Engineer 2

WEX Inc; Portland (ME); On-site; USD 120,000 - 170,000; Full time

Job summary

WEX Inc. is seeking a Software Development Engineer 2 focused on Data Engineering & Data Architecture. You will own data pipelines and modeling powering the Customer Data Platform, feeding marketing segmentation and journeys.

Expect independent ownership of modules and data models with minimal oversight. Responsibilities include designing robust data models in Snowflake, managing data ingestion from Siebel/EDW-like sources, and collaborating across engineering and analytics to align business

Qualifications

• 3–5 years of professional experience in data engineering, data warehousing, or a software role focusing on data.
• Proven ability to independently design and build scalable data models and staging areas in Snowflake.
• Hands-on dbt projects with testing, documentation, and source-control driven pipelines.

Responsibilities

• Design and build scalable data models in Snowflake using dbt across staging to production data marts.
• Collaborate with analytics, product, and engineering to align data definitions and business logic.
• Lead data quality and automated regression checks to ensure data reliability and governance.

Skills

Snowflake proficiency

dbt experience

Data modeling

Salesforce Data360 / DataCloud

CI/CD automation

Problem solving

Tools

Snowflake

dbt

Salesforce Data360/DataCloud

Job description

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. 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. 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. 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. 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. 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: Prowficient 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 var