Senior Data Architect - Databricks, Snowflake, Kimball

About the role

Miratech is hiring a Senior Data Architect in Toronto to design and implement the end-to-end data platform for APEX, integrating call center telephony and quality data from the Genesys A3S Snowflake database and Verint Workforce Management feeds. The role builds a scalable, reliable and auditable architecture using Databricks, Delta Lake and a Bronze/Silver/Gold (Medallion) pattern, with a Kimball-style dimensional reporting layer. It suits a Senior or Lead Data Architect with strong technical ownership, and is a hybrid role with two days per week in a downtown Toronto office.

Key responsibilities

• Design and implement the Bronze/Silver/Gold architecture for Genesys A3S Snowflake and Verint data sources, covering ingestion, transformation, validation and consumption.
• Develop dimensional data models using Kimball principles (star schemas, fact and dimension tables, grain, conformed dimensions, SCD Type I/II) for sales, telephony, agent activity, quality and operational reporting.
• Build and optimize scalable pipelines with Databricks, Delta Lake, Python, PySpark, Spark SQL and T-SQL, using incremental loading, watermarks, checkpoints, ACID transactions, partitioning and query optimization.
• Integrate Snowflake sources, flat files, SFTP transfers and REST APIs with secure connectivity, pagination, rate-limit handling, asynchronous processing, schema evolution and source-to-target reconciliation.
• Set up data quality, integrity and audit controls, including deduplication, referential integrity, row counts, checksums, late-arriving data handling and detection of data drift and schema changes.
• Design orchestration, monitoring and recovery processes with Azure Data Factory, Databricks Workflows or equivalent, and support high-volume processing and production troubleshooting.
• Collaborate with the CCARS pipeline team and stakeholders to validate migrations, plan cutovers, decommission legacy pipelines and document architecture and procedures.

Required profile

• 10+ years in enterprise data warehousing, data platforms and lakehouse solutions, including 5+ years of hands-on Databricks and Delta Lake experience.
• Strong expertise in Bronze/Silver/Gold architecture, Snowflake integration, Kimball modeling, star schemas and SCD Type I/II.
• Expert T-SQL and Spark SQL, including complex transformations, query optimization, SQL Server design, indexing and partitioning.
• Hands-on experience with Delta Lake, incremental ingestion, watermarks, checkpoints, idempotency, retries and pipeline recovery.
• Proven experience with REST APIs, flat files, SFTP, data quality, reconciliation, schema drift and high-volume processing.
• Nice to have: Genesys Cloud/A3S and Verint experience, contact center domain knowledge, parallel-run migration experience, data governance and observability familiarity.

Required skills

• Databricks, Delta Lake, Snowflake, Azure Data Factory, Databricks Workflows
• T-SQL, Spark SQL, Python, PySpark
• Azure Databricks, SQL Managed Instance, Azure Key Vault

What we offer

• Health insurance, language courses and a relocation program
• Remote work flexibility
• Certification programs, mentorship, internal mobility and internship opportunities
• Inclusive multicultural environment and team-building events