Job Description Summary

Purpose of Position
The Power BI Data Visualization Analyst will be responsible for designing, building, and implementing business intelligence capabilities and tools, with the end goal of maximizing profits and increasing our operation efficiency. The Power BI Data Visualization Analyst is responsible for optimizing the use of Colliers property market information by Colliers professionals in serving clients and pursuing new business. They will be required to work with Colliers professionals throughout their assigned region to create innovative Business Intelligence solutions, promote best practices in data and research processes, and support the delivery of efficiency gains in research and data operations.

Job Description

Who you are:

You’re a professional with a clear understanding of BI data who’s looking to translate your innovative ideas in a growing industry. You'll be responsible for designing, building, and implementing business intelligence capabilities and tools, with the end goal of maximizing profits and increasing our operation efficiency. You'll be responsible for optimizing the use of Colliers property market information by Colliers professionals in serving clients and pursuing new business. You will be required to work with Colliers professionals throughout their assigned region to create innovative Business Intelligence solutions, promote best practices in data and research processes, and support the delivery of efficiency gains in research and data operations. You’re highly organized and have a keen eye for detail, ensuring a high standard of quality in everything you do. You’re flexible and thrive in a fast-paced, team environment where no two days are the same. You demonstrate excellent interpersonal skills with teammates and clients. You also love to learn and exchange ideas with others to achieve amazing results.

What you bring:

Design, build and implement business intelligence tools and visual analytics (i.e. interpret data, draw conclusions, and make decisions) to drive faster decisions and better results.
Maintain key Business Intelligence Tools that support the performance of both the business (Revenue Generating tools) as well as the Data and Research teams (Operational Efficiency tools)
Consult with end users to generate options, create mockups, and design documents to address their BI and visual analytics needs.
Recommend reporting options and solutions that satisfy sponsor/stakeholder needs. Continually exploring and assessing options for value-add and supporting the business strategy.
Supports ad-hoc requests to address day-to-day operations issues and opportunities
Create user stories in a Power BI Reporting environment
Write custom calculations (or queries) within the data visualization tool (Tableau, Power BI, Qlik, etc),
Basic knowledge relational database theory
Query, load, and analyze data with the intent to identify patterns
Optimization of current report queries and general report performance.
Business domain knowledge in commercial real estate industry is considered an asset.
Document problems and resolutions for future reference.
Other duties as required.

Bonus skills and experience:

Bachelor’s degree in Economics, Mathematics, Business or Data Science.
2+ years’ experience with major visualization tools, specifically in building client facing BI reports.
Computer proficiency in MS Power BI visualization, SQL query and strong skills in Excel.
Proven knowledge of data visualization best practices and ability create stunning dashboards.
Knowledge of MS Office Outlook, Word, and PowerPoint in creating presentations.
Understanding of the data model and relational databases.
Ability to find answers to even the most complex problems; Ability to think critically to question assumptions to get to the root of issues so our research is focused, and our analysis is accurate.
Ability to develop constructive and cooperative working relationships with others and maintain them over time.
Ability to work in a fast paced and demanding environment, while maintaining the ability to meet deadlines without compromising accuracy, excellent product quality and attention to detail. High level of attention to detail is essential.
Demonstrate high level of passion and energy when taking on projects; must be driven.
Excellent customer service at all levels of the organization and with external partners.
Experience with operations support requests from business areas to design, build, maintain or troubleshoot reports.
Ability to work well with people from many different disciplines with varying degrees of technical experience
Exceptional analytical skills
Ability to communicate clearly and concisely, both orally and in writing with all levels of the organization and with external partners.
Exhibit a high level of professionalism and excellent interpersonal skills
Strong relationship-building ability, proactive, results-oriented, and resourceful.
Ability to meet deadlines without compromising accuracy, excellent product quality and attention to detail.

What success looks like:

You’re a positive individual with a huge passion for observing, receiving, and otherwise obtaining information.
You feel confident standing in front of an audience to present on findings and to tell the story.
You have a keen eye for detail, and you are enthusiastic in managing, recording, and analyzing data for the production of reports.
You’re a team player.

PowerBI Developer