Data Engineer – Snowflake
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Snowflake Data Engineer designing and optimizing data ingestion pipelines into Snowflake. Advising enterprise clients on best practices for data architecture and real-time personalization programs.
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.
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)
Similar Jobs
Data Architect
Data Architect evaluating and evolving data architecture for partners at EVT. Focus on ingestion, processing, and structuring of data with a collaborative team environment.
Data Engineer
Data Engineer responsible for designing, building, and maintaining data pipelines at Loopback Health. Collaborating with cross-functional teams to drive system and process improvements.
Data Engineer
Data Engineer optimizing and maintaining data pipelines in Blackline Safety's IoT-enabled safety ecosystem. Collaborating with product, engineering, and analytics teams on impactful data-driven initiatives.
Senior Ingeniero de Datos
Senior Data Engineer developing data solutions for transforming lives at Sofka. Collaborating in a close-knit team focused on continuous improvement and technical excellence.
Senior Data Engineer
Senior Data Engineer at Arsipa developing scalable data platforms and ETL/ELT pipelines. Collaboration with teams to ensure data quality, performance, and innovation in data architecture.
Data Engineer
Data Engineer shaping cloud-based data solutions for top U.S. companies. Engage with diverse projects remotely from Latin America.
Senior Data Engineer
Senior Technical Consultant delivering end-to-end data solutions and managing client relationships. Collaborating with technical team to drive project success with Microsoft technologies.
Senior Data Engineer – Data for Products
Lead the design and implementation of scalable batch and streaming data pipelines on Azure. Collaborate with product teams to ensure data quality, performance, and governance across the data lifecycle.
Data Engineer
Data Engineer maintaining scalable data pipelines for an international company in Hamburg. Requires experience with Snowflake, ETL processes and Azure Data Factory.
IS Data Warehouse Architect – III
Data Warehouse Architect designing and developing data models and ETL specifications. Collaborating on data architecture and vendor relations for a nonprofit health care organization.
Senior Director – Data Platform, Analytics
Leading the development of an integrated data platform at Harbor Compliance. Unifying fragmented data and establishing governance to empower decision-making.
Senior Data Engineer
Senior Data Engineer at D.A. Davidson optimizing data integrations and migrating legacy structures. Involves cloud architecture and coordination with product teams.
Data Architect
Professional Services Delivery Architect at Ciena guiding global delivery teams and ensuring high-quality outcomes for customer engagements. Leading complex transformations and influencing solution strategy.
Distinguished Architect, Data Platform
Distinguished Architect leading the design of a next-generation data platform at CloudZero. Driving technical decisions and architectural innovations for scalable cloud cost management solutions.
Senior Data Engineer
Data Engineer designing and maintaining data pipelines for Arrow Electronics. Collaborating with teams in engineering and architecture discussions across global projects.
Data Engineer – AI, Spark, Databricks, Healthcare
Data Engineer managing advanced Spark scripts for data validation and integration at Cotiviti. Collaborating with engineering teams to ensure data integrity and compliance in healthcare data processes.
Senior Software Engineer, Data Platform Team
Senior Software Engineer designing and developing features for data platforms at Sysdig. Leading technical strategy and mentoring teams in cloud security innovations.
Data Engineering Architect – Manager
Data Engineering Architect managing scalable AWS Data Lakehouse architectures at Naveera Technology. Overseeing data engineering projects with a focus on analytics and reporting solutions.
AI Data Engineer
AI Data Engineer bridging data warehousing and AI-driven analytics capabilities. Collaborating on automated solutions and operational workflows in eCommerce with global brands.
AI Data Engineer
AI Data Engineer at Netwrix designing and building enterprise-grade data and AI platforms. Focused on stability and repeatability while adhering to security and governance standards.