Recrute Action
11 months ago
Senior Data Architect – Snowflake (AWS)
Sign up to save this job, get alerts, and apply with an optimized CV.
Company information
- Company
- Recrute Action
- Location
- Canada, Ontario, York region, Markham Canada
- Posted
- 11 months ago
Job description
Senior Data Architect – Snowflake (AWS)
Opportunity in the insurance industry for a skilled Dara Architect with a proven track record in large-scale data transformation programs, ideally in insurance or financial services.
What is in it for you:
• Salaried: $85-100 per hour.
• Incorporated Business Rate: $100-115 per hour.
• 6-month contract.
• Full-time position: 37.50 hours per week.
• Hybrid model: 3 days per week on-site, subject to change.
Responsibilities:
• Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.
• Migration of the existing Datawarehouse solution to Snowflake
• Technology platform evaluations in the data and analytics space
• Collaborate with cross-functional teams (data engineers, AI engineers, business, solution architects) to translate business requirements into technical solutions aligned with Aviva’s data strategy.
• Ensure data governance, security, and compliance within the Snowflake ecosystem, adhering to regulatory and organizational standards.
What you will need to succeed:
• Extensive experience (8+ years) in data architecture and engineering
• Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS,
• Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from diverse sources.
• Proven experience in DBT to manage and automate complex data transformations within Snowflake, ensuring modular, testable, and version-controlled transformation logic.
• Experience in implementing the lake house solution, Medallion architecture for financial or insurance carriers
• Experience in optimizing and tune Snowflake environments for performance, cost, and scalability, including query optimization and resource management,
• Experience in architecting/lead migration of workloads from Cloudera to Snowflake
• Design Streamlit apps and define new capabilities and data products leveraging snowflake ML and LLOPS capabilities.
• Experience in evaluating the data technology platform including data governance suites, data security products
• Exposure to enterprise Datawarehouse solution like Cloudera, AWS Redshift and informatica tool sets- IDMC, powercenter, BDM
• Develop robust data models and data pipelines to support data transformation, integrating multiple data sources and ensuring data quality and integrity.
• Document architecture, data flows, and transformation logic to ensure transparency, maintainability, and knowledge sharing across teams.
• Strong knowledge of data lifecycle mgmt., data retention, data modelling and working knowledge of cloud computing, and modern development practices.
• Experience with data governance, metadata management, and data quality frameworks (e.g., Collibra, Informatica).
• Experience in converting policy/data conversion from legacy to modern platform
• Deep expertise in Snowflake (Snowpro advanced certification preferred), with hands-on experience delivering Snowflake as an enterprise capability.
• Hands-on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for transformation (preferably deployed on AWS ECS).
• Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java).
• Familiarity with data mesh principles, data product delivery, and modern data warehousing paradigms.
Why Recruit Action?
Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted.
# AVICJP00002818
Opportunity in the insurance industry for a skilled Dara Architect with a proven track record in large-scale data transformation programs, ideally in insurance or financial services.
What is in it for you:
• Salaried: $85-100 per hour.
• Incorporated Business Rate: $100-115 per hour.
• 6-month contract.
• Full-time position: 37.50 hours per week.
• Hybrid model: 3 days per week on-site, subject to change.
Responsibilities:
• Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.
• Migration of the existing Datawarehouse solution to Snowflake
• Technology platform evaluations in the data and analytics space
• Collaborate with cross-functional teams (data engineers, AI engineers, business, solution architects) to translate business requirements into technical solutions aligned with Aviva’s data strategy.
• Ensure data governance, security, and compliance within the Snowflake ecosystem, adhering to regulatory and organizational standards.
What you will need to succeed:
• Extensive experience (8+ years) in data architecture and engineering
• Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS,
• Expertise in design and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake OpenFlow and Apache Airflow for workflow automation, enabling seamless ingestion of different data from diverse sources.
• Proven experience in DBT to manage and automate complex data transformations within Snowflake, ensuring modular, testable, and version-controlled transformation logic.
• Experience in implementing the lake house solution, Medallion architecture for financial or insurance carriers
• Experience in optimizing and tune Snowflake environments for performance, cost, and scalability, including query optimization and resource management,
• Experience in architecting/lead migration of workloads from Cloudera to Snowflake
• Design Streamlit apps and define new capabilities and data products leveraging snowflake ML and LLOPS capabilities.
• Experience in evaluating the data technology platform including data governance suites, data security products
• Exposure to enterprise Datawarehouse solution like Cloudera, AWS Redshift and informatica tool sets- IDMC, powercenter, BDM
• Develop robust data models and data pipelines to support data transformation, integrating multiple data sources and ensuring data quality and integrity.
• Document architecture, data flows, and transformation logic to ensure transparency, maintainability, and knowledge sharing across teams.
• Strong knowledge of data lifecycle mgmt., data retention, data modelling and working knowledge of cloud computing, and modern development practices.
• Experience with data governance, metadata management, and data quality frameworks (e.g., Collibra, Informatica).
• Experience in converting policy/data conversion from legacy to modern platform
• Deep expertise in Snowflake (Snowpro advanced certification preferred), with hands-on experience delivering Snowflake as an enterprise capability.
• Hands-on experience with AWS Glue for ETL/ELT, Apache Airflow for orchestration, and dbt for transformation (preferably deployed on AWS ECS).
• Proficiency in SQL, data modeling, ETL/ELT processes, and scripting languages (Python/Java).
• Familiarity with data mesh principles, data product delivery, and modern data warehousing paradigms.
Why Recruit Action?
Recruit Action (agency permit: AP-2504511) provides recruitment services through quality support and a personalized approach to job seekers and businesses. Only candidates who match hiring criteria will be contacted.
# AVICJP00002818
Required skills
Interested in this position?
Create your free account and tailor your CV to match this job.