Vice President, Client Reporting

Vice President, Client Reporting

Toronto, Canada

About Citco

Citco is a global leader in fund services, corporate governance and related asset services with staff across 50 office locations worldwide. With more than $1.8 trillion in assets under administration, we deliver end-to-end solutions and exceptional service to meet our clients’ needs.

For more information about Citco, please visit www.citco.com

About the Team & Business Line:

Fund Administration is Citco’s core business, and our alternative asset and accounting service is one of the industry’s most respected. Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience.

As a core member of our Client Reporting team, you will be working with some of the industry’s most accomplished professionals to deliver award-winning services for complex fund structures that our clients can depend upon.

Your Role:

• You will work with business to understand and design reporting solutions.
• Develop and execute database queries and conduct data analyses
• Model data by writing SQL queries/Python codes to support data integration and reporting requirements
• Perform data integration through extracting, transforming and loading (ETL) data from various sources
• Create tabular reports, matrix reports, parameterized reports, visual reports/dashbords in a reporting application such as Power BI or QLIK
• Leverage and contribute to design/building relational database schemas for analytics. Handle and manipulate data in various structures and repositories (data cube, data mart, data warehouse, data lake)
• Perform data preparation tasks including data cleaning, normalization, deduplication, type conversion etc.
• Create scripts to analyze and modify data, import/export scripts and execute stored procedures
• Identify opportunities to improve processes and strategies with technology solutions and identify development needs in order to improve and streamline operations
• Work with Product Manager and stakeholders to prioritize product enhancements

About You:

• You have 7-10 years’ of hands on experience in business analysis, documentation and report writing.
• Experience with SQL and/or Python
• Experience with Databricks, Qlik or Power BI is an advantage
• Collatborates effectively with individuals of varying technical ability and business acumen
• Learns quickly and thrives in a fast moving, dynamic atomosphere
• Project management skills with attention to detail and proven ability to multi-task
• Knowledge of Loan Servicing and/or Loan Administration is an advantage
• Understanding of Agile/Scrum methodology as it relates to the software development lifecycle

Our Benefits

Your well-being is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We embrace diversity, prioritizing the hiring of people from diverse backgrounds. Our inclusive culture is a source of pride and strength, fostering innovation and mutual respect.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.

Citco is an Equal Opportunity Employer. It is our policy to make all employment and personnel decisions without discriminating on the basis of race, color, creed, religion, sex, physical disability, mental disability, age, marital status, sexual orientation, citizenship status, national or ethnic origin, and any other protected status.

NOTE: This job description is not intended to be all-inclusive. Employee may perform other related duties to meet the ongoing needs of the organization.

#INDCIT