Technical Business Analyst- Capital Markets
Typical Day in Role
• Research, formulate, and perform data-driven analytics using SQL and/or other tools such as Elastic Search, Postman, and Kibana.
• Assist in resolving complex, multi-faceted problems to meet the system needs of the Institutional Equity Trading Desks and their internal and external customers, by applying your business and technological knowledge to perform analysis, reconciliations, defining user requirements, design and implementation of system enhancements/solutions.
• Support, liaison, and gather requirements from senior stakeholders and clearly articulate business requirements to technical teams.
• Working with technology and business partners and stakeholders to do data mapping, data analysis, order and trade data mapping from federated systems (Fidessa real-time trade/order data is being mapped into a consolidated data model).
• Test, validate, create artifacts, and deploy solution to production environment
• Working with data platform team and connect with other teams from data governance, etc. to deploy solution from one environment to another.
• Work with raw data from developers to publish data to different topics (understanding of NiFi is required)
• Working primarily with institutional equities
• Ability to multi-task, meet deadlines, perform under pressure, and change priorities as needed.
Candidate Requirements/Must Have Skills:
• 10+ years’ experience in a relevant capacity as a technical BA
• Understanding of capital markets data (trade lifecycle, securities, equities post-trade processes, institutional equities, etc)
– in-depth knowledge of Capital Markets data analysis, data mapping, data publication/consumption and business requirements relating to Kafka and FIX (Financial Information Exchange) messages.
• Strong data driven analysis knowledge, ability to write/run queries in SQL and Python
• Experience working with NiFi or other ETL tools to understand how flows work
• Need to have strong background in Elastic Search and streaming data
• Understanding of how FIX Protocols work, professional experience in this realm
Nice-To-Have Skills:
• Vendor application and federated trading platforms experience with products such as Fidessa, Bloomberg, Broadridge, etc. is an asset
• Elastic Search experience is an asset
• Real-time data processing/Kafka experience to analyze and help develop solutions is an asset
• Ability to work with third-party APIs, Postman, and other API/data tools is an asset
• Knowledge/experience with reporting tools/platforms such as Kibana, Excel Macros/Pivots, and other similar tools is an asset
Soft Skills:
• Great communication (verbal and written)
• Ability to prioritize, produce plans, and deliver on deadlines
Degrees or certifications:
• Bachelor’s degree in a relevant field required
• Financial education (relevant courses, CSC, CFA…) will be considered as an asset
• Work experience is prioritized over educational background