Analyst - Institutional Client Reporting

At Franklin Templeton, we’re driving our industry forward by developing new and innovative ways to help our clients achieve their investment goals. Our dynamic and diversified firm spans asset management, wealth management, and fintech, offering many ways to help investors make progress toward their goals. Our talented teams working around the globe bring expertise that’s both broad and unique. From our welcoming, inclusive, and flexible culture to our global and diverse business, we offer opportunities not only to help you reach your potential but also to contribute to our clients’ achievements.

Come join us in delivering better outcomes for our clients around the world!

Group Introduction:

Client Reporting team within FTS Institutional Service group is responsible for providing periodic reporting's to Internal and External clients viz. Institutional, High Net Worth and all other separate accounts managed by Franklin Templeton Investments.

Being one of the critical elements of Client Facing reporting, team is highly responsible for ensuring accurate and timely production of client service reporting and a wide range of other front office support functions such as New account Client onboarding and Institutional Client Servicing including Scheduled & On-demand (Adhoc) Client Reporting and Scheduled Batch Reporting. Fail to perform accurate and timely reporting may lead to adversely impact FT’s reputation with Investors (Clients), Custodian and Fund Administrators etc.

To cater Global client’s servicing needs, teams produces highly sensitive and time-based reports which includes Historical performance, Attribution reporting that includes distribution of Month-End Performance, Extreme Statement (includes Transactions and Holdings Details of Previous Month), Turnover Reports, Customized Reconciliation Statement (Franklin Vs. Client Data / Franklin Vs. Fund Admin / Franklin Vs. Custodian), Broker Statements to Clients, Cash Sweep Reports / Cash Balances, Customized Transactions and Holdings Report, AUM Data Reporting, MIFID II Reporting to Client, Advisory Board Reporting’s, Client meeting books etc.

Furthermore, Internal reporting includes periodic client specific reporting to various functions viz. Global Billing team, Investment compliance, GTS, GFAR, Portfolio Managers, Portfolio Administrators, Sales teams, and Regional Client services teams etc.

What is the Analyst responsible for?

• This role will have responsibility for the delivery of periodic reporting with ensuring timely and accurate completion of day-to-day expectations relating to account servicing and reporting. Individual will work closely with other Supervisor/ Regional Client Service teams/ ICR production teams to determine priorities. Perform reporting related functions via automated platforms or by creating presentation materials manually for non-standard requests. Research and analyze methods to streamline and increase workflow efficiencies and communications with other business partners. Frequently interact with global Business Units for providing team with data, commentary, legal and compliance advice etc. to ensure Client Reporting team can support front office requirements and requests in a timely manner.

Job Level Description: 

• Ensure timely and accurate completion of Client Reporting tasks.

• Analyze and resolve report production issues. Escalate issues to supervisor in a timely manner

• Maintain communication with report recipients on production issues and on-going support/enhancement

• Build and maintain professional working relationship with Regionals PA -CS/ICR production teams and business partners globally.

• Produce materials leveraging the available reporting tools: Business Objects, GRIP, ACR, PPT, PDF, etc.

• Scheduled & On-demand Client Reporting and Data Delivery queries as per requests from internal business partners and external clients services team.

• Production and delivery of scheduled weekly, monthly, quarterly, semi-annual, and annual Client Reporting

• Production of quarterly real estate reports

• Delivery of regulatory reporting e.g., EMIR, MIFID II, Italian accounts etc.

• Production of On-Demand Client Meeting Books for Institutional separate account and fund clients

• Critically analyze data pieces received from providers/reporting tools and investigate any potential errors that might impact client reporting

• Responding to audit requests as directed by senior team members

Key Responsibilities:

• Apply a consistent, repeatable, and scalable process

• Maintain excellent business knowledge and be mindful of customer needs, as well as systems capabilities and constraints

• Keep up to date internal policies & procedures

• Keep up to date all logs and metrics

• Keep the SharePoint task list in sync with GRIP entries and periodic requests received from various Business Units

• Cross train on other team members’ tasks for business continuity purposes

Impact of service:

• Accurate and timely reporting is paramount for ensuring highest client service levels are maintained, any misleading information may expose to Reputational and Financial Risk to firm or client

• Understand the complex and customize reporting needs which could be essential for internal or external assessment and broader distributions

What ideal qualifications, skills & experience would help someone to be successful?

Projects / initiatives:

• Actively participate in initiatives, projects or process improvements as assigned.

• Develop new and modify existing Visual Basic code, using VBA with .NET extensions, Microsoft Access, Microsoft Excel, and SharePoint.

• Assist in testing of new systems/functions, propose enhancements and modifications

• Drive efficiencies through the utilization of innovation and automation.

• Results-oriented; ability to successfully manage multiple tasks, take initiative to improve own/other performance, and ability to work during crisis situations.

• Ability to develop relationships with multiple stakeholders

• Good analytical and problem-solving skills along with understands escalation management.

Skills:

• Working knowledge of Microsoft products such as Outlook, Word, PowerPoint, Excel, Access, Visio etc.

• In-depth technical knowledge of Microsoft Access, Excel, Visual Basic will be preferred.

• Good knowledge of application development using SharePoint will be added advantage.

• Exposure of Self Service/Business intelligence tools will be an added advantage - like Altreyx, Tableau, Xceptor, RPA, MS Powe BI etc.

Education (or equivalent experience):

• Bachelor's Degree or equivalent experience (Required).

• Working experience on Vermilion Reporting system (Required )

• Master’s degree or MBA (Preferable)

• CFA/FRM will be added advantage

Experience:

• 0-2 years’ experience in the financial services industry

• Consistent and Strong performers

Licenses and Certifications:

• Certification in tools like Alteryx, Xceptor and RPA will be useful in this role