• GDC | Senior Associate 1| MSBI | Generic| D & A Jobs in Bangalore,India

  • KPMG India Pvt Ltd
  • Save Job
  • 4 - 6 Years
  • Posted : above 1 month

Job Description:

The Senior Associate (SSAS) will be working in Audit Data & Analytics domain in a Techno-Functional role and develop expertise in KPMG proprietary D&A tools based on the Microsoft Business Intelligence [MSBI] stack and be a part of a team responsible for processing large datasets from ERP systems [eg, SAP/Oracle/Microsoft Dynamics or others] to provide Audit D&A insights to Engagement teams/Clients,

Broadly, the key responsibilities are

Audit D&A Solution Delivery Be a part of the team that is responsible for Audit D&A service delivery and ensure timely and quality audit deliverables

Develop solution based on the MS BI stack

Debugging and development of complex stored procedure objects

Design & development of SSAS cubes, and enhancement of the existing Cubes Writing MDX and DAX queries for data & analytics solutions

Roles and responsibilities

The Senior Associate will be predominantly responsible for

Develop a skillset to process large data extracts from client ERP (SAP/Oracle/Microsoft Dynamics or others) systems into the MSBI stack based KPMG proprietary tool and understand the data from functional and technical perspective to resolve issues during processing the engagements

Design and develop the SSAS based OLAP cubes solutions

Develop the MDX & DAX queries for Data & Analytics requirements

Debug and develop a complex stored procedure objects and also participate in the performance tuning initiatives

Work with US and India leads to co-ordinate with client IT for data extraction process, discuss results with KPMG engagement teams

Develop an understanding of KPMGs service offerings and D&A tools and capabilities Co-lead the strategic initiatives and work with POD leads / Managers for the key project management activities

Develop an understanding of Accounting & Auditing and the applicability of D&A solutions on our Audit engagements

Develop industry expertise and apply understanding in discussions with engagement teams Independently lead the client engagements and work directly with the engagement teams

Develop an understanding of ERP system (SAP/Oracle/Microsoft Dynamics or others) and Business Processes, such as Order to Cash, Procure to Pay, General Ledger and Sub-Ledger Accounting, and Accounting Management Systems

Being proactive and engaged in bringing new ideas / solutions to our clients Debug and resolve issues while processing the large data sets and propose possible solutions

Experience Requirements

Minimum 4-6 years of post-qualification experience

Experience working with SQL Server Management Studio, writing SQL queries and development/debugging of stored procedures

Proven technical expertise in design and development of SSAS OLAP cubes Hands on experience on writing MDX and DAX queries

Exposure or knowledge of Cloud based SSAS services and tabular based SSAS models would be preferable

Education Requirements

Engineering (Computer Science, ECE, Mechanical and Civil) Graduate or Masters of Computer Application; or

MBA (Systems/ Finance/ Data & Analytics/ SCM) along with Engineering (Computer Science, ECE, Mechanical and Civil)

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Consulting Services, Financial Services/Stockbroking
Functional Area : IT Software : Software Products & Services
Role : Data Warehousing
Salary : As per Industry Standards
Deadline : 03rd Mar 2020

Key Skills:

Company Profile:

Company
KPMG India Pvt Ltdarfix

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status