PAM Data Analyst
Deutsche Bank
Pune, Maharashtra, India
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
