Skip to Main Content

Job Title


Technical Business Analyst


Company : Open Systems Technologies


Location : Mississauga, Ontario


Created : 2025-05-09


Job Type : Full Time


Job Description

Financial Product Reference Data Solution Engineer SQL (Senior) Job Description: Financial Data Modeling Capabilities Data Analysis for complex systems Reverse engineering functional specifications from data Work closely with End Users/Clients to understand Business Process/Industry Standards/Regulatory Mandate requirements. Work closely with IT and Operations partners Work with external data vendors (i.e., Bloomberg, Reuters, IDC, Markit, etc) and standards organizations Able to execute projects Independently Conduct Systems Integrated Testing (SIT) and User Acceptance Testing (UAT) Create Function Specification Documents (FSD), System Requirement Specification (SRS), and test plans Mentor and coaching lower-level analysts Qualifications: Working experience of 8+ years min. as Business Analyst SR business analyst lead a group of BAs candidate will become a program lead eventually. Work with stakeholders. Steer the program. 8-15 years of experience is required. project execution core technology BA is really what they want. Not someone who has been a BA then moved to be a PM. Capital markets experience, trade life cycle understanding and experience. Strong SQL skills. data hub, model data, need to know how data modeling works. Data modeling skills are required. 50% of the work for this role is data analysis. They need to be advanced in SQL to be considered. Strong background in financial reference data and capital markets Strong SQL knowledge required (able to query data, analyze and troubleshooting) Strong Data analysis and Mapping skills College degree, specialized training or equivalent work experience Data Oriented with an excellent attention to detail Experience/understanding of business process reengineering and business modeling concepts, systems development lifecycle Strong analytical skills and writing skills, to include solid experience in writing functional and technical specifications Must possess good communication skills with the ability to be assertive Ability to focus on high quality work while under pressure Experience utilizing various SDLC methodologies like Waterfall, Agile (JIRA etc.) Comprehensive knowledge of the Testing Lifecycle with SIT, UAT, and Production. Preferred Skills Experience working with major vendor data providers (i.e., Bloomberg, Reuters, IDC, Markit) Project lead experience Experience of working closely with IT Project managers and development teams Knowledge of MS Excel, Visio Experience with vendor product implementation