Data Analyst

Tata Consultancy Services; Mississauga; On-site; CAD 60,000 - 85,000; Full time

Job summary

A leading consulting and IT services organization is seeking a Data Analyst to evaluate source and target systems for data analysis. The role requires in-depth knowledge of SQL and Excel, along with strong analytical skills to manage large datasets and present findings effectively. Join a diverse team to contribute to transformative projects in a collaborative environment.

Qualifications

• In-depth knowledge of SQL and Excel required.
• Strong analytical skills to interpret complex data sets.
• Ability to write complex SQL queries and documentation.

Responsibilities

• Analyze and evaluate source and target systems for data fit.
• Collaborate with operations and development teams.
• Develop data transformation and mapping rules.

Skills

SQL

Excel

Communication

Data Analysis

Problem Solving

Tools

Analytical tools

Machine Learning technologies

Job description

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’s 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 FTSE4Good Emerging Index.

Job Description:

Role Description:

• Analyzing and evaluating the source and target system to perform data analysis to fit source system data to target system.
• Develop data transformation rules, mapping and exception rules and presenting to partners Operations team.
• Collaborating with Operation users and development team.
• Preparation of functional requirement document.
• Daily data review meeting with all the stakeholders.
• Should be able to work with a team who might be geographically distributed.

Required Skill Set:

• In-depth knowledge on SQL, Excel, Strong Communication skill. to run meetings with all the stake holders and Documentation skill
• Requirement Gathering - Understanding source system data model and entity relationships. Understanding the functional operating model and usage of the system.
• Collecting and interpreting data - building Complex SQL Queries to join the different source tables based on the Entity relationship diagram, getting the desired results for analysis
• Analyzing results / Identifying patterns and trends in data sets - Using REGEX, Excel lookups, formulas to find hidden patterns, data outliers and exceptions
• Ability to analyses large datasets using Queries , prepare reports
• Reporting the results back to the relevant members of the business - Presenting the overall statistics to management related to different data attributes relevant for migration.
• Working alongside teams within the business or the management team to establish business needs - Understanding the overall business requirement and impacted downstream / upstream systems
• Rules Development - Providing transformation logic and rules for enriching / modifying source data to fit the target data model
• Testing - Validating the output result set from code through excel/ REGEX and other techniques. Providing test case validation reports and statistics.

Desired Skill Set:

• Experience in Analytical tool, Data Science tool and machine leaning technologies
• Good Analytical and problem solving.
• Object oriented programming 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.