< Job List

About Us


AIMCo is one of Canada’s largest and most diversified investment managers, with approximately $90 billion of assets under management for 31 clients, a diverse group of Alberta public sector pension plans, endowment funds, and government accounts representing all Albertans. Our culture is defined by our core values: Excellence, Transparency, Humility, Integrity, and Collaboration.

Our success as an organization is as dependent on the growth of our people as it is our investments. We provide opportunity to our employees, embrace talent with new ideas and are committed to a culture of continuous learning.


Job Details
Developer, Business Intelligence (Fixed Term - 16 Months) (004810)
Job Number: 004810
Job Title: Developer, Business Intelligence (Fixed Term - 16 Months)
Number of Openings: 1
Job Type (Employment Type): Fixed Term
Job Schedule: Full Time
Job Category: Investment Operations
Minimum Level of Education: Degree
Years of Relatable Experience: 2
Application Deadline: 2017/02/22
Position Summary

The Developer, Business Intelligence (BI) is responsible for Business Intelligence and Reporting services including the maintenance and enhancement of the data mart and exposing data through various reporting and business intelligence tools like Microsoft Power BI, Reporting Services (SSRS), TIBCO Spotfire, Tableau etc. in order to provide AIMCo’s management with insight to key investment data.

Functioning within a team environment, the Business Intelligence Developer would also contribute to enhancement projects from planning through to testing, implementation and client training phases. The incumbent will also serve as a technical and analytical resource on various teams, projects and initiatives.

Other responsibilities include:

  • Providing support services including root-cause analysis, debugging, training and consultation services for any business intelligence tools / reporting related issues and queries raised by internal and external clients
  • Optimizing the data mart,  procedures and implementing new database structures and queries to develop derived data (like Look thru) and onboard / expose new data
  • Development and implementation of a new report development life cycle management framework
  • Exposing data to clients using reporting and business intelligence tools (Power BI, SSRS, Spotfire, etc.)
  • Cross-training other team members and employees on new business intelligence tools and functionality
  • Generation of detailed design, requirements and solutions documents and maintenance of reporting, code history in TFS and source safe
  • Developing SSIS packages to integrate with other SQL Servers, .Net web services, flat files and non-SQL data sources such as legacy systems
  • Ensuring accuracy and integrity of data and applications through analysis, ETL modeling, coding, writing clear documentation and problem resolution
Our Ideal Candidate
  • Bachelor's degree in Computer Science, Management Information Systems or a related field
  • 2 or more years’ experience developing analysis with Business Intelligence visualization software like Microsoft Power BI, TIBCO Spotfire, Tableau etc.
  • 3 or more years’ experience with SQL Server Management Studio, ASP.Net, VB.Net, Oracle PL/SQL, Visual Studio, Python, JavaScript, C#, R
  • Experience in financial services / banking an asset
  • CFA or another financial designation is an asset
Application Instructions
NOTE: Candidates will be asked to undergo a security screening, which includes a credit bureau and a criminal record investigation, the results of which must be acceptable to AIMCo.

Follow AIMCo on LinkedIn

We thank all applicants in advance; however, only individuals selected for interviews will be contacted.

For more information and to apply, visit the careers section of AIMCo's website at www.aimco.alberta.ca