Trade reporting Business analyst
The Global Wholesale, Wealth, and Risk Technology - Analytics team is responsible for servicing Global Capital Markets worldwide and delivering data storage and analytics solutions to all business lines, Equities, FX, FI, Derivatives, Commodities, etc.
An End User Computing prototype Big Data solution has been developed for reporting Client Metrics and Sales. This now needs to be productionized, made to be industrial strength, enhanced and maintained. The incumbent is responsible for detailed analysis of the current system at both a technical and functional level and re-specification of the non-functional components in accordance with Scotiabank standards and industry best practice. Special emphasis will be placed on segregation of duties and user access permissioning hierarchies.
The role carries responsibility for the detailed specification of the solution with an emphasis on understand current user requirements and building a relationship which is conducive to a self service approach to data analysis using the reporting tool set.
will be expected to work with the programmers on the team to plot the route from the current implementation to a robust, maintainable and well document system set using the most expedient route paying attention to both eventual quality and cost of delivery.
Experience in Capital markets and a good knowledge in financial instruments, ranging from derivative products (IR, Credit, and Equity) to foreign exchange is must.
Looking for creative, self-starting, results-oriented, and highly motivated individual with attention to details and excellent problem solving skills. The incumbent needs to be able to multi-task and work in a fast paced and agile environment
must also possess a very good understanding of current IT practices, systems design and development techniques, including testing methodologies, and keep current with rapidly changing technology.
Minimum of 7-10 years of industry experience.
Key Accountabilities: 1. Document an existing Hadoop based data aggregation and reporting application taking it from prototype to production deployment 2. Work with the user community to analyze and document new reporting requirements, assist in the set-up of a self-serve data mart type environment for client Value Reporting 3. Ensure that all solutions proposed are in harmony with the technology stack being used for the application and harmonize it with the broader Global Capital Markets Technology Strategy. 4. Develop and then execute a plan to put a robust set of non-functional controls, processes and procedures around the application to ensure maximum uptime and minimize mean time to recovery. 5. Assist with integration of the application into the Scotiabank state of the art DevOps infrastructure for automated build/ automated deployment. 6. Development of feeds into the system using a variety of technologies tools like ETL, EAI or Apache NiFi. 7. Documentation of the system to a level which can be handed over to a third line support team. 8. Preparation of specifications and documentation for all software developed. Use of standard project management and team collaboration tools
Functional Competencies:: 1. Expert: Understanding of Trades, Trade Reporting, Client Valuation and Profitability reporting 2. A very good knowledge of financial instruments, how they are represented in trading and risk systems. 3. Good: SQL 4. 5+ years of data integration and reporting experience 5. Experience working in an agile team 6. Excellent written and oral communication skills
Nice to have: 7. Tableau or a similar visual BI tool
ABOUT ProVision :
ProVision is a leading provider of professional talent to key organisations both private and public throughout Canada. Our services include: contract consulting, contingent permanent search, and retained executive search.
With over 15 years of concurrent exceptional relationships with clients in the financial, government, and software engineering verticals, ProVision has built up an exceptional network of industry leading professionals in the IT, Finance & Accounting, and Human Resources sectors.
We have a team of senior recruitment and account management professionals with a wide array of specialities who can help you with your search for a new assignment, career change, or that hard to find individual to complete your team.
Please get in contact with me, and I’ ll connect you to the right individual. It’ s what we do.