Business Systems Analyst, Capital Markets (Revenue Reporting, SQL) On behalf of our client in the Banking Sector, PROCOM is looking for a Business Systems Analyst, Capital Markets (Revenue Reporting, SQL). Business Systems Analyst, Capital Markets (Revenue Reporting, SQL) - Job Description
The incumbent acts as technical business/data analyst resource in projects, providing detailed technical data analysis, testing, investigations, recommendations, program specifications and business requirements for development of technical solutions for the sourcing, delivery, and processing of required monthly/daily data sources within the distributed technical architecture to support client profitability and analytics for wholesale customers
Supported by knowledge of wholesale business products and detailed understanding of Bank source applications, the incumbent uses technical knowledge and business/data insights to design and build specifications for operationally stable processes that extract, transform, and map raw data to organized/structured schemas for the purpose of consistent reporting and analytics
The incumbent supports technical peers in the team and collaborate with business partners, data engineers and cross functional IT teams to deliver complex, creative, cost-effective and robust operationally stable data solutions
This includes development of complex queries against big data that are required to ensure data are accessible for analytics and reporting by the data teams, as well as providing oversight of reporting solutions using Tableau, and/or other industry standard BI tools
Business Systems Analyst, Capital Markets (Revenue Reporting, SQL) - Mandatory Skills
5-7 years of experience working in a similar capacity as a BA/BSA
Recent project experience writing intermediate to advanced queries using SQL
3+ years' finance/accounting background (experience with revenue reporting and P&L)
2+ years' experience in capital markets (product knowledge, working with big data, middle to back-office experience)
Ability to work as part of a team, as well as work independently or with minimal direction
Excellent written, presentation, and verbal communication skills
Bachelor's degree in a technical field such as computer science, computer engineering or related field required
CFA designation or similar workplace experience
Prior courses taken in mathematics (statistical analysis and discreet mathematics)
Business Systems Analyst, Capital Markets (Revenue Reporting, SQL)- Preferred Skills
Power BI is a strong asset
Financial courses or certification completion is an asset
Business Systems Analyst, Capital Markets (Revenue Reporting, SQL) - Assignment Start Date ASAP - 6 months to start Business Systems Analyst, Capital Markets (Revenue Reporting, SQL) - Assignment Location Toronto, ON - Work Hybrid