Job Purpose
Market Risk: The Market Risk department is a specialized unit in Finance Operations that operates in the Chennai and Manila centers. The team has front line responsibility for risk measurement; deal valuation, exposure reporting and price validation. The department pulls together a range of expert skills that ensure accurate and timely reporting, and allow us to offer professional advice on the wide range of issues that the department gets involved in. We are interested in attracting people to our business who share our core working values of honesty, integrity and respect for others.

Market Risk Chennai: The Market Risk department in Chennai is an exciting and growing team in Finance Operations. The team has been continuously absorbing newly migrated activities over the last seven years with continued growth and more complex work will continue to be absorbed into the teams.

The Model Validation team is responsible for providing assurance activities on models owned by Risk and used within the trading books, the Model Validation Analyst reports to the Global Process Manager Market Risk. The candidate will need to be comfortable with working independently with limited supervision at times, and be able to thrive as part of a global team with members in the US, UK, Netherlands, India and Singapore.

The purpose of the role is to independently validate the models used by the Risk organization for the quantification of risks that are present within the trading portfolios. These models include VaR, stress testing, liquidity analysis, options, and the models used to value physical assets such as storage, pipelines and transmissions. The longer term goal is to provide an independent validation service for the models used by Front Office teams in their day to day work and for assessing new businesses.

The role also involves collaborating with and providing advice to others in the global Risk organization. This includes Market Risk Managers, Valuation, Quantitative Analytics, Operational Risk and Risk Management Operations.

Responsibilities

• Drive understanding of the design and utilization of methodologies to assess risk/reward of the portfolio, including VaR back-testing, stress testing, scenario analysis, liquidity analysis.
• Develop, test, run and validate quantitative models that simulate real world businesses and assets.
• Work closely with the Valuation and Quantitative Analytics teams to understand and model embedded physical optionality and how optimization of physical portfolios changes exposures.
• Understand and explain changes in VaR by breaking down the impact by its underlying drivers, and ensuring that the VaR accurately reflects the positions taken and volatility of the relevant market.
• Design testing and validation regimes for VaR models to ensure that they are as accurate as possible, and any underlying assumptions or inaccuracies are documented and explainable.
• Ensure that fair economic value principles are followed within models used by Risk, including providing modelling support and challenge with stakeholders on valuation inputs and parameters.
• Ensure that all exposures generated from modelled positions or assets are fully understood and that these exposures and resultant P&L are properly evaluated, validated and analyzed.
• Produce ad-hoc analysis to explain P&L or exposure changes generated by the models to Risk Managers, assist them with queries and requests for input data or parameter changes.
• Provide detailed analysis and documentation of methods, techniques, and findings. Well documented processes enable team members to build new achievements upon earlier work.
• Ensuring that error-checking is a natural part of all processes so output is ‘Right First Time’.
• Ability to solve real world business problems using quantitative and computational techniques.
• Investigate and manage large data sets, ensuring consistency and quality. Build tools to enable the data to be easily accessed by analysts across Risk. SQL and Python are the preferred languages for accessing and manipulating datasets within Shell.
• Promote a culture of continuous improvement by having the courage to challenge established processes. This includes identifying inefficiencies in local and global operations and opportunities to streamline and automate shared processes and interfaces.

Competencies

• Team player, good interpersonal skills. Flexible to work with colleagues across numerous time zones with both Market Risk at the Trading Hubs in London, Rotterdam, Houston, Dubai and Singapore; but equally the Business Operations centers in Chennai, Manilla, Bangalore.
• Excellent communication skills; the role will require writing documentation, research reports, new policies, and presenting analysis and insights to senior stakeholders. Due to the global nature of the business the role requires communicating using different methods, in a variety of formats, to people in many countries.
• Ability to articulate and communicate complex scenarios and ideas in a clear and concise manner whilst understanding the perspective and experience of others. Ability to challenge sensitive issues constructively whilst maintaining working relationships.
• Proactively identify and communicate potential issues with the appropriate teams or stakeholders. Making sure problems raised are followed up and worked on until completion.
• Able to collaborate and produce good quality output working with colleagues in different teams who report to different managers.

Additional Job Description

Requirements

• Degree in Business, Economics, Mathematics, Science, Engineering or IT; or relevant workplace experience in the energy trading industry.
• Experience within a trading, financial or risk management organization, including an understanding of financial modelling.
• Understanding of financial, commodity and energy markets; derivative instruments, and hedging.
• Experience in scripting languages which enable data gathering and transformation such as Python or R. Other scripting languages such as C#, Java, Matlab also considered.
• Experience writing code to retrieve datasets from structured databases using SQL / Oracle.
• Intermediate to Advanced Excel skills; such as pivot tables, lookups, VBA macros.
• Experience with Endur, DEX or comparable energy trading risk management system is preferable.
• Resilient when working under pressure, with the ability to prioritize tasks to meet key deadlines.
• Good judgement to provide advice, question discrepancies, escalate issues.
• Scientific mindset; identify, investigate, analyse, research, discuss, record, and resolve issues.
• Learner mindset; innovative and creative, excellent problem-solving capabilities.

