About the role
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 hr@agf.com so that appropriate arrangements can be made.
R11209
About AGF Investments
AGF Investments is comprised of various subsidiaries of AGF Management Limited who manage and advise on a variety of investment solutions for clients globally. The investment teams draw upon and integrate fundamental and quantitative investing capabilities and research across the companies. AGF Investments’ disciplined approach, global mindset and eye to risk management have allowed us to continue to evolve and thrive as a diversified asset manager. AGF Investments’ teams embrace a culture of collaboration with the belief that an interconnected team leads to a better understanding of an interconnected world as we strive to deliver on investment objectives and provide an exceptional client experience.
AGF Investments’ offerings include a broad range of equity, fixed income, alternative and multi-asset strategies covering a spectrum of objectives from wealth accumulation and risk management to income-generating solutions.
AGF Investments services a diverse client base from financial advisors and individual investors to institutional investors across the globe through segregated accounts, mutual funds, exchange-traded funds and separately managed accounts.
AGF Investments entities only provide investment advisory services or offers investment funds in the jurisdiction where such firm and/or product is registered or authorized to provide such services.
About the role
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 hr@agf.com so that appropriate arrangements can be made.
R11209
About AGF Investments
AGF Investments is comprised of various subsidiaries of AGF Management Limited who manage and advise on a variety of investment solutions for clients globally. The investment teams draw upon and integrate fundamental and quantitative investing capabilities and research across the companies. AGF Investments’ disciplined approach, global mindset and eye to risk management have allowed us to continue to evolve and thrive as a diversified asset manager. AGF Investments’ teams embrace a culture of collaboration with the belief that an interconnected team leads to a better understanding of an interconnected world as we strive to deliver on investment objectives and provide an exceptional client experience.
AGF Investments’ offerings include a broad range of equity, fixed income, alternative and multi-asset strategies covering a spectrum of objectives from wealth accumulation and risk management to income-generating solutions.
AGF Investments services a diverse client base from financial advisors and individual investors to institutional investors across the globe through segregated accounts, mutual funds, exchange-traded funds and separately managed accounts.
AGF Investments entities only provide investment advisory services or offers investment funds in the jurisdiction where such firm and/or product is registered or authorized to provide such services.