Senior Data Architect

At Staffworxs, we don't just connect talent — we power transformation. Headquartered in Frisco, TX, with teams in Bengaluru and Hyderabad, we combine global reach with deep expertise. Our Digital & Data Analytics practice drives growth and innovation for some of the world's top brands, who continue to retain us as their trusted partner. If you're ready to make an impact, you're in the right place.

Job Details:

Job Title: Data Architect (Azure & Databricks Technology Stack)

Location: Toronto, ON (Hybrid)

Duration: Long term Contract

Tech Stack:
Azure Services, Databricks, SQL, Data Lake, Lakehouse, and Azure Synapse

Position Summary

We are seeking a highly skilled Data Architect with deep expertise in Azure, Databricks, SQL, and Data Modeling. The ideal candidate will have extensive experience in both traditional data warehouse architectures and modern data platform paradigms (Data Lake, Lakehouse, and Azure Synapse). This role requires a proven track record in designing and implementing enterprise-scale data solutions, integrating multiple data sources, and enabling analytics at scale.

Key Responsibilities

Architecture & Design

• Lead the architecture, design, and implementation of enterprise data warehouses, data lakes, and lakehouses on Azure and Databricks.
• Define and enforce data modeling standards, best practices, and guidelines across transactional and analytical workloads.
• Architect end-to-end modern data platforms leveraging Azure Synapse, Databricks, Delta Lake, and related Azure services (ADF, ADLS, Purview, etc.).

Solution Delivery

• Design scalable ETL/ELT pipelines and orchestrate workflows for ingestion, transformation, and consumption.
• Partner with business stakeholders, product teams, and data engineers to deliver high-quality, business-driven data solutions.
• Ensure solutions are secure, performant, and compliant with enterprise governance and regulatory standards.

Strategy & Leadership

• Define data strategy and reference architecture for modernization from legacy/traditional data platforms (Teradata, Oracle, SQL Server, etc.) to modern architectures.
• Provide technical leadership and mentoring to engineering teams.
• Collaborate with cloud, analytics, and business teams to align data architecture with organizational goals.

Required Skills & Experience

Core Expertise

• Proven experience as a Data Architect or Senior Data Engineer/Lead designing and implementing enterprise data warehouses and modern data platforms.
• Hands-on expertise with Azure services: Azure Synapse Analytics (Dedicated SQL Pools, Serverless Pools), Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), Azure Purview.
• Strong expertise with Databricks: Delta Lake, Lakehouse, Spark (PySpark/Scala), MLflow.
• Very strong SQL development and optimization skills.
• Strong data modeling (3NF, Dimensional, Data Vault, Canonical Models, etc.).

Complementary Skills

• Knowledge of traditional data platforms (Oracle, Teradata, SQL Server, Informatica, etc.) along with modern ELT/ETL frameworks.
• Solid understanding of data governance, metadata management, data quality, and security.
• Experience in building real-time/streaming data pipelines (Kafka, Event Hub, etc.) is a plus.

Soft Skills

• Excellent communication and ability to engage with business SMEs and senior stakeholders.
• Strong analytical and problem-solving skills with an enterprise-scale mindset.
• Experience in mentoring and guiding teams on modern data practices.

Qualifications

• Bachelor's/Master's degree in Computer Science, Information Systems, or related field.
• 15+ years of experience in Data Engineering/Architecture, with at least 5+ years in Azure & Databricks ecosystem.
• Proven track record in enterprise-scale data warehouse and lakehouse implementations.
• Certifications in Azure Data Engineer/Architect or Databricks preferred.

Staffworxs is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive workplace for all employees, regardless of race, color, religion, gender, sexual orientation, national origin, age, disability, or veteran status.