pythonsnowflakedatabrickst sqlazure data factorypysparkdata architecturespark sqldimensional modelingdelta lake
Вакансия из Hirify Global, списка международных tech-компаний Для мэтча и отклика нужен Plus
Пожаловаться
Зарплата и рынок
ЗП не указанаразвернуть
На похожих ролях по рынку
$98к$119кмедиана$146к
49 в выборке
На СНГ рынке: $3.8к/мес ($3к - $5.6к)
80
Хорошая вакансия
развернуть
Роль дает понятную ответственность за крупную платформу данных, но сочетает архитектуру с большим объемом практической разработки и поддержки пайплайнов, поэтому стоит уточнить нагрузку и поддержку команды.
Широкий охват
Актуальный стек
Поддержка развития
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Подключить Plus
Описание вакансии
Текст:
Hirify AI/Оригинал
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 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, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →