Principal Data Engineer – Databricks

Tata Consultancy Services; Toronto; On-site; CAD 90,000 - 110,000; Full time

Job summary

Tata Consultancy Services Canada Inc. is seeking an expert in enterprise data platforms to lead the transformation from Cloudera to Databricks Lakehouse.

You will design scalable data warehouse and lakehouse architectures, govern data flows, and enable governance and reporting across finance, risk, and analytics teams. Strong experience with Databricks, Spark, Delta Lake, and Python-based ETL is required, along with cloud exposure (AWS/Azure) and CI/CD tooling.

Qualifications

• Experience with enterprise Data Warehouse and Data Lake platforms.
• Hands-on Databricks and Spark at scale.
• Modernizing Cloudera to Databricks Lakehouse.
• Ingestion/transformation patterns to cloud object storage/Delta Lake.
• Refactor Hive/Impala logic to PySpark and Spark SQL ELT pipelines.
• Data reconciliation and audit integrity during migration.
• Design and govern enterprise data architectures across layers.

Responsibilities

• Lead Cloudera to Databricks transformation initiatives.
• Shape enterprise finance and risk data platforms.
• Support regulatory, management, and analytical reporting systems.

Skills

Databricks

Spark

Delta Lake

PySpark

Data Warehouse

Data Lake

Data governance

Cloud platforms

dbt

Finance data models

Tools

Databricks Workflows

Airflow

Git

Terraform

Jenkins

Azure DevOps

dbt

SAP Finance

Oracle Financials

S/4HANA

Job description

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

TCS has been serving the Canadian marketplace for more than 35 years and today is the technology partner of choice for many of the country's leading organizations. As one of the largest IT services providers in Canada and globally, TCS is aiming to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage and values of the Tata Group, TCS is focused on creating long-term value for its clients, investors, employees, and the communities it serves. With a highly skilled workforce supporting customers from coast to coast, TCS has consistently been recognized as a Top Employer by the Top Employers Institute, including a recent top ranking at the country level.

TCS also sponsors 14 of the world's most prestigious marathons and endurance events, including the TCS Toronto Waterfront Marathon, reflecting its commitment to health, sustainability, and community empowerment.

Key Requirements

• Years of experience in enterprise Data Warehouse and Data Lake platforms
• Hands-on experience with Databricks and Spark at scale
• Strong experience in modernizing legacy Cloudera platforms (CDH/CDP, Hive, HBase, Impala, Spark) to Databricks Lakehouse
• Redesign ingestion, transformation, and consumption patterns from HDFS-based architecture to cloud object storage and Delta Lake
• Refactor legacy Hive/Impala logic into PySpark and Spark SQL ELT pipelines
• Ensure data reconciliation, audit integrity, and consistency during migration
• Design and govern enterprise Data Warehouse and Data Lake/Lakehouse architectures
• Implement layered architecture including Raw/Landing, Curated/Conformed, and Semantic/Consumption layers
• Modernize traditional EDW platforms into scalable lakehouse architectures
• Strong experience in finance and risk data models including General Ledger, Sub-ledger, financial hierarchies, and risk exposure models (credit, liquidity, market risk)
• Enable reporting use cases including aggregation, drill-down, and drill-back capabilities
• Build and manage semantic/consumption layers for BI, reporting, and analytics
• Define business metrics, dimensions, hierarchies, and KPIs
• Experience with Databricks SQL, Delta tables, and dbt or similar frameworks
• Develop and optimize large-scale data pipelines using PySpark, Spark SQL, and Delta Lake
• Implement Medallion architecture (Bronze, Silver, Gold layers)
• Optimize workloads using Z-ORDER, OPTIMIZE, caching, and cluster configurations
• Implement data governance, data quality frameworks, reconciliation controls, and exception handling
• Establish data lineage and metadata management
• Ensure data security, access control, and compliance standards
• Experience with cloud platforms such as AWS or Azure
• Experience with CI/CD pipelines using Git, Terraform, Jenkins, or Azure DevOps
• Familiarity with orchestration tools such as Airflow or Databricks Workflows
• Experience with dbt is a plus
• Act as a technical authority and lead architecture decisions
• Mentor and guide senior engineers and establish engineering standards
• Strong stakeholder management with finance, risk, analytics, and governance teams
• Ability to translate complex data structures into business-ready insights

Nice to Have

• Experience in BFSI, Capital Markets, or regulatory reporting
• Exposure to SAP Finance, Oracle Financials, or S/4HANA
• Experience supporting AI/ML workloads
• Databricks or cloud certifications

Impact

• Lead Cloudera to Databricks transformation initiatives
• Shape enterprise finance and risk data platforms
• Support regulatory, management, and analytical reporting systems

Salary Range - CA$ 90,000 - CA$ 110,000 Per Year

Tata Consultancy Services Canada Inc. is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC). Should you require accommodation during the recruitment and selection process, please inform Human Resources.