Blue Acorn iCi · 1 month ago
Snowflake Data Engineer
United States
Full-time
Remote
Mid, Senior Level
4+ years expBlue Acorn iCi is a digital experience partner helping global brands design, build, and optimize the future of customer engagement. They are seeking a Snowflake Data Engineer to design, implement, and optimize scalable data ingestion pipelines, while advising enterprise clients on best practices for data architecture and modeling.
Information Technology & Services
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
Qualification
Required
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
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
Benefits
Medical, dental and vision insurance
Life insurance
Disability
Paid time off
401(k)
And more!
Company
Blue Acorn iCi
Blue Acorn iCi, an Infosys Company, is the leading digital customer experience company pioneering what’s possible through the convergence of analytics, digital commerce, customer experience, and experience-driven commerce offerings.
201-500 employees
H1B Sponsorship
Blue Acorn iCi has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (7)
2023 (4)
2022 (5)
Funding
Current Stage
Growth StageLeadership Team
Chris G.
Chief Executive Officer
Judy Geaslen
Chief Financial Officer
Company data provided by crunchbase