Analytics Developer

Category: Analytics and Emerging Digital Technologies
City: Burnaby, British Columbia, Canada
Position ID: J0619-0876
Employment Type: Full Time

Position Description

Founded in 1976, CGI is one of the world’s largest IT and business consulting services firms. We help clients achieve their goals, including becoming customer-centric digital organizations, through high-end IT and business consulting, systems integration and outsourcing services combined with a unique client proximity model and global center of excellence network.

CGI is more than just an IT consulting company; we are a global organization offering a world of opportunities. Become part of a unique culture that gives you the freedom to innovate, to make decisions, to achieve your full potential, and to chart your own career.

CGI’s Burnaby office is located in a newly opened Solo district high-rise, providing a bright, modern work environment with excellent views and conveniences, next to the Brentwood Town Center Skytrain station.

CGI Burnaby is looking for a Business Intelligence Developer to join our expanding team to help our customers on their digital transformation journey.

This position is an excellent opportunity for someone who is looking to develop their career in an agile environment. The ideal person for this role has extensive hands-on experience in developing end-to-end business intelligence solutions using Microsoft tools, including but not limited to data set ingestion and transformation, data manipulation and formula creation for tabular and multidimensional models, report development , and creation of dashboards.

Your future duties and responsibilities

The Business Intelligence Developer will assist in the creation of a secure framework for how data, reports, and dashboards are managed. In addition, the successful candidate will participate in the creation of technical and functional guidance documentation and will provide presentations and training for technical staff and power users.

Required qualifications to be successful in this role

The successful candidate:
Demonstrates experience in developing warm relationships with clients
Collaborates well in a team environment
Is self-motivated, creative and eager to learn
Has proficient oral and written English communication skills
Has a willingness to embrace and help drive change with our clients
Demonstrates proficiency using multiple data sources to develop strategies with outputs that are insightful and actionable
Demonstrates proficiency in data manipulation for tabular and multidimensional models
Is familiar with data warehousing principles and has experience with ELT methodologies

Required experience:
3-5 years of Business Intelligence development experience with a primary focus on Microsoft technologies (SQL Server, SSIS, SSAS, SSRS)
Strong concepts of fueling business process improvement and decision making through effective use of data.
Strong understanding of SQL, MDX, and/or DAX.
Able to work independently to implement a solution with minimal guidance.
Communicate effectively with both business, technical stakeholders as well as executive leadership.

Preference will be given to candidates that have these additional skills:
Working in a Scrum team
Experience implementing test automation in a BI/DW environment
Mathematics or statistical background
Data mining / machine learning experience
1+ years experience using Microsoft Power BI (Power BI, Power Pivot, Power Query, Power view)


  • MS SQL Server
  • SSAS
  • Scala
  • MS Azure SQL DB
  • MS PowerBI

What you can expect from us

Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at

No unsolicited agency referrals please.

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.