Junior Business Intelligence Developer

At Colliers Project Leaders, we deliver capital project solutions to fulfill our clients' needs across the built environment. The work we do makes a difference in communities and for the people who live there. We have a passion for it.

Our commitment to realizing our clients' vision inspires us to look beyond the immediate – to the possibilities of what we can achieve together. We are 17,000 projects and counting – improving lives and helping shape the growth of sustainable, progressive and inclusive communities.

Your role

Join our team as a Junior Business Intelligence Developer with the IT team.

The Junior Business Intelligence Developer works as a member of the Application Development and Support team to develop and maintain business intelligence solutions.  In this position, you will build and maintain company data warehouse components, data models, data sets, and reports that are used to aid in business performance monitoring and business decision-making.

• Work as a member of IT project teams to design, implement, and support business intelligence solutions in a Microsoft SQL, Power BI, and ZAP Datahub environment
• Work with business teams and finance reporting personnel to analyze data and translate business needs into technical specifications
• Utilize BI platforms and BI tools to develop and maintain self-service data models and repositories
• Develop and refine data views and queries using Structured Query Language (SQL) and related variants like T-SQL
• Processes data extracts and configures data source connections using standard and custom data interfaces and APIs
• Develop test plans and test scripts to perform testing and administration of user acceptance testing
• Develop and conduct business intelligence-related training for HelpDesk staff and end-users
• Ability to write and optimize complex queries.

• Post-secondary degree or certification in computer science or data analytics related field, or an equivalent combination of academic and practical experience in data analytics or business intelligence reporting.
• Education and practical experience using common data sources and APIs such as ODBC, OData, MS SQL, and Azure SQL
• Firm understanding of data warehouse concepts, structures, and services such as ETL tools and OLAP services
• A firm understanding of software change management process and testing
• Proficiency in writing specifications, user documents, and presentation materials in English
• Experience using Power BI, MS Visual Studio is an asset.

Don't have every single qualification? We know that some people are less likely to apply for a job unless they are a perfect match. At Colliers Project Leaders, we're not looking for "perfect matches." We're looking to welcome people to our diverse, inclusive, and authentic workplace.  So, if you're excited about this role but don't have every single qualification, we encourage you to apply anyway. Whether it's this role or another one, you may be just the right candidate.

What you can expect:

• An opportunity to truly impact our communities
• A flexible work environment
• A comprehensive onboarding experience
• Significant professional development, training, and a mentorship program
• A paid volunteer day
• An environment where people feel welcome, heard and included, regardless of their differences
• And much more

Join our team of difference-makers and help shape the growth of dynamic communities.

#LI-DV1

Colliers Project Leaders is part of Colliers (NASDAQ, TSX: CIGI), a leading diversified professional services and investment management company, with more than 17,000 professionals operating in 63 countries.

Colliers Project Leaders has suspended our COVID-19 vaccination requirement. In circumstances where our clients have a different COVID-19 vaccination policy, the Clients' requirements will supersede.

Colliers Project Leaders is an equal opportunity employer and celebrates diversity in its workforce. Colliers encourages applications from all qualified individuals and will accommodate applicants' disability-related needs, up to the point of undue hardship, throughout all stages of the recruitment and selection process. If you require a disability-related accommodation to participate in the recruitment process, please advise the assigned Talent Acquisition Business Partner.

Colliers Project Leaders standard recruitment process requires applicants to be subjected to formal background and reference checks prior to their hiring.