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 15,000 projects and counting – improving lives and helping shape the growth of sustainable, progressive and inclusive communities.

Your role

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

This is a 12 month temporary coverage

• Education and practical experience using common data sources and APIs such as ODBC, OData, MS SQL, and Azure SQL
• A firm understanding of software change management process and testing
• 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.
• Utilize BI platforms and BI tools to develop and maintain self-service data models and repositories
• 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 refine data views and queries using Structured Query Language (SQL) and related variants like T-SQL
• Firm understanding of data warehouse concepts, structures, and services such as ETL tools and OLAP services
• Experience using Power BI, MS Visual Studio is an asset.
• 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
• Develop and conduct business intelligence related training for HelpDesk staff and end-users
• Work with business teams and finance reporting personnel to analyze data and translate business needs into technical specification
• Proficiency in writing specifications, user documents, and presentation materials in English

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

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

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

Colliers Project Leaders is part of Colliers (NASDAQ, TSX CIGI), a leading diversified professional services and investment management company, with more than 17,000 professional 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.