Senior Associate - Reporting & Insights

Department General Counsel Shared Services

Reports To Manager - Reporting

Level Grade 3

About your team

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, and Public Policy & Strategic Relationship Management. General Counsel Shared services (GCSS) function is a global centre of expertise currently being built out in Dalian and India. It provides operational support and services to the General Counsel function.

About your role
This role is placed in the Reporting & Systems vertical within GC Shared Services and reports into Manager - Reporting. The role will be part of an expanding reporting, BI & analytics vertical within GC Shared Services, partnering with businesses and key stakeholders across FIL locations to deliver the desired business insights outcomes. The candidate will be responsible for developing, implementing, and supporting business intelligence, reporting, data analytics and automation solutions across various stakeholder BUs for GC.

About you

• The key skill sets we are looking for are strong Power BI development and data modelling experience, advanced Power App development and Power Automate usage/experience.
• Good degree of proficiency in Power BI and Power Query (Visualization, data modelling and data transformation, Knowledge of DAX functions)
• The candidate must evidence strong experience in building user ready automation solutions, dashboards, data apps, web portals, user forms and collaboration apps using Power App tool suite.
• Strong experience in handling, manipulating and transforming large and complex data sets into sustainable data models to be fed into Power BI dashboards, PowerApps and SharePoint lists.
• Deep expertise in translating stakeholder and business requirements into data insights requirements
• Advance skill sets and experience in designing user centric dashboards User interfaces and wireframes.
• High degree of proficiency in MS Excel (strong knowledge of pivot tables, data sorting, filters, etc). Ability to develop complex models and data structures, including macros, will be of advantage
• Work closely in alignment with existing Data frameworks and quality control teams to ensure data governance

Experience and Educational Qualifications

• At least 5 years of overall experience preferably in Financial Services or Management Consulting industry with exposure to change transformation programs.
• Graduation (must), preferably in Engineering, Commerce or Economics, MBA or equivalent qualification.