Software Development Engineer 2

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? This role focuses on integrated engineering, where development, data quality, architecture, and agility skills blend together throughout the solution delivery pipeline.

About the role

As a Software Development Engineer 2 (SDE 2) focusing on Data Engineering & Data Architecture, you will champion an end-to-end (E2E) approach to data pipelines and modeling that power our Customer Data Platform (CDP), directly feeding marketing/commercial segmentation and customer journeys. You will act with independence to own specific modules, functional areas, and data models without constant oversight.

Responsibilities

• 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.
• 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.
• Data Discovery & Complex Business Logic Execution
  • Translate complex commercial and marketing rules into scalable data solutions.
  • Perform deep-dive data discovery, technical feasibility assessments, and data volume analysis to quantify business impact and ensure scalability before committing to a build.
• 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.
• 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.

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.

Pay

Pay Range: $96,100.00 - $115,500.00

Benefits

• Health, dental, and vision insurance
• Retirement savings plan
• Paid time off
• Health savings account and flexible spending accounts
• Life insurance and disability insurance
• Tuition reimbursement
• Quarterly or annual bonuses for non-sales roles
• Commission for sales positions under applicable plans