Snowflake Data Engineer - Cloud Data Platform Leader

Xebia Group; Washington (District of Columbia); On-site; USD 120,000 - 180,000; Full time

Job summary

Xebia is seeking a Snowflake Data Engineer to build and manage a modern cloud data platform across ingestion, transformation, and delivery layers. The role combines Snowflake engineering, Fivetran ingestion, and dbt analytics to modernize legacy SQL Server/SSIS/SSAS workloads into a scalable platform with automation, validation, lineage, and reporting readiness.

The candidate will lead data storage design, transformation patterns, and performance optimization in Snowflake, ensuring support for

Qualifications

• Strong hands-on experience implementing Snowflake in enterprise environments.
• Deep knowledge of SQL, query optimization, performance tuning, and warehouse design.
• Experience migrating from legacy EDW platforms such as SQL Server, SSIS, and SSAS.
• Exp. with dbt, Fivetran, AWS, and Sigma BI/reporting integrations.
• Hands-on experience with Fivetran or comparable cloud ingestion tools.
• Strong AWS fundamentals: S3, IAM, KMS, VPC, PrivateLink for Snowflake connectivity.
• Strong understanding of source-to-target mapping, CDC concepts, and incremental loading.
• Experience working with Snowflake and cloud-based data platforms.
• Ability to write SQL for data validation and reconciliation between source and Bronze landing tables.

Responsibilities

• Design, configure, and maintain the Snowflake platform across development, test, and production.
• Implement and manage cloud-based ingestion using Fivetran for diverse source systems.
• Build and optimize data architecture across raw, staging, curated, and reporting layers.
• Develop and maintain dbt models replacing legacy ETL logic for curated data assets.
• Translate legacy ETL patterns into modern Snowflake/dbt implementations.

Skills

Snowflake

SQL

dbt

Fivetran

AWS

Sigma BI

Data Warehouse

ETL

Tools

Snowflake

dbt

Fivetran

Sigma

AWS

Job description

Xebia is seeking a Snowflake Data Engineer to build and manage a modern cloud data platform across ingestion, transformation, and delivery layers. The role combines Snowflake engineering, Fivetran ingestion, and dbt analytics to modernize legacy SQL Server/SSIS/SSAS workloads into a scalable platform with automation, validation, lineage, and reporting readiness.

The candidate will lead data storage design, transformation patterns, and performance optimization in Snowflake, ensuring support for