Senior Associate Director, IT, Data Modeler / Report Developer

Location: Toronto, ON, ca

Company Description

MUFG Investor Services provides asset servicing solutions to the global investment management industry. Leveraging the financial and intellectual capital of MUFG – one of the largest banks in the world with $2.8 trillion in assets – we provide clients access to a range of leading solutions from fund administration, middle-office outsourcing, custody, foreign exchange, trustee services and depository to securities lending and other banking services.

With a diverse and dynamic network of offices across the globe, MUFG Investor Services provides challenging and rewarding careers. We achieve this by offering continuous learning and development, collaborative team work environment, promotion of work-life integration, and exposure to a wide variety of work.

Imagine your future at MUFG Investor Services where you can grow professionally, in a diverse and inclusive workplace that rewards your contribution. 

#LI-Hybrid

Job Description

The Senior Associate Director, IT, Data Modelling and Reporting will report to IT Head of Reporting & Analytics, and work closely with leadership in IT, Operations and Product Management team to elevate firm data modelling and reporting & analytics capability on MUFG Data Hub, including but not limited to:

• Data Modelling & Architecture: Design and maintain conceptual, logical, and physical data models for investment accounting, focusing on transactional, holding, and valuation data (Investran, Geneva, Mantra, Yardi).
• System Integration Support: Work closely with Data Engineering team to Map data from varied systems into a standardized data model, ensuring structural integrity and handling complex public market data and non-standardized private market data.
• Accounting Systems Expertise: Work closely with platforms like Investran or Geneva to understand GL structures, capital calls, distributions, and performance calculations to build robust data structures.
• Performance & Reporting Models: Create models optimized for portfolio analytics, performance attribution, and investor reporting.
• SQL Optimization: Develop complex SQL queries and support ETL processes, ensuring high-performance data loading and transformation.
• Data Governance: Define data definitions, lineage, and metadata standards to ensure data quality and auditability. 

#LI-Hybrid

Qualifications

• Bachelor’s degree in Computer Science, or a related field.
• 10+ years of experience in data modelling and reporting; experience in financial services, with a focus on investment management, private equity / Hedge funds is preferred.
• 3+ years of leadership experience in a reporting and analytics role.
• Proficiency in programming languages or tools like SQL, Python or R.
• Experience on Databricks, Snowflake or Amazon Redshift (AWS) etc cloud data platforms.
• Experience of working on various investment reporting systems like Geneva, Mantra, Investran, Yardi etc.
• Familiar with data visualization tools (PowerBI, Tableau).
• Strong communication and interpersonal skills with the ability to present complex data to non-technical audience.
• Ability to work in a fast-paced, results driven environment.

Additional Information

At MUFG Investor Services, we are exceptionally proud of our approach to Hybrid Working. It enables the flexibility to thrive from wherever our employees work and, stay connected to their team and our culture. When we make Hybrid Working plans, we get to know the individual and pride ourselves in underpinning all our decisions with fairness and consistency.

MUFG Investor Services provides all of its employees with an extremely attractive compensation package. In addition to base salary, there is a group medical insurance scheme, group pension scheme, reimbursement of professional subscriptions, paid holidays and assistance towards gym memberships.

We thank all candidates for applying; however, only those proceeding to the interview stage will be contacted. If you are contacted for a job opportunity, please advise us of any accommodations needed to ensure fair and equitable access throughout the recruitment and selection process. All accommodation information provided will be treated as confidential and used only to provide an accessible candidate experience.

MUFG is an equal opportunity employer.