Назад
Company hidden
24 дня назад

Senior Data Architect (Databricks)

Формат работы
hybrid
Тип работы
fulltime
Грейд
senior/lead
Английский
b2
Страна
Canada
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Senior Data Architect (Databricks): Design and build an end-to-end data platform for contact centre telephony, workforce management, sales, agent activity, and quality reporting with an accent on Medallion architecture, Kimball dimensional modeling, and reliable multi-source ingestion. Focus on optimizing Databricks and Delta Lake pipelines, handling API and vendor-feed complexity, enforcing reconciliation and failure-recovery patterns, and migrating from legacy CCARS pipelines.

Location: Hybrid, 2 days per week in a downtown Toronto office, North York, Ontario, Canada.

Company

hirify.global is a global IT services and consulting company supporting digital transformation for large and small enterprises across more than 25 countries.

What you will do

  • Design the Bronze/Silver/Gold data platform for Genesys A3S Snowflake and Verint Workforce Management data, covering ingestion, transformation, validation, and consumption.
  • Own source-specific ingestion cadence, watermarking, incremental extraction, batch control, reconciliation, data integrity, idempotency, and late-arriving data handling.
  • Design the Gold-layer Kimball star schema for sales, telephony, agent activity, and quality reporting, including facts, dimensions, grain, and SCD Type I/II.
  • Build and optimize Databricks and Delta Lake pipelines, including cluster sizing, job versus all-purpose compute, Photon, performance, and cost practices.
  • Integrate Snowflake sources, flat files, SFTP drops, REST APIs, and vendor feeds while handling schema drift, pagination, rate limits, asynchronous jobs, and per-entity fan-out.
  • Design orchestration with Azure Data Factory, Databricks Workflows, or equivalent; document architectural trade-offs and partner on parallel-run validation, cutover, and legacy CCARS decommissioning.

Requirements

  • 10+ years of experience designing data warehouse and lakehouse solutions.
  • 5+ years of hands-on experience with Databricks/Delta Lake and Snowflake or API-driven ingestion.
  • Deep hands-on expertise in Kimball star schemas, fact and dimension design, grain definition, and SCD Type I/II.
  • Proven experience designing Medallion architectures and evaluating pure lakehouse versus hybrid lakehouse-to-data-warehouse designs.
  • Strong Delta Lake expertise, including Delta tables, ACID transactions, Z-ordering, OPTIMIZE, VACUUM, and Databricks workload tuning at scale.
  • Expert-level T-SQL and Spark SQL, including complex joins, window functions, query tuning, indexing, and partitioning.
  • Deep knowledge of relational databases, preferably SQL Server, and OLTP versus OLAP design.
  • Experience enforcing referential integrity, deduplication, reconciliation, checksum/hash validation, and upstream schema-drift detection.
  • Experience with REST API ingestion, external Snowflake sources, vendor exports, high-volume pipelines, backpressure, retry, failure isolation, Azure Data Factory or Databricks Workflows, Python or PySpark, and Azure services including Databricks, ADF, SQL Managed Instance, and Key Vault.
  • Strong communication skills for documenting decisions and explaining trade-offs to technical and business audiences.

Nice to have

  • Experience with Genesys Cloud, Genesys A3S, or Verint data models.
  • Contact centre or telephony domain knowledge, including call detail records, agent activity, quality evaluations, IVR, and routing.
  • Experience running parallel-run migration strategies with legacy and new systems live during cutover.
  • Experience with enterprise schedulers such as AutoSys.

Culture & Benefits

  • Culture focused on relentless performance and high project success.
  • Competitive compensation and benefits, including health insurance and a relocation program.
  • Remote-work flexibility within a hybrid role.
  • Professional development through certification programs, mentorship, talent investment, and internal mobility opportunities.
  • Global, multicultural, inclusive, and supportive environment with regular team-building events.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →