The Senior Business Intelligence (BI) Specialist position is integral to the success of the Enterprise Data Management team, and to CAAT's guiding mission and growth strategy. As a BI Specialist, you will develop business intelligence (BI) and reporting solutions within Power BI/Microsoft Fabric platform. You will perform full business intelligence or data development lifecycle activities including business intelligence requirements analysis, data modelling, data integration, and data visualization. This position will report to the Director of Enterprise Data Management. The successful candidate will demonstrate: * Experience and strong understanding of SQL, ETL, data analysis and data modelling to interpret data, analyze results and identify trends or patterns in complex data sets. * Experience developing technical solutions for complex business data problems. * Advanced Power Query Skills (M scripts and functions, query folding, merge/append/reference queries, variables and parameters, custom functions, etc.). * Advanced DAX skills (calculate with multiple filter modifiers, variables, time intelligence, moving and running totals, calculation groups, etc.). * Advanced Power BI visualization and interactive design (using buttons, bookmarks, drill through, tooltips, etc.). * Strong communication, collaboration, and leadership skills. Once here you will: * Design and develop tabular data models in Power BI using star schema, dimensional modeling principles and advanced DAX techniques. * Develop, maintain, and monitor Power BI premium dataflows to load, transform and democratize data assets. * Develop advanced SQL scripts to extract and prepare data from various sources. * Provide technical leadership to the data management team in designing and developing sound data management solutions. * Collaborate with business users, data architects and data analysts to understand data & analytical needs, KPIs and develop solutions that can support ongoing and future analytical capabilities. * Promote Power BI design best practices and conduct workshops at individual team levels and at enterprise level. * Ensure data quality by identifying and resolving data quality issues.We are looking for someone with: • A degree in business, engineering, systems design, computer science, or a related discipline - or a combination of education, training and experience deemed equivalent. • Over eight (8) years of experience in data engineering, data modelling, data analysis and BI development. • A minimum of three (3) years of experience in Power BI development and dashboard design. • Professional data certifications from a major data platform vendor like Microsoft, Informatica, Google, AWS, IBM, etcAcara Solutions is committed to ensuring equal employment opportunities for applicants and employees. We are committed to filling open positions using balanced selection criteria to avoid unlawful discrimination against applicants on the basis of their age, colour, disability, marital status, national origin, gender, gender identity, genetic information, race or racial origin, religion, sexual orientation, or any other status protected or required by lawAcara Solutions welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates participating in all aspects of the selection process.