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.
• Regular deliverables include creation of source to target mapping
• 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.
• Building relationships with vendors to allow for regular communication for needs and adequate time to implement changes
• Working with technology and business partners and stakeholders to do data mapping, data analysis, order and trade data mapping from federated systems (TT and Tradebook data is being mapped into a consolidated data model).
• Test, validate, and deploy solution to production environment
• Create artifacts required for deployments
• 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 reroute data to different topics (understanding of NiFi is required)
• Working primarily with institutional equities
• Analysis of business needs (trading, regulatory, etc.) resulting in the creation of requirement
• Build relationships and work with key stakeholders to quickly deliver value added solutions.
• Produce conceptual interface designs through iterative wireframes, mock-ups, user flows, conceptual diagrams and provide detailed specifications to the development team
• Ability to multi-task, meet deadlines, perform under pressure, and change priorities as needed.
Candidate Requirements/Must Have Skills:
• 5+ years’ experience in a relevant capacity as a technical BA
• 2+ years’ experience within capital markets data (trade lifecycle, securities, doing reconciliations, vendor management, equities post-trade processes, institutional equities, etc)
o in-depth knowledge of Capital Markets data analysis, data mapping, data publication/consumption and business
• Understanding of how FIX Protocols work, professional experience in this realm
• Strong data driven analysis knowledge, ability to write SQL queries
• Seeking candidate with strong hands-on experience in at least two of the following (in order of preference): Kafka, NiFi, Elastic Search, and/or Kibana
• SDLC, data/business analysis experience
• Documentation skills (ability to produce conceptual interface designs through iterative wireframes, mock-ups, user flows, conceptual diagrams and provide detailed specifications to the development team)
Nice-To-Have Skills:
• Experience with other ETL tools to understand how flows work
• Ability to work with third-party APIs, Postman, and other API/data tools.
• Knowledge/experience with reporting tools/platforms such as Business Objects, Power BI, Excel Macros/Pivots, and other similar tools.
• Hadoop/Big Data experience to analyze and help develop solutions
• Vendor application and federated trading platforms experience with products such as Duco, Fidessa, Bloomberg, etc
• Prior experience with Jira, Confluence, and ServiceNow.
Soft Skills:
• Great communication (verbal and written) required
• Ability to prioritize, produce plans, and deliver on deadlines
Degrees or certifications:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• Financial education (relevant courses, CSC, CFA…) will be considered as an asset.