Data Modeler

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. TCS is an IT services, consulting, and business solutions organization that has been partnering with many of the world’s largest businesses in their transformation journeys for over 55 years. Its consulting-led, cognitive-powered portfolio of business, technology, and engineering services and solutions is delivered through its unique Location Independent Agile™ delivery model, recognized as a benchmark of excellence in software development. A part of the Tata group, India's largest multinational business group, TCS operates in 55 countries and employs over 607,000 highly skilled individuals, including more than 10,000 in Canada. The company generated consolidated revenues of US $30 billion in the fiscal year ended March 31, 2025, and is listed on the BSE and the NSE in India. TCS' proactive stance on climate change and award-winning work with communities across the world have earned it a place in leading sustainability indices such as the MSCI Global Sustainability Index and the FTSE4 Good Emerging Index. We are seeking an experienced Senior Data Analyst / Data Modeler with strong expertise in data modeling, SQL, data analysis, and capital markets domain knowledge. The ideal candidate will have 7-10 years of experience designing and maintaining enterprise data models, profiling complex datasets, supporting data quality initiatives, and collaborating with business and technology stakeholders across capital markets programs. This role requires a strong understanding of trade lifecycle processes, financial market participants, asset classes, and associated risks, along with the ability to translate business requirements into scalable data structures that support reporting, analytics, and operational processes. Key Responsibilities Design, develop, and maintain conceptual, logical, and physical data models supporting enterprise data initiatives. Create and enhance data models using industry-standard approaches including: Star Schema Snowflake Schema Hybrid Data Models Fact and Dimension Modeling Analyze business requirements and translate them into scalable data structures and data flows. Perform data profiling, data analysis, and data validation using SQL and spreadsheet-based tools. Identify data anomalies, inconsistencies, and quality issues and provide remediation recommendations. Support enterprise Data Quality and Data Governance initiatives. Partner with business users, project managers, architects, developers, and QA teams to ensure data requirements are clearly defined and implemented. Develop source-to-target mappings and participate in data integration and transformation efforts. Conduct impact analysis for upstream and downstream data changes. Support UAT and business validation activities related to data initiatives. Create and maintain data dictionaries, metadata documentation, and business rules. Required Qualifications 7-10 years of experience in Data Modeling and Data Analysis roles. Strong hands-on experience with: Data Modeling Techniques (Star, Snowflake, Hybrid Models) Fact and Dimension Table Design Data Warehousing Concepts Data Mapping and Data Lineage Advanced SQL skills with the ability to: Profile large datasets Perform complex queries and joins Analyze and reconcile data issues Validate business and technical rules Experience supporting Data Quality Analysis and remediation initiatives. Strong analytical and problem-solving skills with attention to detail. Excellent stakeholder management and communication skills. 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.

Design and maintain conceptual, logical, and physical data models to support enterprise initiatives in the capital markets domain. Collaborate with stakeholders to translate business requirements into scalable data structures and ensure data quality through profiling and validation.

Requires 7-10 years of experience in data modeling and analysis with strong expertise in SQL and data warehousing concepts. Candidates must possess deep knowledge of trade lifecycle processes and financial market participants.

• SQLSouhaitée
• Analyse de donnéesSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Data Modeling
• SQL
• Data Analysis
• Capital Markets
• Star Schema
• Snowflake Schema
• Fact and Dimension Modeling
• Data Profiling
• Data Quality
• Data Governance
• Source-to-Target Mapping
• Data Lineage
• Data Warehousing
• Stakeholder Management
• Metadata Documentation
• Impact Analysis

• Data & Analytics
• Technology
• Finance & Accounting
• Consulting
• Software

Expérience minimale

5+ ans

Postuler avant le

5 sept. 2026

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Niveau d’expérience

Mid-Senior level

Mode de candidature

La candidature directe est offerte