{bc}
Apply
smartrecruiters

Senior Data Architect

Miratech
Toronto, CAN
Full-time
Senior · 10+ years experience
Hybrid
Discovered 3 days ago
SQLPythonAzure

Full Job Posting

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.

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.
  • Miratech helps visionaries change the world. We are a global IT services and consulting company that brings together enterprise and start-up innovation. Today, we support digital transformation for some of the world's largest enterprises. By partnering with both large and small players, we stay at the leading edge of technology, remain nimble even as a global leader, and create technology that helps our clients further enhance their business. We are a values-driven organization, and our culture of Relentless Performance has enabled over 99% of Miratech's engagements to succeed by meeting or exceeding our scope, schedule, and/or budget objectives since our inception in 1989.
  • Miratech has coverage across 5 continents and operates in over 25 countries around the world. Miratech retains nearly 1000 full-time professionals, and our annual growth rate exceeds 25%.

Qualifications

  • 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.
  • 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.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Miratech

Senior Full Stack Java Engineer - Workforce Management (WFM)

, USA

Discovered TodayFull-time

Senior Full Stack Java Engineer - Workforce Management (WFM)

, CAN

Discovered TodayFull-time

Senior Java Full Stack Developer

Toronto, CAN

Discovered TodayFull-time

Senior Java Full Stack Developer

, CAN

Discovered TodayFull-time

Senior Genesys Cloud PS Consultant (Genesys AI experience)

Calgary, CAN

Discovered TodayFull-time

Information Scientist

Toronto, CAN

Discovered TodayFull-time

Information Scientist

Montréal, CAN

Discovered TodayFull-time

Senior Genesys Cloud PS Consultant (Genesys AI experience)

Montréal, CAN

Discovered TodayFull-time