Get Started
Hunting for you, 24x7Get the iPhone app

Your hunt runs in your pocket, and tells you the moment a strong match opens.

Download on theApp Store
MiratechPosted 4 days ago

SmartRecruiters

Who we'd reach at MiratechFound and reached by Power Apply
Best leadHiring manager

Leads the team this role joins

Recruiter

In-house, owns the opening

Head of the team

Director or head of the group

Power Apply

From your own Gmail and LinkedIn.

About the role

This is a full-time, hybrid senior data architect role in downtown Toronto, with two days a week in the office, for a lead-level architect who designs enterprise data platforms. The work centres on an APEX data platform that brings together call center telephony and quality data from Genesys and Verint, built on Databricks and Delta Lake, and it includes moving off existing CCARS pipelines through a parallel run. The employer is a global IT services and consulting firm with nearly 1,000 full-time professionals.

What you’ll do

  • Design and implement Bronze/Silver/Gold architecture for Genesys A3S Snowflake and Verint sources.
  • Build Kimball dimensional models with star schemas, conformed dimensions and SCD Type I and II.
  • Build and tune pipelines in Databricks, Delta Lake, PySpark and Spark SQL using incremental loads and checkpoints.
  • Integrate Snowflake, vendor files, SFTP and REST APIs, handling pagination, rate limits and schema drift.
  • Set data quality, reconciliation and audit controls, including deduplication and row count and checksum checks.
  • Own orchestration and recovery with Azure Data Factory or Databricks Workflows.
  • Plan migration cutover and legacy pipeline decommissioning with engineering, QA and business teams.
  • Document the architecture and operating procedures.

What they’re looking for

  • Ten or more years in enterprise data warehousing, data platforms and lakehouse solutions, including five or more years of hands-on Databricks and Delta Lake.
  • Strong Bronze/Silver/Gold, Snowflake integration and Kimball modeling skills.
  • Expert T-SQL and Spark SQL, including query tuning and SQL Server design.
  • Hands-on experience with incremental ingestion, watermarks, idempotency and pipeline recovery.
  • Proven work with REST APIs, flat files, SFTP, reconciliation and high-volume processing.
  • Python and PySpark, plus an orchestration tool such as Azure Data Factory or Databricks Workflows.
  • Familiarity with Azure Databricks, SQL Managed Instance and Azure Key Vault.

Nice to have

  • Genesys Cloud, Genesys A3S or Verint integration experience.
  • Contact center domain knowledge, including telephony, IVR, call routing and quality reporting.
  • Parallel-run migration and cutover planning experience.
  • Data governance, metadata, lineage and cataloging experience.
  • Data observability and pipeline monitoring experience.

What’s on offer

  • Hybrid working, with two days a week in the downtown Toronto office.
  • Health insurance, language courses and a relocation program.
  • Certification programs, mentorship and internal mobility.
  • Work on projects for global clients within an inclusive, multicultural team.

Skills

Questions about this role

Is this role hybrid or remote?

It is hybrid, with two days a week in the downtown Toronto office.

How many years of experience are required?

Ten or more years in data warehousing and data platforms, including five or more with Databricks and Delta Lake.

Which platforms does the role use?

Databricks, Delta Lake, Snowflake, Azure Data Factory and SQL Server, with Genesys and Verint data.