Disclaimer

Key Roles & Responsibilities:

• Assist with the daily production of daily Global P/L and exposure reporting. Monitor exposure limits daily within the trading control framework and manual of authorities (MOA) and keep themselves updated for any changes.
• Liaise with business users and technical support team to identify, analyze and resolve application issues.
• Understand trading account structure and exposures and P&L generated by the transaction types in the book
• Provide strategy-based P&L commentary, demonstrating a commercial understanding of the business.
• Leverage market risk modelling practices including Value at Risk, Stress Testing, Options Analytics.
• Ensure activities are carried out with safety awareness and are performed in compliance with external regulation, the Shell Control Framework, SOX and Financial Reporting requirements and Shell Trading mandate and policies.
• Required skill set Excel, VBA, and SQL. Preferred experience working in ZEMA, Endur and with BI software.
• Support and maintain documentation of process and methodologies
• Work closely with specialists and Sr Specialist in the team to help them carry out daily risk reporting, help him/her executing projects. Lead the project if there is a business need.

Experience and Qualifications:

• Knowledge of Trading system would be advantageous
• Ability to multi-task with a high level of attention to detail and accuracy
• Ability to perform under rigid deadlines
• Working knowledge of Excel
• Strong interpersonal and communication skills and an ability to build and maintain positive stakeholder relationships
• Self-motivated individual who functions well in a team environment

Disclaimer

P&G was founded over 180 years ago as a simple soap and candle company. Today, we’re the world’s largest consumer goods company and home to iconic, trusted brands that make life a little bit easier in small but meaningful ways. We’ve spanned three centuries thanks to three simple ideas: leadership, innovation and citizenship. The insight, innovation and passion of hardworking teams has helped us grow into a global company that is governed responsibly and ethically, that is open and transparent, and that supports good causes and protects the environment. This is a place where you can be proud to work and do something that matters.

CONSUMER & MARKET KNOWLEDGE – ADVANCED ANALYTICS CO-OP

Description

Are you motivated by solving tough business problems, wrangling massive datasets, and developing inventive code to generate insight from diverse sources of data? Are you curious?

If so, then a role in the Analytics & Insights Function, Commercial Analytics organization is for you! In A&I, we combine analytics and data science along with consumer and business knowledge to directly influence business strategy, product design, pricing, media investments, retail, go to market strategy … and much more. We use our data and boundless curiosity to discover what consumers want, why they want it, and how we can influence them through immersive exploration and in-depth analysis.

Your key to success will be your ability to integrate exploratory data analysis, model building, model optimization and model production along with Consumer and Shopper Behaviour understanding to deliver insights that drive the business.

RESPONSIBILITIES

• Analyze data & provide insights into P&G’s monthly business process, based on both external data (e.g. market share and household consumption) and internal data (e.g. sales data).
• Lead category/channel deep-dives (e.g. Baby Care/Shave Care/Skin Care or Hyper Super/Drug Pharma/eCommerce) to identify portfolio opportunities/business drivers opportunities to accelerate business.
• Improve Media/Trade effectiveness and enable media/trade cost saving by running analytics.
• Data science or innovation projects to solve existing business questions differently by IoT, automation, external data, etc.
• Overall work would be a good mix of delivering today (70-80% time/capacity) and creating tomorrow (20-30% on innovation/data science projects).
• Demonstrate leadership in applying analytical techniques to deliver concrete insights from data.
• Ability to demonstrate, translate and communicate complex data or algorithms into simple conclusions and business practical insights
• Strong collaboration skills and the ability to work within diverse organizations and teams

Qualifications

PREFERRED COURSEWORK / EXPERIENCE:

• MBA with knowledge on Statistical models, Behavioral Science, Consumer Marketing skills.
• Knowledge Areas: Data Science, Statistics and its application to Attributive & Predictive Modeling; Machine Learning, Big data Mining, and AI.
• Statistical Packages: SPSS, SAS
• Programming / Database/analytical Languages: Python, R, SQL, Knime
• Visualization Tools: Power BI, Spotfire, Tableau
• Have creativity, innovation, initiative, follow-through, strong written and verbal communication, and priority-setting skills.
• Have confirmed history from school or work experience that demonstrates an ability to lead analytics project through envisioning, direction setting and enrolling others, and thinking/problem solving.