We are looking for a Senior Data Architect 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 (WFM) feeds. The role will focus on building a scalable, reliable, and auditable data architecture using Databricks, Delta Lake, and a Bronze/Silver/Gold (Medallion) architecture, delivering curated data through a Kimball-style dimensional reporting layer.
The ideal candidate combines deep hands-on expertise in data warehouse modeling, lakehouse architecture, SQL, and production-grade data ingestion with the ability to make sound architectural decisions around data quality, performance, scalability, and operational resilience. You will define ingestion strategies, incremental loading patterns, batch controls, and data integrity standards while supporting the transition from existing CCARS pipelines to the new platform through a controlled parallel-run and decommissioning process.
This role is suited to a Senior or Lead Data Architect with strong technical ownership who can translate complex business and reporting requirements into robust data solutions and clearly communicate architectural decisions to both engineering teams and business stakeholders.
Working Model: This is a hybrid role requiring 2 days per week in a downtown Toronto office.
Responsibilities:
- Design and implement end-to-end Bronze/Silver/Gold data architecture for Genesys A3S Snowflake and Verint data sources, including data ingestion, transformation, validation, and consumption.
- Develop dimensional data models using Kimball principles, including star schemas, fact and dimension tables, grain definition, conformed dimensions, and SCD Type I/II, supporting sales, contact center telephony, agent activity, quality evaluations, and operational reporting.
- Build and optimize scalable data pipelines using Databricks, Delta Lake, Python, PySpark, Spark SQL, and T-SQL, applying incremental loading, watermarks, checkpoints, ACID transactions, partitioning, Z-ordering, and query optimization.
- Integrate Snowflake sources, vendor flat files, SFTP transfers, and REST APIs, implementing secure connectivity, pagination, rate-limit handling, asynchronous processing, schema evolution, data normalization, and source-to-target reconciliation.
- Establish data quality, integrity, and audit controls, including deduplication, referential integrity, row counts, checksum/hash comparisons, late-arriving data handling, and detection and remediation of missing records, data drift, and schema changes.
- Design and maintain reliable orchestration, monitoring, and recovery processes using Azure Data Factory, Databricks Workflows, or equivalent tools; optimize pipeline performance, scalability, and cost while supporting high-volume processing and production troubleshooting.
- Collaborate with the CCARS pipeline team and engineering, reporting, QA, and business stakeholders to validate migrations, plan cutovers, decommission legacy pipelines, document architecture and operational procedures, and ensure functional, performance, security, and reliability requirements are met.
- 10+ years of experience 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 dimensional modeling, star schemas, and SCD Type I/II.
- Expert-level T-SQL and Spark SQL skills, including complex transformations, query optimization, SQL Server database design, indexing, and partitioning.
- Hands-on experience with Delta Lake, incremental ingestion, watermarks, checkpoints, idempotency, retries, and pipeline recovery.
- Proven experience with REST APIs, vendor flat files, SFTP, data quality, reconciliation, schema drift, and high-volume data processing.
- Proficiency in Python/PySpark and orchestration tools such as Azure Data Factory, Databricks Workflows, or equivalent platforms.
- Familiarity with Azure Databricks, SQL Managed Instance, and Azure Key Vault, with strong skills in production support, performance optimization, technical documentation, and stakeholder collaboration.
Nice to have:
- Experience with Genesys Cloud, Genesys A3S, Verint, and related data integrations.
- Contact center domain knowledge, including telephony, IVR, call routing, agent activity, WFM, and quality reporting.
- Experience with parallel-run migrations, legacy system validation, and cutover planning.
- Familiarity with data governance, metadata, lineage, and data cataloging.
- Experience with data observability, pipeline monitoring, and data quality controls.
- Knowledge of Databricks and Delta Lake optimization, enterprise scheduling, and production support in multi-source environments.
We offer:
- Culture of Relentless Performance: join an unstoppable technology development team with a 99% project success rate and more than 30% year-over-year revenue growth.
- Competitive Pay and Benefits: enjoy a comprehensive compensation and benefits package, including health insurance, language courses, and a relocation program.
- Work From Anywhere Culture: make the most of the flexibility that comes with remote work.
- Growth Mindset: reap the benefits of a range of professional development opportunities, including certification programs, mentorship and talent investment programs, internal mobility and internship opportunities.
- Global Impact: collaborate on impactful projects for top global clients and shape the future of industries.
- Welcoming Multicultural Environment: be a part of a dynamic, global team and thrive in an inclusive and supportive work environment with open communication and regular team-building company social events.
- Social Sustainability Values: join our sustainable business practices focused on five pillars, including IT education, community empowerment, fair operating practices, environmental sustainability, and gender equality.
* Miratech is an equal opportunity employer and does not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status under applicable law.