Sr. Data Modeller/Business Analyst needed for large-scale data initiatives in equity markets, building scalable data structures for analytics and reporting.
Responsibilities
Design and develop Silver Layer tables and views to support analytics and reporting needs. Build scalable data models supporting batch processing and future real-time use cases. Collaborate with business analysts, data analysts, and technology teams to gather requirements and define data structures. Perform data profiling, exploration, and analysis leveraging SQL and Python/PySpark. Define data relationships, formats, and standards to enhance data consistency and usability. Analyze large data sets to identify trends, anomalies, and actionable insights. Optimize datasets for BI tools such as Power BI and real-time analytics platforms. Support data ingestion initiatives by ensuring high-quality, reusable datasets for downstream applications. Work within an Azure Databricks environment to support historical and real-time analytics.
Requirements
5+ years of experience in data analytics, data modelling, or business intelligence roles. Proven hands-on relational data modelling experience, including designing table structures, relationships, and schemas. Advanced proficiency in SQL. Intermediate experience with Python, including PySpark for data profiling and exploration. Strong ability to translate business needs into effective technical data solutions. Deep understanding of data quality, profiling, and optimisation techniques. Excellent cross-functional collaboration skills with technical and business stakeholders. Degree in a quantitative discipline (e.g., Computer Science, Mathematics, Statistics, Engineering, Economics, Physics, Business).
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.
Data Analyst supporting client data migrations and corporate actions for Computershare, a global financial administration and transfer agency leader. Ensuring data quality, mapping, validation, and operational sign - off.
Associate Director advancing UJA Toronto’s nonprofit fundraising through donor analytics, predictive modeling, and prospect intelligence. Leading data strategy, pipeline development, and a two - person analytics team.
Sales Force Effectiveness Specialist optimizing territories, targeting and dashboards for GSK, a global biopharma company. Translating sales and market data into actionable commercial insights.
Water and wastewater planning consultant analyzing infrastructure data, forecasting demand, and developing sustainable servicing strategies. Supporting KWL’s consulting engineering projects across Western Canada.
Data analytics intern supporting TD Insurance’s data governance, operational insights, datasets, dashboards, and reporting. Four - month Winter 2027 placement in Montréal or Toronto.
Bilingual Data Analyst translating General Motors social data into performance insights at independent creative agency Rethink. Building reports, dashboards, and recommendations for campaigns and content.