The Job logo

What

Where

PAM Data Analyst

ApplyJoin for More Updates

You must Sign In before continuing to the company website to apply.

Smart SummaryPowered by Roshi
As a PAM Data Analyst at Pune, India, you will create ad-hoc reports and data extracts for internal and external Audits, utilizing SQL and scripting languages. Strong analytical skills and knowledge of Information Security are essential.

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
Set alert for similar jobsPAM Data Analyst role in Pune, India
Deutsche Bank Logo

Company

Deutsche Bank

Job Posted

6 months ago

Job Type

Full-time

WorkMode

On-site

Experience Level

0-2 Years

Category

Data & Analytics

Locations

Pune, Maharashtra, India

Qualification

Bachelor

Applicants

67 applicants

Related Jobs

Capgemini Logo

Data Analyst

Capgemini

Pune, Maharashtra, India

Posted: 9 months ago

The Data Analyst position requires expertise in Python, machine learning libraries like TensorFlow and Keras, clustering and classification algorithms, database management, and model evaluation metrics. Responsibilities include developing and maintaining machine learning models and working in an Agile scrum team. The job is based in Pune, Maharashtra, India and is a full-time on-site opportunity.

Johnson Controls Logo

Data Analyst

Johnson Controls

Pune, Maharashtra, India

Posted: 3 days ago

Job Description Job Title:  Data Analyst Location:  Pune, India Experience:  1-3 years Job Description: Johnson Controls is seeking a detail-oriented Data Analyst with 1 to 3 years of experience to join our analytics team in Pune. The successful candidate will be responsible for collecting, analyzing, and interpreting data to support decision-making processes and drive business improvements. What You Will Do: Gather and process data from various sources to support business analysis and reporting. Utilize statistical techniques to analyze data and identify trends, patterns, and anomalies. Create and maintain dashboards and reports to facilitate data-driven decision-making. Collaborate with cross-functional teams to understand business requirements and deliver actionable insights. Assist in the development and implementation of data collection systems and other strategies to optimize statistical efficiency and data quality. Perform ad-hoc analyses to identify opportunities for process improvement. What We Look For: Required: Bachelor’s degree in Data Science, Computer Science, Statistics, or a related field. 1-3 years of experience in data analysis or a related role. Strong proficiency in SQL and experience with data analysis tools (e.g., Excel, Python, R). Familiarity with data visualization tools (e.g., Power BI, Tableau). Excellent analytical and problem-solving skills, with a keen attention to detail. Strong communication skills to present findings to stakeholders effectively. Preferred: Experience working in a fast-paced environment and ability to manage multiple tasks. Knowledge of machine learning techniques is a plus. Ability to work collaboratively within a team and across departments. Who We Are: At Johnson Controls, we are committed to driving innovation and sustainability in building technology. Join us to be part of a global team that is dedicated to creating a safer, smarter, and more connected world.

Deutsche Bank Logo

Operations Analyst (NCT)

Deutsche Bank

Pune, Maharashtra, India

Posted: 2 years ago

JOB DESCRIPTION Role Description You as an Analyst will be responsible for completion of day-to-day activity (Static amendments and set-up’s on various applications used by Front office, Middle office and Back office) as per standards and ensure accurate and timely delivery of assigned production duties. You need to ensure adherence to all cut-off times and quality of processing as maintained in SLAs. You should ensure that all queries related to routine activities are responded to within the time frame specified.   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 Responsible for the Investigation and resolution of static data related issues in various applications used by front office , middle office and back office team Ensure timely and accurate processing of static set-up request from PM’s , Traders Ensure adherence to standards , procedures and also identify risk, mitigate wherever there is a control issue Demonstrate domain expertise in identifying root causes and remediation of sourcing and data quality issues Escalate all issues in time, to the appropriate level, to avoid any adverse impact on the business Ensure team work culture is practiced. To get involved in process improvement projects driven by the management. Ensure proper back-ups created and assist during contingencies (Staff shortage, high volumes etc.) Exhibit excellent ownership attitude and should have a client-focus and delivery mind-set   Your skills and experience Should have complete knowledge of Trade Life Cycle. Should preferably have knowledge of Capital market and various financial products, with strong market data experience Good understanding of Reference Data and Market Regulatory terms, on both static and variable market data Familiarity with Bloomberg, Reuters and other global data source points Prior interaction with IT development staff is plus In depth instrument knowledge in at least (FI, EQ, Derivative) some areas minimum, broader the knowledge the better   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   About us and our teams Please visit our company website for further information: https://www.db.com/company/company.htm   Our values define the working environment we strive to create – diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer. We promote good working relationships and encourage high standards of conduct and work performance. We welcome applications from talented people from all cultures, countries, races, genders, sexual orientations, disabilities, beliefs and generations and are committed to providing a working environment free from harassment, discrimination and retaliation. Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides.