Snowflake Data Engineer

We are seeking a Snowflake Data Engineer to join our consulting team. In this role, you will design, implement, and optimize scalable data ingestion pipelines that deliver high-quality sales, customer, and operational data into Snowflake and downstream into Adobe Experience Platform (AEP). You will work with enterprise clients, advising them on best practices for upstream data architecture, identity readiness, and XDM data modeling to power Real-Time CDP, Customer Journey Analytics, AJO and personalization programs. 

This is a consulting role—ideal for someone who is comfortable interfacing with stakeholders, translating business needs into technical solutions, and delivering high-impact data engineering work within complex client environments. 

Key Responsibilities 

Client Delivery & Advisory 

• Serve as a trusted technical advisor to clients on Snowflake architecture, data ingestion patterns, and upstream data readiness for AEP. 

• Participate in client workshops to understand business goals, data sources, and marketing activation needs. 

• Communicate technical concepts clearly to both technical and non-technical stakeholders. 

• Contribute to discovery sessions, solution design presentations, and technical documentation. 

Data Ingestion & Pipeline Engineering 

• Design and build Snowflake-based ingestion pipelines for client sales, product, CRM, and digital datasets. 

• Implement robust batch and streaming ingestion frameworks aligned to AEP latency, sequencing, and data freshness requirements. 

• Integrate data from diverse client systems (ERP, CRM, POS, ecommerce, 3rd-party sources, cloud storage). 

Data Modeling & AEP Alignment 

• Structure and transform client data into AEP-ready formats, ensuring alignment with XDM classes, identity namespaces, and event schemas. 

• Develop data pipelines that support identity stitching, master ID mapping, email hashing, and customer profile enrichment. 

• Ensure upstream structures support downstream activation, segmentation, analytics, and journey orchestration. 

Data Quality, Governance & Observability 

• Implement data quality gates, validation rules, schema drift detection, and anomaly alerts across client environments. 

• Advise clients on data governance best practices, metadata standards, and ongoing data stewardship. 

• Monitor and optimize data ingestion performance, warehouse utilization, and cost efficiency. 

Cross-Functional Collaboration 

• Work closely with AEP Architects, RTCDP Engineers, CJA Consultants, client IT/CRM teams, and marketing stakeholders. 

• Translate client business requirements into technical designs and actionable engineering tasks. 

• Troubleshoot data issues impacting AEP profile counts, identity resolution, source-of-truth consistency, and downstream reporting. 

Continuous Improvement & Consulting Excellence 

• Contribute reusable frameworks, documentation, and accelerators to improve future AEP projects. 

• Stay current on new Snowflake and AEP features to guide clients toward scalable, modern solutions. 

• Lead or support internal knowledge-sharing, mentoring, and solution development. 

Qualifications 

• 4+ years’ experience as a Data Engineer or Snowflake Data Engineer, ideally in a consulting or multi-client setting. 

• Deep expertise in Snowflake (SQL, Snowpipe, Streams & Tasks, performance tuning, RBAC). 

• Strong proficiency with SQL, Python, and modern ELT/ETL tools (DBT, Airflow, Matillion, Informatica, etc.). 

• Experience designing pipelines that feed Adobe Experience Platform or similar customer data platforms. 

• Familiarity with XDM schemas, identity graphs, hashed identifiers, event-based data models, and profile stitching concepts. 

• Strong understanding of data warehousing, MDM concepts, and data quality practices. 

• Excellent communication skills with a proven ability to interact directly with clients. 

Preferred Experience 

• Hands-on experience with AEP, RTCDP, CJA, or similar marketing technology ecosystems. 

• Prior consulting experience delivering multi-phase data, analytics, or MarTech projects. 

• Working knowledge of CRM systems (Salesforce, Dynamics), ecommerce platforms, and POS architectures. 

Success Measures 

• Delivery of clean, accurate, and scalable pipelines that meet client data needs for Snowflake and AEP. 

• Clear documentation, strong communication, and high client satisfaction across engagements. 

• Improved client data quality, identity consistency, and readiness for AEP activation and analytics use cases. 

• Demonstrated ability to support multiple projects while contributing to internal consulting standards and innovation.