Data Modelling (Job Code : J39310)  

 Job Summary
Share this job on Facebook  Share this job on Twitter  Share this job on Linked In
 
Experience:
4.00 - 7.00  Years 
 
Location:
Bangalore
 
Designation:
Consultant
 
Degree:
BE-Comp/IT, BTech-Comp/IT
 
Educational Level:
Graduate/Bachelors
 
Stream of Study:
 
Industrial Type:
IT-Software/Software Services
 
Functional Area:
IT Software - Other
 
Key Skills:
Modelling
 
Job Post Date:
2018-04-13 12:38:15  
 
 

 Company Description
 
Our Client in India is one of the leading providers of risk, financial services and business advisory, internal audit, corporate governance, and tax and regulatory services.

Our Client was established in India in September 1993, and has rapidly built a significant competitive presence in the country. The firm operates from its offices in Mumbai, Pune, Delhi, Kolkata, Chennai, Bangalore, Hyderabad , Kochi, Chandigarh and Ahmedabad, and offers its clients a full range of services, including financial and business advisory, tax and regulatory.

Our client has their client base of over 2700 companies. Their global approach to service delivery helps provide value-added services to clients. The firm serves leading information technology companies and has a strong presence in the financial services sector in India while serving a number of market leaders in other industry segments.
 

 Job Description
 
Skills:
• Extensive knowledge in building and/or reviewing Excel Data models/solutions, and a strong understanding of spreadsheet best practice.
• Knowledge in custom VBA (Visual Basic for Application) coding in MS Excel, MS Access
• Understanding in Business Intelligence and Reporting Tools – Power Pivot, Power View and Power BI
• Working knowledge in Relational Database and Data Manipulation
• The candidate should have in-depth knowledge in various stages of SDLC
• Hands on experience in requirement gathering, analysing, developing and testing a product/data model/project

Responsibilities:
• Understand high level requirements from Global team and work closely with product owners to plan and budget projects accordingly
• Manage the assignment of specific responsibilities relating to project by coordinating with peers within the team for relevant roles and job functions
• Interact with client, do requirement analysis, propose solution, estimation, listing down assumptions and risks
• Create working proof of concept for projects
• Responsible for writing User Defined Functions using VBA to create custom function in MS Excel, MS Access
• Must be good in reviewing client/peer build data models and evaluate the pros and cons
• Good working knowledge in Power Pivot to create data models within Excel workbook
• Understanding business needs to explore, visualize and present data in Power View
• Basic exposure to Power BI or similar BI tool will be helpful
• Good understanding in relational databases
• Handle large database of in GBs with ability to write/edit/modify SQL to transform larger datasets
• Experience in integrating MS Excel with MS Access, MS SQL Server or MS SharePoint
• Analyze complex data sets and convert them into the information which drives business decisions
• Express strong voice for data integrity and reporting quality utilizing best practices and industry standards
• Experience writing technical documentation and user guides; providing end-user training and support