Senior Enterprise Data Architect

2 weeks ago

Markham, Ontario, Canada Logic Horizon Inc Full time $120,000 - $180,000 per year

The purpose of the Data Architect role is to:

  • Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.
  • Migration of the existing Data Warehouse 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 the organization's data strategy.
  • Ensure data governance, security, and compliance within the Snowflake ecosystem, adhering to regulatory and organizational standards.

Experience and Capabilities:

  • 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 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 tuning Snowflake environments for performance, cost, and scalability, including query optimization and resource management.
  • Experience in architecting/leading 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 solutions 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 management, data retention, data modeling, 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.

Job Type: Fixed term contract

Contract length: 6 months

Pay: $100.00-$105.00 per hour

Expected hours: 37.5 per week

Experience:

  • Data Architecture: 3 years (required)
  • Working with Data Migration projects: 2 years (required)
  • Snowflake: 2 years (required)
  • Insurance Domain: 3 years (required)

Work Location: Hybrid remote in Markham, ON

  • Senior Enterprise Data Architect

    2 weeks ago

    Markham, Ontario, Canada Logic Horizon inc Full time $120,000 - $180,000 per year

    Role Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing Data Warehouse solution to Snowflake.Technology platform evaluations in the data and analytics space.Collaborate with cross-functional...

  • Senior Data Architect

    2 weeks ago

    Markham, Ontario, Canada Entellux Full time $120,000 - $180,000 per year

    Position:Data ArchitectLocation:MarkhamMode of Work : Hybrid (3 days a week)Role Overview :Must have skills:Data architectureSnowflakeData governanceRole Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of...

  • Data Architect

    1 week ago

    Markham, Ontario, Canada TechDoQuest Full time $120,000 - $180,000 per year

    Role Overview :We are seeking aData Architectwith 8+ years of experience.Must have skills:Data architectureSnowflakeData governanceRole Purpose:The purpose of the Data Architect role is to:Architect and implement advanced data solutions using Snowflake on AWS, ensuring scalable, secure, and high-performance data environments.Migration of the existing...

  • Snowflake Data Architect

    6 days ago

    Markham, Ontario, Canada Galent Full time $120,000 - $200,000 per year

    Job descriptionSnowflake Data ArchitectLocation Markham Ontario CAWorking model Hybrid 3 days Work From Office 2 days mandatory Tue Wed 1 day flexible any day from Mon Thu FriPrimary SkillsArchitect and implement advanced data solutions using Snowflake on AWS ensuring scalable secure and highperformance data environmentsExtensive experience 8 years in data...

  • Enterprise Master Data Lead

    2 weeks ago

    Markham, Ontario, Canada Riverside Natural Foods Ltd. Full time $80,000 - $120,000 per year

    As Riverside Natural Foods continues its data transformation journey, we are expanding our Master Data & Analytics team by adding a Master Data Lead. Master Data is the Key. This critical role will support and enhance our SAP-based Master Data Governance framework by proactively maintaining high standards of data integrity, accuracy, and consistency across...

  • Co-op Student – Enterprise Data Services

    13 hours ago

    Markham, Ontario, Canada Aviva Full time $60,000 - $80,000 per year

    Co-op Student – Enterprise Data ServicesLocation: Markham (Hybrid – minimum 3 days/week in office)Terms: January–April, May–August, September–December Individually we are people, but together we are Aviva.Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence.At Aviva Canada, one of the...

  • Senior Data Engineer

    1 week ago

    Markham, Ontario, Canada Randstad Digital Full time $120,000 - $180,000 per year

    Lead Data Engineer, FT Perm positionNumber of Positions: 1Location: Markham, ON, CAMust be eligible to work in CanadaHybrid role 3d/w onsite, at least 1d/w in Markham, and 2d/w in TorontoRoles and responsibilities:This role will be responsible for leading the architecture, high level and low-level solution engineering design, analysis, and implementation in...

  • Senior Architect

    9 hours ago

    Markham, Ontario, Canada Morson Edge (Canada) Full time $80,000 - $120,000 per year

    Location:North York, ON – HybridContract Duration:12 months, with possibility of extensionWorking Hours:Monday–Friday, 35 hours per weekAdditional Requirement:Consultants must use their own personal computersJob Title:Senior ArchitectOverviewThe Senior Architect plays a key leadership role within the Architectural Design Section, overseeing project teams...

  • Data Engineer

    6 days ago

    Markham, Ontario, Canada Recutify Inc. Full time $120,000 - $180,000 per year

    Position-: Data EngineerLocation: Markham,ONPosition: Full time/SubconMode: Hybrid (Mandatorily need to visit office 3 days a week)This role will be part of and a member of our Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, high level and low-level solutionengineering design, analysis, and...

  • Senior Analytics Data Engineer

    1 week ago

    Markham, Ontario, Canada Enercare Inc. Full time $120,000 - $180,000 per year

    **Proudly Canadian-owned, Enercare is committed to providing the best services, solutions and advice to make customer's homes as comfortable as they can be. With Enercare Advantage, we provide affordable clean air and water solutions for homes and workplaces. We are committed to operating in an environmentally responsible way, including keeping as much waste...