Job Title:

PAM Data Analyst

Corporate Title: NCT

Location: Pune, India

Role Description

The PAM Data Analyst will be responsible for the creation of ad-hoc reports and data extracts required during internal and external Audits for the Bank’s PAM function. The role requires expert knowledge of data manipulation and transformation techniques using SQL and scripting languages. The successful candidate must be able to work to demanding deadlines, have strong analytical skills, attention to detail and the ability to understand complex requirements and create the necessary data extracts to address them. Good knowledge of Information Security topics would be beneficial.

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy

• Best in class leave policy
• Gender neutral parental leaves
• 100% reimbursement under childcare assistance benefit (gender neutral)
• Sponsorship for Industry relevant certifications and education
• Employee Assistance Program for you and your family members
• Comprehensive Hospitalization Insurance for you and your dependents
• Accident and Term life Insurance
• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Develop good knowledge of the Bank’s InfoSec Policies and controls, specifically around PAM and how these must be applied to the Bank IT Assets
• Develop good knowledge of the Bank’s PAM datasets, their attributes and the significance of each data item.
• Participate in meetings with internal and external Auditors. Understand their requirements and formulate strategies to produce appropriate data evidence.
• Develop reusable methods and techniques. Iteratively improve the data management process.

Your skills and experience

SQL

• Can develop MS-SQL queries and procedures, create custom reports
• Advanced knowledge of database procedures and Microsoft SQL Server concepts
• Knowledge of one or more SQL variant, such as MySQL, MSSQL, and PostgreSQL
• The ability to create fast and efficient database queries, including joining and cross-referencing cells from several tables

Microsoft Office

Excel

• Task automation using macros and VBA
• Creating dynamic reports with PivotTables
• Building formulas
• Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
• Manipulate date, time, text, and arrays
• Advanced conditional formatting

Word

• Intermediate to advanced skills in Microsoft Word
• Creation of and updating of Process Maps, Standard Operating Procedures and supporting documentation such as process documentation/workflows
• Coordinating, tracking, reviewing and ensuring timely completion of high-quality controlled documents

Powershell

• Data Parsing and Manipulation
• String manipulation
• Number manipulation and parsing
• Date/time manipulation
• Forcing data types
• PowerShell pipeline

Education | Certification (Recommended):

• BSc Comp. Science

How we’ll support you

• Training and development to help you excel in your career
• Coaching and support from experts in your team
• A culture of continuous learning to aid progression
• A range of flexible benefits that you can tailor to suit your needs