Role : Data Analyst (Capital Markets, SQL, Python)
Location : Mississauga, ON
Type : Contract
Job Description :
The Senior Data Analyst will be a key contributor to the analytical functions in support of the business's strategic decision-making process.
With a strong foundation in SQL and Python, the ideal candidate will possess in-depth knowledge and experience in the capital markets or banking domain.
This role involves working with large datasets, extracting insights, and providing actionable recommendations to drive business growth and efficiency.
Responsibilities :
Develop and maintain complex SQL queries for data analysis and extraction.
Use Python for data manipulation, cleaning, and analysis, leveraging libraries such as Pandas, NumPy, and SciPy.
Manage and ensure the integrity of large datasets essential for analysis.
Translate data into meaningful insights that address business questions and opportunities.
Create and automate reports, dashboards, and visualizations using tools like Tableau, Power BI, or similar.
Present complex analytical findings in a clear, concise manner to stakeholders and executive teams.
Work closely with business units to identify and analyze core business processes and workflows.
Facilitate data-driven decision-making by providing timely, accurate, and relevant information.
Collaborate with cross-functional teams including IT, Finance, Risk Management, and Operations to support company objectives.
Communicate complex data concepts and the implications of analyses to a non-technical audience.
Support strategic initiatives through scenario modeling and impact analysis.
Contribute to the development and implementation of new data analysis methodologies.
Maintain an up-to-date understanding of the capital markets or banking industry trends, regulations, and best practices.
Apply domain knowledge to enhance data analysis and interpretation.
Requirements :
Minimum of 7 years of experience in a data analysis role within the capital markets or banking sector.
Expertise in SQL and Python is a must.
Strong analytical and problem-solving skills.
Experience with data visualization and business intelligence tools (e.g., Tableau, Power BI).
Excellent verbal and written communication skills.
Ability to work independently and manage multiple tasks and projects.
Understanding of data warehousing and ETL processes.
Knowledge of statistical modeling and machine learning techniques is a plus.
Sr. Business Analyst to support the implementation of a Capital Markets Azure-based Enterprise Data Lake for our banking client
Business Analyst to support the implementation of a Capital Markets Azure-based Enterprise Data Lake for our banking client. Project: Implementation of an Azure-based Enterprise Data Lake within Capital Markets. Platform (Data Lake, DataBricks). Data (Equity Markets, Lending, Brokerage etc. ...
Data Analyst - Payments domain, SQL
Ability to analyze and document data sources, transformation, metadata attributes, sourcing, ability to write, validate data quality rules, triage defects, Proficient in writing queries in SQL. Data Analyst with Payment Domain experience Ability to analyze and document data sources, transformation, ...
2025 Capital Markets, Global Markets Program Summer Analyst (4 Months)
Successful candidates will be placed in one of the businesses that participate as part of the full time Global Markets Program: Maco; Spread; Global Equities; Global Research; and Debt Capital Markets. RBC Capital Markets is a part of the Royal Bank of Canada, one of the largest providers of financi...
Sr Data Engineer with Scala, Spark, Python, SQL and GCP experience to build out a Customer data insights engine.
Sr Data Engineer with Scala, Spark, Python, SQL and GCP experience to build out a Customer data insights engine. Project: Building out a customer data insights tool. ...
Business Systems Analyst, Capital Markets Technology, Derivative Products
Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank’s Corporate, Investment Banking, and Capital Markets businesses. Proficient with SQL queries, PL/SQL, and SQL Loader - or equivalent. Minimum 3 years’ working knowledge of databas...
Risk Analyst - Python, Matlab, SQL, Excel
Risk Analyst - Python, Matlab, SQL, Excel. On behalf of our client in the Banking Sector, PROCOM is looking for a Risk Analyst - Python, Matlab, SQL, Excel. Risk Analyst - Python, Matlab, SQL, Excel – Job Description. Risk Analyst - Python, Matlab, SQL, Excel – Mandatory Skills. ...
Data Scientist, Machine Learning NLP – OpenShift/Python/SQL
Data Scientist, Machine Learning - Cloud/Python/SQL. On behalf of our client in the Banking Sector, PROCOM is looking for a Data Scientist, Machine Learning - Cloud/Python/SQL. Data Scientist, Machine Learning - Cloud/Python/SQL - Job Description. Data Scientist, Machine Learning - Cloud/Python/SQL ...
Business Analyst, Capital Markets – CDS/Broadridge
Business Analyst - Capital Markets - CDS/Broadridge. On behalf of our client in the Banking Sector, PROCOM is looking for a Business Analyst - Capital Markets - CDS/Broadridge. Business Analyst - Capital Markets - CDS/Broadridge – Job Description. Business Analyst - Capital Markets - CDS/Broadridge ...
Business Systems Analyst, Capital Markets Technology, Derivative Products
Global Banking and Markets Engineering (GBME) is the fast-moving, award-winning technology engine that powers Scotiabank's Corporate, Investment Banking, and Capital Markets businesses. Proficient with SQL queries, PL/SQL, and SQL Loader - or equivalent. Minimum 3 years' working knowledge of databas...
Marketing Data Analyst (BI, SQL, Tableau)
In addition, provide ongoing recommendations to leadership utilizing complex data, business knowledge, and strategic assumptions when data doesn’t exist. Advanced proficiency in SQL, A/B Testing, and Data Visualization (Tableau, QlikView). Partner with Marketing team and external agency teams to bui...