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

8 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: a year 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 months 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.

Barclays Logo

Data Solution Analyst

Barclays

Pune, Maharashtra, India

Posted: 25 days ago

Embark on a transformative journey as Data Solutions Analyst at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionize our digital offerings, ensuring unapparelled customer experiences. This role is within the Data Solutions team, which is responsible for the delivery and development of business, regulatory and client reporting across Global Transaction Banking. To be successful in this role as a Data Solutions Analyst, you should possess the following skillsets:  Application of Dashboard designing and data visualization best practice. Advanced skills and experience of Tableau and SQL. Demonstrate excellent communication skills and stakeholder management skills. Some other highly valued skills include: Other Tools experience (Power BI, SAS EG, AWS). You may be assessed on the key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen strategic thinking and digital and technology, as well as job-specific technical skills. This role is based in our Pune office. Purpose of the role To transform raw data into useful and actionable insights that support strategic decision-making across the bank.  Accountabilities Delivery of Business Intelligence (BI) solutions including multi-dimensional database models, data marts, data warehousing, data transforms, data analytics, and reporting solutions, to support the decision-making processes across the bank. Execution of data extraction, cleansing and maintenance initiatives from a range of resources including internal systems, external data bases and market feeds. Development of data models, dashboards and reports to clearly communicate the banks key business KPIs, performance, trends, and relationships to various levels of management within the bank. Provision of responses and solutions to business requests for data analysis by building custom queries and reports to address specific questions and problems. Monitoring KPIs against established objectives and benchmarks to identify trends, patterns and anomalies that may impact the banks performance and provide recommendations to improve highlighted processes. Collaboration with various stakeholders to understand their data needs and provide solutions through new technologies and tools that are compliment with the banks objectives, regulatory requirements, and data governance policies. Continual improvement and automation of reporting and metric provision across Technology. Analyst Expectations To perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement. Requires in-depth technical knowledge and experience in their assigned area of expertise Thorough understanding of the underlying principles and concepts within the area of expertise They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources. If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others. OR for an individual contributor, they develop technical expertise in work area, acting as an advisor where appropriate. Will have an impact on the work of related teams within the area. Partner with other functions and business areas. Takes responsibility for end results of a team’s operational processing and activities. Escalate breaches of policies / procedure appropriately. Take responsibility for embedding new policies/ procedures adopted due to risk mitigation. Advise and influence decision making within own area of expertise. Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct. Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function. Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function. Make evaluative judgements based on the analysis of factual information, paying attention to detail. Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents. Guide and persuade team members and communicate complex / sensitive information. Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation.

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.