Business Data Analyst (Capital Markets)

Jay Analytix•Toronto, ON

3d•Hybrid

About The Position

The primary purpose of this position is to collaborate with Capital Markets (CM) business stakeholders, Quantitative & Technology Services (QTS) IT teams and Enterprise teams to facilitate the broader adoption of the Data Strategy across Capital Markets. Engage and partner with QTS application teams moving onto the Data Insights platform, outlining features and enhancements. Analyze data sets and develop detailed requirements around Sourcing, Infosec classification, Data transformations as appropriate. Coordinate with the platform engineering teams to ensure data/functional requirements are understood and implemented as per specification. Define key performance indicators and regularly analyze product performance to make data-driven decisions. Review and finalize Business requirements for Data Strategy from various streams within QTS and Enterprise. Create functional specifications and design documents aligned with the existing Data Lake architecture. Conduct market research to understand customer needs, market trends, competing products that can be leveraged to solve the Capital Markets business problems.

Requirements

Must have a bachelor’s degree in computer science, Information Systems, or a related field, and 5 years of work experience.
Performing business analysis and requirements gathering for data ingestion & transformation platforms outlining the platform’s features and future direction within the financial industry
Conducting market research to understand customer needs and market trends in order to solve Capital Markets business problems
Overseeing entire product development life cycle, ensuring features are built and deployed in line with the client needs and that the overall product development is aligned with the organizations’ strategy
Performing data analysis on trading data including trades, executions, and orders and running SQL queries to identify anomalies, establish linkages, and define transformation rules
Identifying patterns and relationships between datasets in SQL, Spark SQL, Jupiter Notebook, and data visualization tools like Tableau
Data manipulation, aggregation, and analysis using programming languages including Python
Acting as a liaison between different teams including Architecture, Development, Quality Assurance, UI/UX designers and end clients

Nice To Haves

Experience in projects running on Cloud technologies including Microsoft Azure.
Experience as a data analyst

Responsibilities

Requirement Analysis and documentation
Engage and partner with QTS application teams moving onto the Data Insights platform to understand their analytical use-cases/ business goals and confirm product fitment
Facilitates information gathering sessions, including leading discussions, managing group dynamics, and maintaining group focus, to work towards accomplishing the stated goal(s) of the session within the context of the project objectives - From these information sessions, gathers the requirements and documents these requirements, business use cases, feasibility analysis, cross functional diagrams as needed
Partner with the platform engineering teams to ensure technical capabilities and data requirements are well understood, identify dependencies and integration points
Works with project stakeholders to validate their requirements and analysis models via techniques such as reviews and walkthroughs
Ensures system specifications meet the business stakeholders’ expectations / requirements, and negotiate solutions when appropriate
Data analysis
Analyze incoming data sets and develop detailed requirements around sourcing solutions, identify provisioning requirements, data transformations
Able to perform data coverage analysis using relevant tools, pythons, SQL server queries to confirm if the data sourcing needs are met for relevant business scenarios
Able to decipher compliance, information security guidelines and apply them in the context of the datasets/ business requirements.
Ability to use statistical tools to interpret data sets, paying particular attention to trends and patterns that could be valuable for diagnostic and predictive analytics efforts.
Identify data accuracy requirements, identify solution options, identify remediation plans in case of a breach
Communication and Planning
Builds, sustains, and leverages relationships with individuals within his / her / their area of immediate responsibility when gathering, validating and approving requirements to establish a comfort level in managing relationships and understanding stakeholders’ problems and opportunities.
Participates in reviews or inspections, in collaboration with the project team, to ensure the quality of the deliverables
Develop end to end understand all the aspects of the product, able to conduct product demos independently tailored to the consumer needs.
Participates in the user acceptance testing, implementation planning, post implementation validations and L2 production incident analysis as needed.
Lead business modeling, identify automation, streamlining, simplification opportunities.
Liaison with the product manager to prioritize the product backlog, identify and manage dependencies.
Manage risks, assumptions, and constraints for requirements, and communicate to appropriate parties.
Able to develop user acceptance testing plans covering the business needs, edge case scenarios, what if analysis
Able to develop post implementation validation testing plans, identify scenarios, test cases, able to execute the scenarios and partner with the business teams to obtain the necessary assurance towards the product releases.
Able to manage multiple priorities, own assigned deliverables, manage stakeholder expectations, seek product owner help in case of any escalations needed