Note: The job is a remote job and is open to candidates in USA. WEX is a global technology services company seeking a Software Development Engineer 2 focusing on Data Engineering and Data Architecture. The role involves owning data pipelines and modeling for their Customer Data Platform, collaborating with cross-functional teams to deliver high-quality solutions that enhance customer journeys.
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
Benefits
- Health, dental and vision insurances
- Retirement savings plan
- Paid time off
- Health savings account
- Flexible spending accounts
- Life insurance
- Disability insurance
- Tuition reimbursement
Company Overview
Company H1B Sponsorship