Snowflake Data Engineer

Blue Acorn iCi

26d

About The Position

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. 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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.
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).
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.
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.
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.
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.

Benefits

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!

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume