Application Development | Level 3

Compunnel Inc.; St. Catharines; On-site; CAD 85,000 - 115,000; Full time

Job summary

A leading company in financial technology is seeking an application developer for its TEDRA department. The role focuses on developing scalable databases for real-time reporting and regulatory compliance. Candidates should possess extensive experience in Java, Scala, and be adept in agile environments. This opportunity allows collaboration within a technical team, enhancing both product development and operational processes.

Qualifications

• 5+ years of experience in Java, Scala, or similar languages.
• Proficiency in scripting languages like Python and Unix/K-Shell.
• Knowledge of trade lifecycle in investment banking is a plus.

Responsibilities

• Design and enhance SQL projection broker for Leto deposits.
• Develop real-time reporting infrastructure capturing upstream messages.
• Translate business requirements into SQL queries and reports.

Skills

Java

Scala

Python

Unix/K-Shell

Agile Development

Database Development

Tools

Informatica

Python Pandas

Job description

Position Description

This application developer role is within the TEDRA (Trade Enrichment Data Reporting & Allocations) department, part of the Institutional Securities Technology (IST) Division. TEDRA manages trading, revenue, risk, and reference data (client, product, and pricing).

The team develops the firm's strategic data mart for ISG deposits, sourcing data from the golden source, the DAL, and feeding it into the data mart in real time. The data is accessible through a consolidated interface for downstream systems to generate reports across multiple data marts. The role involves building scalable, high-performance databases and components for regulatory, business analytics, and operational risk reporting related to Leto deposits and OTC derivatives. The global team is highly technical, involving both hands-on development and project management, working on multiple projects simultaneously. Close collaboration with operations partners is essential.

The development process follows agile methodologies, including Scrum and Kanban, with practices like continuous integration, refactoring, and unit testing. Collaboration within a larger team is expected.

Key Responsibilities :

• Design, build, and enhance the SQL projection broker in DAL for Leto deposits, ensuring performance and scalability.
• Develop and support real-time reporting infrastructure that captures upstream messages, persists data onto NFS storage, and shreds attributes into database tables for reporting.
• Maintain and enhance regulatory and business reports for Leto deposits.
• Translate business requirements into SQL queries and produce reports accordingly.
• Perform database and ETL development, including stored procedures, queries, and performance tuning using SQL and tools like Informatica or Python Pandas.
• Create automated testing processes for Java, Scala, or Python applications.
• Work alongside skilled team members experienced in domain modeling, database design, big data, Java, and messaging.

Skills Required / Desired :

• 5+ years of experience in Java, Scala, or similar programming languages.
• Proficiency in scripting languages such as Python and Unix/K-Shell.
• Knowledge of trade lifecycle and data flows in investment banking is a plus.
• Experience with Agile development processes.
• Relational database knowledge is advantageous.
• Strong team player with integrity and ownership qualities.