Senior Associate, Data Platform Engineer - Snowflake

About us

Appnovation is a global, full-service digital partner that combines Strategy, Experience & Design, Engineering and Managed Services. We build digital solutions that deliver real impact today and serve as foundations for future growth.  Bold ambition. Practical action. Endless possibilities.

About the Role

As a Senior Data Engineer you will be  responsible for designing implementing and optimizing data solutions on the Snowflake cloud leveraging eventdriven architectures with modern cloudnative AWS serverless infrastructure and integrating with Salesforce Data 360 Data Cloud This role focuses on building and operating robust scalable data pipelines and curated data models within Snowflake ensuring high data quality and governed access and enabling advanced analytics and activation use cases that support business growth and strategic decisionmaking The ideal candidate brings deep expertise in eventdriven architectures serverless integration patterns Snowflake architecture and modern data engineering practices combined with strong analytical and communication skills

Key Responsibilities

• Design, develop, and maintain scalable ELT/ETL pipelines that ingest, transform, and publish data into Snowflake from internal and external sources.
• Partner with product, analytics, and application teams to translate CDP and data requirements into well-modelled data in Snowflake, using scalable and cost-efficient event-driven data pipelines.
• Design secure data access patterns for internal platforms (RBAC, masking policies, row access policies) and support privacy/compliance needs (e.g., GDPR, CCPA) across the data platform.
• Automate deployments and operational workflows using version control and CI/CD; maintain infrastructure as code and repeatable release processes for Snowflake objects.
• Document Snowflake architectures, data flows, and operational runbooks; stay current on Snowflake capabilities (e.g., Snowpipe, Streams/Tasks, Dynamic Tables); and recommend enhancements to improve reliability and scalability.

Qualifications

• Bachelor’s or Master’s degree in computer science, Information Systems, Engineering, or a related field.
• 5+ years of professional experience in data engineering, with significant hands-on experience designing integrations with data warehousing and large databases (Snowflake preferred).
• Strong SQL skills and experience building curated schemas, semantic layers, and reusable data models for analytics and activation use cases.
• Proficiency with modern ELT/ETL and transformation patterns and tools (e.g., dbt or equivalent), including incremental processing and orchestration.
• Experience integrating Snowflake with external systems using APIs, file-based ingestion, or streaming/event patterns; familiarity with common integration/middleware platforms is a plus.
• Hands-on knowledge of cloud platforms (AWS, Azure, or GCP) as they relate to data storage, networking, security, and processing.
• Solid understanding of data governance, security, privacy, and compliance standards (e.g., GDPR, CCPA).
• Proven ability to analyze complex data sets and translate business requirements into technical solutions.
• Excellent problem-solving, communication, and project management skills.