Snowflake Data Engineer

Blue Acorn iCi-posted 1 day ago

Full-time • Mid Level

101-250 employees

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

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.

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.

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.

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.

Full Time, Non-Temporary Employees enjoy a competitive benefits package that includes medical, dental and vision insurance, life insurance, disability, paid time off, 401(k), and more!

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

Snowflake Data Engineer Resume Examples

•

Snowflake Data Engineer Cover Letter Examples

Snowflake Data Engineer

Job Search Resources

Tools

Career Hubs

Guides

Company