Analytics Developer (6 month contract)
Analytics Developer (6 month contract)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
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 firms 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 addition you will be helping support legacy reporting and application solutions that have been primarily developed (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 clients needs and AGFs data and systems needed to build reports and information delivery solutions.
Your Qualifications
- Bachelors 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. 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 whos 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 isan 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 forapplicants with disabilities throughout the recruitment process. If you require accommodation at any stage of the application or hiring process please contact us at so that appropriate arrangements can be made.
# R11209Employment Type
Full-Time
