- Extensive experience (8+ years) in data architecture and engineering, with a proven track record in large-scale data transformation programs, ideally in insurance or financial services.

- Proven experience in architecting and implementing advanced data solutions using Snowflake on AWS.

- Expertise in designing and orchestrating data acquisition pipelines using AWS Glue for ETL/ELT, Snowflake Openflow, and Apache Airflow for workflow automation, enabling seamless ingestion of data from diverse sources.

- Proven experience with dbt to manage and automate complex data transformations within Snowflake, ensuring modular, testable, and version-controlled transformation logic.

- Experience implementing Lakehouse solutions and Medallion Architecture for financial or insurance carriers.

- Experience optimizing and tuning Snowflake environments for performance, cost, and scalability, including query optimization and resource management.

- Experience in architecting and/or leading migration of workloads from Cloudera to Snowflake.

- Experience designing Streamlit applications and defining current capabilities and data products leveraging Snowflake ML and LLMOps capabilities.

- Experience evaluating data technology platforms, including data governance suites and data security products.





- Exposure to enterprise Data Warehouse solutions such as Cloudera and AWS Redshift, as well as Informatica toolsets, including IDMC, PowerCenter, and BDM.

- Ability to develop robust data models and data pipelines to support data transformation, integrating multiple data sources while ensuring data quality and integrity.

- Ability to document architecture, data flows, and transformation logic to ensure transparency, maintainability, and knowledge sharing across teams.

- Strong knowledge of data lifecycle management, data retention, and data modeling, along with working knowledge of cloud computing and modern development practices.

- Experience with data governance, metadata management, and data quality frameworks, such as Collibra and Informatica.

- Experience in converting policy/data from legacy platforms to modern platforms.

- 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 such as Python/Java.

📌 AWS Snowflake Architect (Markham)
🏢 VBeyond
📍 Markham