Python Jobs in Montreal-Ouest, QC

Job Description

Job Description

Business Background Position is for a role in TEDRA department. TEDRA is part of the Institutional Securities Technology (IST) Division. It is responsible for maintaining, distributing, and reporting on 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.

Position Description:
This is an application developer role in the team responsible for developing on the firm’s strategic data mart for ISG deposit. The data will be sourced from the golden source, the DAL and fed into our data mart in real time. The data will further be provided through a consolidated interface allowing our downstream systems to conveniently extract reports across multiple data marts. The candidate will be as part of the team involved in building scalable and high performance database and components for regulatory, business analytics (metrics reporting) and operational risk reporting for Leto deposits and OTC derivatives. The global team consists of highly technical team members who are adaptable to both hands on development and project management. We deliver multiple projects for multiple business areas in parallel. The business owners and subject matter experts will be globally distributed, making communication and pro-active to be important. You will be expected to work closely with our operations partners on requirements for projects.The development will be performed using an agile methodology which is based on scrum (timeboxing, daily scrum meetings, retrospectives, etc.), Kanban Jira Boards and XP (continuous integration, refactoring, unit testing, etc.) best practices. The candidate will be able to work collaboratively within a larger team. Key Responsibilities:
* Design, build and enhance the SQL projection broker in DAL(data access layer) for Leto deposits with good performance and scalability
* Design, build and enhance the real-time reporting infrastructure which captures the upstream messages, persists onto NFS storage, and shred attributes into database tables for reporting purpose.
* Enhance and support multiple regulatory/business reports for Leto deposits
* Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
* Database and ETL development, including stored procedures, queries, performance tuning etc, using SQL and ETL tools such as Informatica or Python Pandas.
* Create efficient testing automation for Java/Scala/Python processes.The current global team members are all very skilled in domain modeling, database design, big data, Java and messaging so this is an excellent opportunity to play a key role in the growing team. Skills Required/Desired:
* Strong in Java/Scala or other programming languages with 5y+ relevant experience
* Strong with scripting language such as Python and Unix / K-Shell
* Familiar with lifecycle of flows of data in an investment banking operation is a plus.
* Experienced in Agile development process* Knowledge on relational databases is a big plus * Good team player; Integrity & ownership