About the Opportunity

Title: Senior Data Analyst

Department: Investment Risk - Operations and Analytics

Location: Gurgaon, India

Level: Grade 3

Our clients come from all walks of life and so do we. We are proud of our inclusive culture and encourage applications from the widest mix of talent, whatever your age, gender, ethnicity, sexual orientation, gender identity, social background and more. We are a disability-friendly company and would welcome a conversation with you if you feel you might benefit from any reasonable adjustments to perform to the best of your ability during the recruitment process and beyond.

We are committed to being a truly flexible employer, encouraging and trusting our people to perform their role in the way that works best for them, our business, our colleagues and our clients. We offer the maximum possible flexibility over where and when you work for all, considering your role and any local regulations. We call this new approach dynamic working.

Department Description

General Counsel:

General Counsel (GC) is a trusted advisor to all parts of FIL, providing high-value independent advisory and assurance expertise through our specialist teams. GC comprises of Legal, Risk, Compliance, Tax, Public Policy & Strategic Relationship Management.

Global Risk:

The risk team in Fidelity covers the management oversight of Fidelity's risk profile including key risk frameworks, policies and procedures and oversight and challenge processes. The team partner with the businesses to ensure Fidelity manages its risk profile within defined risk appetite.

The team is circa 50-strong, and growing, covering all facets of risk management including investment, operational, enterprise, and technology risk. The function is currently being strengthened to enhance global risk type coverage across FILs (Fidelity International) regions.

Investment Risk:

The Investment Risk team is part of Global Risk and is responsible for the framework and governance of all aspects of Investment Risk including fund market risk, fund liquidity risk, fund counterparty risk and fund sustainability risk. The team also provides oversight of the Operational Risk within the Investment Team and EUC (End-User Computing) Risk across the organisation.

The India business and operations team works upon providing data analytics solutions to enable data driven Risk oversight & controls on Investment data sourced from multiple sources.

Purpose of your role

The primary function of the role is to run and support enterprise grade reporting tools, and business analytics using Datawarehouse (SQL), Python & Power BI connecting to complex and high-volume data sources. The role will be working as part of an expanding data analytics team for Investment Risk Oversight within Global Risk Function, partnering with businesses and key stakeholders across FIL (Fidelity International) locations to deliver the desired business outcomes.

This role sits within the Global Risk Oversight Solutions and the individual will be expected to align their work closely with other members of the Investment Risk team and colleagues in Investments, Operational and Technology.

Key Responsibilities

As a Data Analyst you will be responsible for managing end-to-end data and visualization solutions for our various subject areas in Investment Risk. This role will entail:

• Executing and monitoring daily jobs using Python
• Troubleshooting data issues using SQL Queries
• Building understanding of all upstream data sources, and relevant data granularity
• Proactively monitor daily data load process and inform the stakeholders
• Proactively take note of and respond to user queries for the risk reports
• Enhance the existing data quality frameworks to be able to answer common user queries via automated reports
• Review the data quality frameworks to identify areas of improvement (automation etc)
• Maintain, review and constantly update documentation to reflect latest status of BAU functions
• Support testing new functionalities, and platform upgrades to ensure no impact on existing reporting
• Well versed with AGILE methodologies and release management principles

Experience and Qualifications Required

• Experience Range - 4 - 6 yrs
• Hands-on experience on Power BI or Tableau
• Some understanding of data models and how they are designed/constructed
• Understanding of Investment Management or experience working for or at an Investment/Asset Manager
• Ability to understand, analyse complex data sets, using Excel or other analytical tools
• Good problem solver and ability to adapt to changing requirements or deliverables
• Good attention to detail
• Strong verbal and written communication skills, strong stakeholder management

Essential Skills

• Well-versed in writing complex SQL (Structured Query Language) statements with multiple joins and optimising skills
• Well versed with database designing concepts and maintenance
• Intermediate level Power BI skills for enhancements and troubleshooting production dashboards
• Well versed with any coding language and best practices, experience in Python would be an advantage
• Data Analytics knowledge - Ability to understand, analyse complex data sets
• Strong verbal and written communication skills, strong stakeholder management
• High degree of proficiency in MS Excel (strong knowledge of power pivot, data sorting, filters, etc). Ability to develop complex models and data structures, including macros, will be of advantage
• Good understanding of Data Quality and Data management frameworks
• Ability to work with stakeholders at multiple levels and high degree of comfort in working with ambiguity and under pressure, with the ability to prioritise and manage multiple tasks
• Self-motivated with an eagerness to learn Investment Risk Domain and a positive work ethic
• Good problem solver and ability to adapt to changing requirements or deliverables
• Knowledge of Investment Management domain, Financial Capital markets, Types of Assets, Trading life cycle, Funds management etc.

Desirable Skills

• Development experience in Python will be an added advantage
• Experience of the asset management industry would be an advantage
• Experience based domain knowledge of Risk management, regulatory compliance or operational compliance functions would be an advantage
• Basic knowledge and know how of Data Science and its application.
• Focussed on providing high level customer service across various geographical areas
• Flexible and adaptable, responds rapidly to changing agendas
• Ability to use good judgement in the use of confidential information
• Clear open communication with a willingness to learn & listen