Previous Job
Pythong/Perl Developer
Ref No.: 18-16146
Location: Montreal, Quebec

Job Title: Data Analytics, Visualization and Business Intelligence Developer


Brokerage maintains a leading market position in Institutional Securities Sales and Trading. TEDRA (Trade Enrichment Data Reporting & Allocations) is part of the Institutional Securities Technology (IST) Division. It is responsible for maintaining, distributing, and reporting on trading, revenue, risk, and reference data (client, product, and pricing). As the authoritative source of key data sets, we are at the forefront of database technology and are heavily involved in data engineering, data science, data visualization, and machine learning efforts across the Firm. Within TEDRA, the Internal Trade Activity Reporting Applications Practice Area (ITARA) develops and supports systems and infrastructure for trade data-related report generation and distribution, high performance business intelligence platforms, data extraction, and data marts for internal users. Within ITARA, the Equity Reporting team is charged with providing innovative Data Analytics, Visualization and Business Intelligence for our users. This includes building data marts, Business Intelligence solutions and standalone reports that have the requisite functionality and performance to meet their needs. Projects cover a broad range of usage including Sales and Trading Desks, Finance, Operations, External Counterparties and Technology.

Role Profile:

You will be working closely with the business stakeholders to understand their objectives and requirements. Distilling these into technology deliverables and taking ownership of the delivery of these across all stages of the development lifecycle. You will be extensively involved data-led projects from gathering initial requirements through to development and delivery. You will assist in generating data for business users on an ad-hoc basis. You will learn about the business flows within the firm and how these are represented in the databases we own. You will be expected to apply this expertise when building reporting solutions. You should have proven experience of working with business users, forming and managing strong working relationships. You should have extensive experience in databases and SQL that you could utilize in this role. You will be building data extracts/feeds, presentation layers, regular reports and data-marts that support business needs. You will be building analytics dashboards using BI tools (Business Objects, Tableau, Qlikview)

Desired Skills:

Minimum 3 years' experience in a data-oriented role
Strong SQL development experience (Sybase, DB2, ORACLE or MS SQL Server)
Strong knowledge of relational databases, SQL, and SQL tuning
Self-starter with a client-focused attitude
Knowledge of equity sales and trading would be beneficial
Some knowledge of BI Tooling
Proficient in PERL/Python (Can substitute proficiency in Java or C# if interested in learning PERL)