Inclusion without Exception
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.
Tata Consultancy Services (BSE: 532540, NSE: TCS) is the technology partner of choice for industry-leading organizations worldwide. Since its inception in 1968, TCS has upheld the highest standards of innovation, engineering excellence and customer service.
It has set an aspiration 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 of the Tata Group, TCS is focused on creating long term value for its clients, its investors, its employees, and the community at large. With a highly skilled workforce spread across 56 countries and 194 service delivery centers across the world, the company has been recognized as a top employer in six continents. With the ability to rapidly apply and scale new technologies, the company has built long term partnerships with its clients. Many of these relationships have endured into decades and navigated every technology cycle, from mainframes in the 1970s to artificial intelligence today.
Data Modeler
Key Requirements
Lead experience in enterprise Data Warehouse and Data Lake platforms
Hands-on experience with Databricks and Spark at scale
Lead modernization of Cloudera platforms (CDH/CDP, Hive, HBase, Impala, Spark) to Databricks Lakehouse
Redesign ingestion, transformation, and consumption patterns from HDFS to cloud object storage and Delta Lake
Refactor Hive/Impala logic into PySpark/Spark SQL ELT pipelines
Ensure data reconciliation, audit integrity, and parity during migration
Design and implement enterprise Data Warehouse and Data Lake/Lakehouse architectures
Implement layered architecture (Raw/Landing, Curated/Conformed, Semantic/Consumption layers)
Modernize traditional EDW to scalable lakehouse architecture
Experience with finance and risk data models including General Ledger, Sub-ledger, financial hierarchies, and risk models
Enable reporting capabilities including aggregation, drill-down, and drill-back
Build semantic and consumption layers for BI, analytics, and reporting
Define business metrics, KPIs, dimensions, and hierarchies
Experience with Databricks SQL, Delta tables, and dbt or similar tools
Develop large-scale data pipelines using PySpark, Spark SQL, and Delta Lake
Implement Medallion architecture (Bronze/Silver/Gold)
Optimize Databricks workloads using techniques such as Z-ORDER, OPTIMIZE, caching, and cluster policies
Implement data quality, reconciliation, and exception handling frameworks
Establish data lineage and metadata management using Unity Catalog
Ensure data security, access control, and compliance
Act as technical authority and lead architecture decisions
Mentor engineers and establish data engineering standards
Required Skills
Expertise in Cloudera platforms (CDH/CDP)
Strong experience in Cloudera to Databricks migration
Deep knowledge of Data Warehousing and Data Lakes
Strong experience in finance and risk data models
Experience building semantic and consumption layers
Expert-level Databricks, PySpark, Spark SQL, and SQL
Experience with cloud platforms AWS or Azure
Familiarity with CI/CD tools (Git, Terraform, Jenkins/Azure DevOps)
Experience with orchestration tools (Airflow, Databricks Workflows)
Experience with dbt is a plus
Strong stakeholder management with Finance, Risk, and Analytics teams
Ability to translate complex data into business outcomes
Good 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
Contribute to regulatory, executive, and analytical decision-making
Salary Range: CAD$90,000 - CAD$110,000
TCS does not use artificial intelligence tools for candidate screening or evaluation. This post is for a current vacancy. The hiring process includes an initial screening, followed by a technical evaluation and managerial discussion.
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.
Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.
