Analytics Developer (6 month contract)

AGF; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A global asset management firm in Toronto is seeking a Data Engineer for a six-month contract to assist in data integration and reporting solutions. The role involves developing and maintaining ETL/ELT pipelines and supporting legacy reporting systems. Candidates should have a relevant degree, 2+ years in data engineering, and strong SQL and programming skills. This role encourages applications from individuals of diverse backgrounds.

Benefits

Equal opportunity employer

Support for applications from diverse backgrounds

Qualifications

• Minimum 2+ years professional working experience as a Data Engineer or related role.
• Strong understanding of SQL and at least one programming language.
• Experience working with Business Intelligence tools and Data Warehousing.

Responsibilities

• Assist in building, maintaining, and optimizing data pipelines.
• Collect, integrate, and store data from different sources.
• Implement and perform data quality checks.

Skills

Relational Data Management Systems

SQL

Data Engineering

Communication Skills

Problem Solving

Education

Bachelor’s degree in a relevant field

Tools

ETL tools

Power BI

Microsoft SQL Server

AWS

Job description

Overview

About AGF

Founded in 1957, AGF Management Limited (AGF) is an independent and globally diverse asset management firm. Our companies deliver excellence in investing in the public and private markets through three distinct business lines: AGF Investments, AGF Capital Partners and AGF Private Wealth. AGF brings a disciplined approach, focused on incorporating sound, responsible and sustainable corporate practices. The firm’s collective investment expertise, driven by its fundamental, quantitative and private investing capabilities, extends globally to a wide range of clients, from financial advisors and their clients to high-net worth and institutional investors including pension plans, corporate plans, sovereign wealth funds, endowments and foundations.

About the team

The Business Analytics Development Team supports many of the reporting and business technology solutions within AGF. The team works closely with various departments within the organization to design and build data integration and reporting solutions using industry leading tools. Team members work on both new projects and steady state maintenance of our mission critical reports, systems, and applications.

About the role

This role is for a six-month contract position. Reporting to the Manager of Business Analytics Development, your main duties will be to assist in the design, development, quality assurance, and maintenance of existing ETL/ELT pipelines that integrate our data with our various systems, and to provide data sets for reporting. In addition, you will be helping support legacy reporting and application solutions that have been primarily developed in .NET (C#), with extensive integration to our databases and queries.

Your Responsibilities

• Assist in building, maintaining, and optimizing data pipelines and ETL/ELT processes to ensure data is efficiently moved and transformed.
• Collect, integrate, and store data from different sources, transforming it into a format suitable for analysis.
• Assist in the design, development, and maintenance of reports and dashboards using various reporting tools.
• Implement and perform data quality checks, testing procedures, troubleshoot issues, and help maintain our various reporting and data integration systems.
• Maintain and enhance database views, functions and stored procedures used in our reporting databases.
• Contribute to documentation, including technical specifications and user guides.
• Support, troubleshoot, and resolve technical issues with data pipelines and various reporting systems to ensure uninterrupted operations.
• Work closely with senior developers and other team members to develop technical solutions and implement data engineering best practices.
• Contribute to ongoing technology and process improvements through understanding our client’s needs and AGF’s data and systems needed to build reports and information delivery solutions.

Your Qualifications

• Bachelor’s degree in a relevant field (Computer Science, Engineering, etc.) or equivalent experience.
• Minimum 2+ years professional working experience as a Data Engineer or related role.
• Strong understanding of Relational Data Management Systems, SQL, relational databases and at least one programming language (e.g. JavaScript, .NET C#, Python, etc.) is required.
• Knowledge of HTML, CSS, JavaScript and frontend development principles.
• Familiarity with data processing concepts and database management systems.
• Experience working with Business Intelligence tools and Data Warehousing.
• Strong written and verbal communication skills to collaborate effectively.
• Ability to create technical documentation and specs.
• Clear communicator who’s able to speak to both business clients and fellow IT professionals.
• Ability to work independently, under tight timelines, with great attention to detail.

Your Assets

• Previous internship, co-op, or project experience in data engineering or application development.
• Knowledge of the business processes related to mutual funds, securities, trading, and fund accounting.
• Familiarity with Eagle Investment Systems and financial data providers like Bloomberg.
• Experience with data warehouses, data virtualization, and data modelling methodologies.
• Experience with Relational Database Management Systems: Microsoft SQL Server, Oracle, MySQL
• Experience using ETL tools (e.g. Informatica Cloud, Data Factory, SSIS).
• Experience with reporting tools (e.g. Power BI, Tableau, Active Reports).
• Experience with cloud platforms (e.g. AWS, Azure, GCP).
• Experience with REST API.
• Knowledge and experience developing on cloud platforms like Salesforce and Workday.

No unsolicited agency referrals please.

AGF is an equal opportunity employer committed to fostering an inclusive and accessible workplace. We welcome and encourage applications from individuals of all backgrounds, including women, Indigenous peoples, racialized persons, persons with disabilities, and members of the 2SLGBTQIA+ community.

We do not discriminate on the basis of race, national or ethnic origin, colour, religion, age, sex, sexual orientation, gender identity or expression, marital status, family status, disability, or any other status protected by applicable legislation.

We are committed to providing reasonable accommodations for applicants with disabilities throughout the recruitment process. If you require accommodation at any stage of the application or hiring process, please contact us at [e-mail] so that appropriate arrangements can be made.