BE authentic . BE influential . BE the expert . Be all that and more at Colliers International.
At Colliers International, we help leaders succeed by helping them build amazing workplaces, businesses and communities around the world. We do this by thinking differently, sharing innovative ideas and offering a unique and collaborative workplace where you can succeed.
BE authentic. BE influential. BE the expert . Be all that and more at Colliers International. Join our team as a Senior Business Intelligence Developer/Analyst in Toronto, ON.
Who you are
As Senior BI Developer/ Analyst you will be part of a high performing, Enterprise Information Management team that’s working on the company’s data initiatives. You will work closely with the regional Application Solution Architect and be involved in the building and maintenance of the company’s data-related solutions, including the enterprise data warehouse.
You will be an energetic, high aptitude, and self-starting individual who is seeking career growth within a fast-paced, flexible, and rapidly growing company. Communication skills and out-of-the-box thinking is key as exploring new technologies to create innovative solutions is highly encouraged.
What you bring
Bachelor’s degree in computer science, information systems, or related field; or equivalent work experience
Depth and breadth of technical experience in data architecture, data quality, data integration, data migration, data warehousing/data lake projects, and data analytics.
5-10 years of BI design and development experience in the following: SQL Server (2012 or newer), Power BI, SSAS, SSIS, Enterprise Data Warehouse architecture/development or other BI Stack.
Demonstrated experience in evaluating business processes and recommending improvements.
Experience working in a collaborative and team-oriented environment
Excellent SQL query skills
Bonus Skills and experience
Familiar with SQL Master Data Services (MDS) and Data Quality Services (DQS)
Experience with Data Lake and AI/ML solutions
Experience in developing within Azure Cloud Services
Knowledge of Dynamics CRM and/or Salesforce
What success looks like
You bring a depth and breadth of technical experience in data architecture, data quality, data integration, data migration, data warehousing/data lake projects, and data analytics.
You will successfully design creative solutions for multiple projects in different Canadian lines of business (data warehouses, etc.) to meet the long-term goals of the organization.
You will form outstanding collaborative working relationships with the business stakeholders, developers, and support teams.
You will effectively communicate with key stakeholders and understand the business needs, capture requirements and implement required data access layer and data architecture
You will design/enhance multidimensional architecture related to the Enterprise Data Warehouse
You will develop and implement comprehensive testing plans for validating data transformation and integration and develop key metrics for tests on data and ensure the integrity of the same on data architecture.
You will be agile and flexible and be willing to bring new ideas to the table.
You will define data governance & policies across various Business Units for creating effective reporting and analytics.
BE who you are and what you want to be with Colliers International. We’d love to meet you. Apply today to join our team.
Direct applicants only please, no agencies.
Colliers is an equal opportunity employer and values 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 in order to participate in the recruitment process, please contact the recruitment team by email at email@example.com.