The Senior Data Engineer will design and optimize data solutions on Snowflake, build scalable data pipelines, and ensure high data quality with compliance. Responsibilities include data integration, security design, automation, and documentation.
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.
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.
- 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.
Thank you for your interest in a career with Appnovation Technologies! Please note that only those selected for an interview will be contacted.
At Appnovation, we recognize that diverse teams are the strongest teams. Diversity, Equity & Inclusion is not only something that we embrace - we celebrate it! We are proud to be an Equal Opportunity Employer and we encourage applicants from all backgrounds, lived experiences and industries to apply. Come join us at Appnovation, and learn more about how we stay true to our company values as we build better lives through better digital.
Accommodations are available upon request throughout the recruitment process.
Accommodations are available upon request throughout the recruitment process.
Top Skills
AWS
Dbt
Snowflake
SQL
Similar Jobs
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
The Senior Intranet Lead will design and evolve the intranet's technical architecture, ensuring scalability and performance while collaborating with cross-functional teams for a user-first approach.
Top Skills:
APIsCo-PilotMicrosoft 365SharepointViva Engage
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The Sales Specialist is responsible for strengthening market presence and achieving revenue goals in the insurance and auto sectors, leveraging market expertise and data-driven insights to inform strategic growth.
Top Skills:
Data-Driven AnalysisFinancial Services KnowledgeMarket Intelligence
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
The role involves supporting sales strategy by delivering analytics, facilitating sales quotas, providing insights for decision-making, and preparing reports and presentations for senior leadership.
Top Skills:
ExcelSalesforce
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
