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. 

About Blue Acorn iCi

Blue Acorn iCi, a business unit of Infosys Nova Holdings, LLC, is a digital experience partner helping global brands design, build, and optimize the future of customer engagement. We blend data, design, and technology to deliver connected commerce and content solutions that drive measurable results.

Specializing in the Adobe Experience Cloud, we provide end-to-end services across commerce, content, analytics, and customer insights. Backed by Infosys, we’re growing fast—and we’re looking for exceptional talent to grow with us.

Our teams work at the intersection of strategy and execution—solving complex challenges for industry leaders in healthcare, retail, manufacturing, and beyond. From large-scale digital transformation programs to platform implementations and ongoing optimization, we bring deep expertise and a collaborative mindset to every engagement.

Why Join Us?

Blue Acorn iCi is a place for curious thinkers, smart builders, and digital pioneers. We’re more than a consultancy—we’re a team of innovators helping the world’s top brands shape the future of digital.

Here, you won’t just contribute to a project—you’ll drive meaningful outcomes, collaborate with cross-disciplinary teams, and grow your skills in a high-impact, high-growth environment. We believe great work starts with great people, and we’re committed to creating a culture where talent thrives, ideas spark change, and results speak for themselves.

If you’re ready to push boundaries, deliver real value, and help shape the next generation of digital experiences—this is your place.

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!

Blue Acorn iCi is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, spouse of protected veteran, or disability.

Please click to read EEO Law and Pay Transparency Act and IER Right to Work Document and Privacy Notice.

Blue Acorn iCi will endeavor to make a reasonable accommodation to the known physical or mental limitations of a qualified applicant with a disability unless the accommodation would impose an undue hardship on the operation of our business. If you believe you require such assistance to complete this form or to participate in an interview, please contact us at: careers@blueacornici.com.

California applicants: Please click here for CCPA disclosures.