Senior Systems/Data Analyst
Mackenzie Investments
- Toronto, ON
- Permanent
- Full-time
- Works with the Lead Systems Analyst, Delivery Lead, Project Manager and other Team Members to create and/or collaborate on project deliverables eg technical/interface specifications, data mappings etc
- Decomposes and visualizes work into Jiras; attends standup meetings and advises on progress
- Supports the Testing efforts and will be involved in Interface/Integration Testing
- Required Standard Items
- Five+ years of technical Systems/Data analysis or equivalent experience
- Experience working with Software Developers, Architects and Quality Assurance Analysts and to analyze technical solutions, test completed code, and complete a smooth implementation with business partners and external vendors/vendor solutions
- Knowledge of solution architecture, application development, application systems design, and integration patterns
- Ability to self-direct, own tasks, manage time to meet deadlines, and provide appropriate status to leadership
- Ability to manage multiple priorities in a face-paced work environment
- Capability to establish and maintain effective partnerships and relationships
- Knowledge/Domain and Industry Expertise (and/or equivalent experiences)
- Wealth Management/Capital Markets and Financial Services Industry knowledge
- Investment management and Fund Services systems / applications knowledge/experience – e.g. Bloomberg, FactSet, Eagle, OnCore, Wealth360 (Fund Accounting), InvestOne etc. and data associated with these systems
- Market data vendors and sourcing knowledge – e.g. benchmarks, reference data, economic data, ESG, etc
- Experience working in a technology project team environment and on projects involving the integration of disparate types of technologies/platforms
- Technical Skills (and/or equivalent experiences)
- Proficient in Data Mapping and creating System Specification documentation; ability to understand json and similar files
- Oracle SQL skills and experience performing data analysis
- Python, non-SQL DB (MongoDB), visualization tools (e.g. Tableau), cloud-based services/ tools
- Historical use of Confluence, Jira
- Estimating experience
- Bonus Points
- Experience with data transformation related projects
- Experience with BNYM’s OnCore or Eagle Platforms
- Post-secondary education in a related discipline
- Canadian Securities Course (CSC), CFA Levels
- Kanban or Scrum Certifications
- IIBA Certifications
- Project Management (PMP) and/or Change Management (CCMP, Prosci) Designations