Lead BI Analyst

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. 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.

The specified description for the Senior Developer- BW/HANA /ETL is as follows
•A strong understanding of SAP HANA data modeling concepts, including the ability to create calculation views, attribute views, analytical views. Hands-on experience of SAP BW7.5, HANA implementation and Support.
•Understand and translate business needs into data models supporting our strategic solutions.
Work with the Business and Application Development teams to implement data strategies, build data flows and develop conceptual data models.
•Contribute to design of data models and data structures.
•Develop best practices for standard naming conventions and related coding practices to ensure consistency of data models

Good years of SAP Analytics/Business Intelligence/Business Warehouse (BI/BW/HANA) related experience with a professional services advisory firm or publicly traded company and experience leading and delivering full life cycle implementations.
•Good end to end implementation experience with SAP HANA 1.0 and 2.0 with at least 1 number of full lifecycle project implementation experience with SAP HANA SQL and/or SAP S/4 HANA.


Implements and develops customer deliverables that meet or exceed customer requirements
•Develop and demonstrating a good understanding of business processes for their assigned functional area/data objects.
•Demonstrate a strong knowledge of underlying technical data structures and definitions for assigned functional process area/data objects.
•Contribute to an integrated data solution through data analysis, reporting and collaboration with offshore colleagues and clients.
•Expertise in SAP BW7.5, SAP BW on HANA/BW4 HANA, Native HANA
•Work closely with other consultants on customer site as a part of small to large size project teams
•Conduct requirements analysis, data analysis and create reports
•Actively expand consulting skills and professional development through training courses, mentoring, and daily interaction with clients.
•Proficient in Development and understanding of SAP Analysis for Microsoft Office to perform custom calculations, filtering, and sorts to support complex business planning and reporting scenarios.
Architect and design a secure and robust BI solution to provide enterprise data to end-user business analytics and visualization tools Analysis for office.
Understand business requirements behind assigned tasks Create or modify data mappings Prepare data for testing, execute, and validate data.

Experience with SAP HANA Analytics transformation solutions leveraging applications including SAP HANA, ETL tools and SAP BW
Knowledge of data warehousing, data modelling and database concepts.
Prior experience in developing complex data integration that includes data ingestion and transformation from non-Sap and file-based system to HANA datastore.
The candidate will also need to have hands on exposure with technical and functional knowledge of the various technologies like SAP BW 4 HANA, AFO & SAC analytics
Flexible to support BAU and prod support issues during off office hours specifically during quarterly and yearly financial closing.
Understand and exp on Fit gap analysis for S4 implementation
Nice to have exposure on various cutting edge analytical and tools like SAP SAC planning.
Good to Have exposure and hands on SAP PAPM solution.

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).