Junior Business Intelligence Developer

Overview

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.

Responsibilities

• 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
• Process data extracts and configure 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.

Qualifications

Firm understanding of data warehouse concepts, structures, and services such as ETL tools and OLAP services

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

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

Disclaimer

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.

#J-18808-Ljbffr