Analyst, Data Management Operations - 12 month contract
The opportunity
The Data Management Operations team is responsible for the management of Ontario Teachers’ Pension Plan security master, legal entity, market and reference data asset by ensuring the sustainable quality in the repositories and the downstream applications.
The Analyst, Data Management Operations will support various systems associated with activities related to the collection, validation, archiving, and distribution of security master, legal entity, market and reference data to applications within Teachers’.
You will complete testing, documentation, data validation, data input for a variety of traded instruments, including equities, fixed income, options, futures, FX, and complex derivative products.
Who you'll work with
You will work closely with members of Financial Operations, Capital Markets, Investment Finance (Performance Analytics, Risk Analytics, Total Fund Reporting), Compliance and Information Technology;
the role will involve liaising and collaborating with various internal and external service providers in the delivery of solutions to meet the Plan’s changing requirements.
What you'll do
1. Carries out daily work within Data Management Operations
Ensure overnight processing has completed, work with internal and external teams to resolve any daily issues
Identify, analyze, respond to and resolve issues and problems
Determines and carries out appropriate solutions for issues and problems
Works with team members to ensure all critical priorities for the team are completed in the day
Recognizes database problems and takes appropriate action while ensuring compliance with business practices and policies
Provide assistance to team members as needed and provides back up during absences
Ensure documentation is maintained and up to date
2. Verify information and upholds controls
Manage the data exception process and resolve data exceptions generated by automated processing procedures
Checks and reconciles information to ensure accuracy.
Applies controls, checks and balances
Follows up on discrepancies and resolves discrepancies
Escalate issues as appropriate
Measure adherence to Service Level Agreements
3. Produces metric reports
Collect information for metric reporting with Business Intelligence Applications
Review metrics and escalate issues for analysis
4. Assists as required as a data resource on projects for the department under the guidance of the Manager or Senior Manager
Understands the flow and transformations of securities, legal entity and reference data from data vendor products used to source data various Teachers’ applications and repositories
Positively contribute to the delivery of project and change management initiatives
5. Identifies and carries out improvements for the unit :
Actively identifies efficiency improvements
Investigates and implements improvements
Assist in development / testing / implementation of new processes / systems
Collaborate on recommendations for process changes and improvements
Ensure up to date documentation
6. Produce reports for Internal and Audit purposes :
Generate standard reports for review by management
7. Service internal and external clients :
Provides global data expertise and service to internal clients
Responds to inquiries and requests from internal clients
Deals with internal clients in a professional and timely manner
8. Deal with internal and external suppliers :
Requests information as needed from data vendors and internal Investment Finance Operations
9. Other :
Investigates system handling of data products including testing of problems and testing of new systems
Maximize the use of technology in all work processes
Provide constructive ideas relative to Plan's operations
Maintain knowledge of issues affecting Plan's operations
Represents Teachers’ in a professional manner
Other duties as requested
What you'll need
Relevant university degree (such as Finance, Economics, Accounting, Computer Science) or equivalent relevant experience with Investment Finance processes
Knowledge in the following areas :
Security master Listed, derivatives, market indices, alternative investments
Legal Entities parties and investment vehicles
Pricing both market available and evaluated
Corporate actions and associated lifecycle events
Reference data asset / industry classification, holiday calendar
Ability to communicate effectively with the business and Information Technology
Excellent analytical skills and the ability to think through problems, assess a variety of factors and recommend a solution
Proficient in Excel, PowerPoint, SQL and Python
Working knowledge of Microsoft Power Apps, Power BI, Power Automate, Copilot and Confluence are an asset
Good knowledge of third-party data vendors, along with experience using Bloomberg
Asset if knowledgeable with asset management systems and platforms such as : security master and legal entity data management (Markit EDM, Charles River and SimCorp)
Understanding of database technology and concepts
Must be able to work to deadlines, adapt to a rapidly changing environment and sustain high productivity levels
Must be extremely detail oriented, organized and thorough
Self-starter, confident, innovative, team player
Good interpersonal and communication skills
Must be able to effectively deal with internal and external clients and suppliers
Ability to work with minimum supervision
Canadian Securities Course or a designation (CFA, CPA, FRM etc) would be an asset
Ability to cover early morning and end of day shifts
LI-VN, #LI-Hybrid
What we’re offering
Competitive compensation
Numerous opportunities for professional growth and development
A flexible / hybrid work environment combining in office collaboration and remote working
Our Flexible Travel Program gives you the option to work abroad in another region / country for up to a month each year
Employee discount programs including Edvantage and Perkopolis
At Ontario Teachers', diversity is one of our core strengths. We take pride in ensuring that the people we hire and the culture we create, reflect and embrace diversity of thought, background and experience.
Through our Diversity, Equity and Inclusion strategy and our Employee Resource Groups (ERGs), we celebrate diversity and foster inclusion through events for colleagues to connect for professional development, networking & mentoring.
We are building an inclusive and equitable workplace where our talent is respected, accepted and empowered to be themselves.
To learn more about our commitment to Diversity, Equity and Inclusion, check out Life at Teachers'.
How to apply
Are you ready to pursue new challenges and take your career to the next level? Apply today! You may be invited to complete a pre-recorded digital interview as part of your application.
Accommodations are available upon request ([email protected]) for candidates with a disability taking part in the recruitment process and once hired.
Candidates must be legally entitled to work in the country where this role is located.
The privacy of your personal information is important to us. Please visit our Privacy Centre to learn how we handle your personal information.
Functional Areas : Finance
Finance
Requisition ID : 5841
5841
Sr. Manager, Customer Preference Management Regulatory Program - 12 Month Contract
The Senior Manager is responsible for leading the overall success of the Customer Preference Management Regulatory Program (Operating Practices), providing subject matter expertise and regulatory governance over customer preference management and compliance with Canadian marketing regulations, inter...
Financial Analyst (Finance) - 12 Month Contract
The Financial Analyst will support monthly revenue and expense forecasts, annual budget, variance analysis, and other projects requested by senior management. Participate in month end close through pre month-end close review of department GL entries and accruals. Prepares management reporting for cl...
BILINGUAL ANALYST, CLIENT CONTACT CENTRE– Temporary 12 month contract
The Business Analyst, Customer Contact Center receives and processes telephone and electronic inquiries sent to the Customer Contact Center. The analyst assists entrepreneur. We offer an exceptional work environment and the opportunity to work from one of our 123 business centers across the country....
National Coordinator, Partnerships and Corporate Philanthropy (12-Month Contract)
Track all payments and coordinate with Leadership Giving Operations and Finance to ensure timely data entry, coding and allocations. Record and track all solicitations, gift and partnership deliverables, submission and reporting deadlines, and moves management activities in CRM for partners;. Mainta...
Marketing Manager, Coors Seltzer (12 month contract)
In the role of Coors Seltzer Marketing Manager (12 Month Contract), you’ll be part of the Canadian Brand Marketing team. Accelerate Molson Coors Canada’s commercial capability to become First Choice for Consumers and Customers, providing the strategic leadership, direction, and management for one of...
First Nations/Metis/Inuit Candidates - Social Media Manager, 12-Month Contract
Self-Identify as First Nations, Metis, or Inuit * Strong oral/written communication skills * Post-secondary degree, diploma, or certification in Marketing, Digital Marketing, or a related field * Experience in managing enterprise social media communities * Experience managing enterprise social media...
Sourcing Operations Lead (18-Month Contract)
The Sourcing Operations Lead is a subject matter expert for Procurement policies, processes, systems and tools. Process owner for the Master Vendor File in SAP including the process for adding, modifying and deleting suppliers in the database for all Spin Master regions globally. Support and maintai...
Drug Database Associate (12 Month Contract) - Express Scripts Canada
The primary function of the Drug Database Associate is to update and maintain ESC’s database, leveraging multiple sources, using their knowledge and experience from retail pharmacy. Uses documented processes to apply provincial coverage and price changes from source files for each field in the datab...
Financial Analyst, Capital Markets Accounting (6 month contract)
Inspire adherence to timing in Service Level Agreements and support the investigation and analysis of different methodologies by liaising with the Front Office, the CFO group, Accounting Policy, Reporting COE, Reconciliations COE and Operations. ...
Senior Financial Analyst (6 Months Contract)
Partner with teams from the Accounting Center of Excellence (A2R COE) for month-end close activities, including analysis and reporting of results by focusing on key drivers for sales and pretax profit variances. Liaising with the FP&A Global Delivery Center (GDC) and other cross-functional leads to ...