Job Description

About the Opportunity Job Type: Permanent Application Deadline: 30 November 2023 Title: LEAD DATA VISUALISATION AND REPORTING Department: Global Risk Reports To: Head of Investment Risk Oversight Level : 4 We\'re proud to have been helping our clients build better financial futures for over 50 years. How have we achieved this By working together - and supporting each other - all over the world. So, join our team and feel like you\'re part of something bigger. 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 market risk, derivatives risk, sub-advised risk, fund liquidity risk and fund counterparty 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 develop enterprise grade visualization tools, data pipelines and data 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. Key Responsibilities As a Data Visualization and Reporting Lead 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: Analysing complex data using expert SQL Queries and Excel Modeling techniques Exploratory data analysis using Python (Pandas and Numpy) for data quality issue and analysis Prototype desired data model using Excel and SQL Server database design documents Creating scalable data models using Power BI ETL Engine (Power Query) and SQL Server Converting raw data into meaningful insights through interactive and easy-to-understand dashboards and reports. Extracting and integrating data from various data sources including a central data warehouse, directly from source systems or other unstructured forms of data (such as flat files, email, etc.) Create semantic data layers (dimension modelling) to map data to specific business / operational processes and develop flexible, reliable easy to understand dimensional data models Develop project execution methodology and documentation and implement development best practices, version control and deployment pipeline management. Work on multiple project streams running in different stages varying from analysis, data modelling, development and production support Well versed with AGILE methodologies and release management principles Experience and Qualifications Required Excellent skills in writing complex SQL (Structured Query Language) statements with multiple joins and optimising skills Intermediate level database knowledge (DDL and DML) on SQL Server 17 or Oracle 12+ Well versed with database designing concepts and maintenance Create scalable data models using SQL Server, Python and Power BI (Power Query) Know-how of Publish and refresh strategies on Power BI Workspace Admin activities for gateway and access management on Power Bi Workspace Experience in creating professional data visualization tools using Power BI Knowledge of Investment Management domain, Financial Capital markets, Types of Assets, Trading life cycle, Funds management etc. Data Science and Data Analytics knowledge - Ability to understand, analyse complex data sets Good problem solver and ability to adapt to changing requirements or deliverables Strong verbal and written communication skills, strong stakeholder management Essential Skills The role will require a minimum of 7+ years of experience in developing and implementing Reporting and Analytics solutions. High degree of proficiency in SQL Queries, Power Query, advance DAX calculations & modelling techniques and developing intuitive visualizations solutions. Hands-On experience in Python based data analysis and troubleshooting Exposure to data analytivs using Pandas and Numpy Hands-on experience in managing production dashboards and configuring refreshes on Power BI Workspace Strong experience in developing and managing dimensional data models in Power BI or in data warehouse environment 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 Managing data from multiple sources in excel, CSV or MS Access like tactical data management solutions Demonstrates proficiency in data integration and architecture including dimensional data modelling, database design, data warehousing, ETL (Extract, transform and load) development, and query performance tuning 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 Desirable Skills Experience with developing Power Automate (Flow) and Power Apps based solutions will be an 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 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 Feel rewarded For starters, we\'ll offer you a comprehensive benefits package. We\'ll value your wellbeing and support your development. And we\'ll be as flexible as we can about where and when you work - finding a balance that works for all of us. It\'s all part of our commitment to making you feel motivated by the work you do and happy to be part of our team. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com. For more about our work, our approach to dynamic working and how you could build your future here, visit careers.fidelityinternational.com.

foundit