Senior Data Architect

Job#: 3051853

Job Description:

Senior Data Architect

• Location: Hybrid Toronto
• Job Type: Contract
• Experience Level: Senior / Lead (10+ Years)

About the Role

• Apex Systems is seeking a highly experienced Senior Data Architect to lead the design and implementation of a modern enterprise data platform supporting contact center analytics, workforce management, and operational reporting. This role will be responsible for architecting end-to-end data solutions that ingest data from Genesys A3S Snowflake environments, Verint workforce management platforms, and other enterprise sources into a scalable Databricks Lakehouse architecture leveraging Bronze, Silver, and Gold data layers.
• The ideal candidate brings deep expertise in dimensional modeling, Databricks, SQL, and large-scale data integration, with a proven ability to design highly resilient, auditable, and performance-optimized data platforms.

Key Responsibilities

Data Architecture & Strategy

• Design and implement enterprise-scale data architectures utilizing Medallion (Bronze, Silver, Gold) patterns.
• Define data ingestion, transformation, storage, and reporting strategies across multiple source systems.
• Architect a Kimball-based dimensional reporting layer including fact and dimension models.
• Establish scalable standards for data governance, integrity, lineage, and auditing.
• Document technical decisions, architecture patterns, and trade-offs for technical and business stakeholders.

Data Platform Development

• Design ingestion frameworks for: Genesys A3S Snowflake data sourcesVerint workforce management feedsREST APIsSFTP and flat-file integrations
• Develop strategies for incremental loading, watermarking, change tracking, and idempotent processing.
• Define data freshness requirements and ingestion cadences across source systems.
• Design solutions that support both operational and analytical workloads.

Databricks & Lakehouse Leadership

• Lead architecture and design of Databricks and Delta Lake environments.
• Build scalable Bronze, Silver, and Gold transformation frameworks.
• Optimize performance through: Cluster sizing strategiesPhoton optimizationDelta Lake maintenancePartitioning strategiesZ-orderingCost optimization techniques
• Establish best practices for workload orchestration and monitoring.

Data Quality & Governance

• Design and implement validation frameworks including: Row count reconciliationChecksum validationReferential integrity enforcementDuplicate detectionLate-arriving data management
• Define controls for schema drift detection and upstream vendor changes.
• Create audit frameworks that support operational transparency and compliance requirements.

Collaboration & Stakeholder Engagement

• Partner closely with engineering teams, analytics teams, business stakeholders, and third-party vendors.
• Support parallel-run migration activities between legacy and future-state platforms.
• Guide development teams on architecture standards and implementation approaches.
• Act as the subject matter expert for enterprise data architecture initiatives.

Required Qualifications

Data Architecture & Modeling

• 10+ years of experience designing enterprise data warehouse and lakehouse solutions.
• Deep expertise in: Kimball dimensional modelingStar schema designFact and dimension modelingGrain definitionSlowly Changing Dimensions (Type I and II)
• Strong experience designing Medallion data architectures.

Databricks & Delta Lake

• 5+ years of hands-on Databricks experience.
• Expert knowledge of: Delta LakeDelta TablesACID transactionsOptimize and Vacuum operationsMedallion architecture implementationPerformance tuning and workload optimization

SQL & Databases

• Expert-level proficiency in: T-SQLSpark SQLQuery tuningWindow functionsAdvanced joinsPartitioning strategies
• Strong experience with SQL Server architecture and optimization.
• Deep understanding of OLTP versus OLAP design methodologies.

Data Integration & Engineering

• Experience designing and implementing large-scale data ingestion frameworks.
• Advanced knowledge of: REST APIsPagination and rate limitingAsynchronous processing patternsHigh-volume data pipelinesIncremental data loading

Programming & Cloud Technologies

• Strong hands-on experience with: PythonPySparkAzure Data FactoryDatabricks WorkflowsAzure SQL Managed InstanceAzure Key Vault
• Experience with enterprise scheduling and orchestration tools.

Data Quality & Integrity

• Proven track record implementing enterprise-grade: Reconciliation processesData validation frameworksAudit controlsData lineage solutionsSchema drift monitoring

Preferred Qualifications

• Experience working with Genesys Cloud or Genesys A3S data platforms.
• Experience with Verint workforce management and quality monitoring data.
• Contact center and telephony domain expertise, including: Call Detail Records (CDRs)Agent performance analyticsIVR and routing dataQuality evaluation metrics
• Experience supporting large-scale migration and parallel-run initiatives.
• Familiarity with sales analytics and workforce reporting environments.

Success Metrics

• Within this role, you will successfully:
• Design a scalable Bronze/Silver/Gold architecture for Genesys and Verint integrations.
• Deliver robust ingestion frameworks with reliable watermarking and recovery mechanisms.
• Implement Gold-layer dimensional models supporting enterprise reporting and analytics.
• Establish data quality processes that ensure accuracy, reliability, and auditability.
• Partner effectively with stakeholders throughout migration, parallel-run, and platform modernization initiatives.

Apex pay scales are determined by role, experience, skill set, and location. For this new position, the estimated hourly range is provided below as a guideline; however, total compensation may vary based on individual circumstances.

Hourly Range: $$

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.

Everforth Apex Benefits Overview: In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA.