Blue Acorn iCi

Data Engineer – Snowflake

Blue Acorn iCi

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AirflowCloudERPETLInformaticaMatillionPythonSQL

About the role

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

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.
Benefits
  • Competitive benefits package that includes medical, dental and vision insurance
  • Life insurance
  • Disability
  • Paid time off
  • 401(k)

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SnowflakeSQLPythonDBTAirflowMatillionInformaticadata ingestiondata warehousingdata quality
Soft skills
communicationtechnical advisingproblem-solvingmentoringcollaborationclient interactiondocumentationpresentationknowledge sharingstakeholder engagement