Senior Power BI and Data Architect

Workland       |    Location:Canada       |    Country:Canada

IT’S MORE THAN A JOB… IT’S AN EXPERIENCE! About Mazars Mazars is an internationally integrated partnership, specializing in audit, accountancy, advisory and tax services. Operating in over 90 countries around the world, we draw on the expertise of 40,400 professionals – 24,400 in Mazars’ integrated partnership and 16,000 via the Mazars North America Alliance – to assist clients of all sizes at every stage in their development. In Canada, our firm is located in Montreal and Toronto and which has nearly 130 professionals, specialists, partners and support staff. Mazars is also a lot more than that. You don’t join Mazars by coincidence, you choose Mazars: a global school of excellence where you will be challenged to develop and grow. More than 60% growth in the last 5 years; 53% of our global staff are women and 96% of Mazars’ women leaders would recommend the firm to women graduates; Global access to LinkedIn Learning; 87% of all Mazarians contribute to charities; International mobility; Opportunities throughout your career. If you want to work in a firm that aims to: Focus on values and culture; Allow you to bring out your entrepreneurial spirit; Get involved in its transformation and growth; Foster innovation and creativity; Promote a living environment where collegiality and collaboration take precedence. Our Technology and Digital Consulting team is seeking an experienced Microsoft Power BI and Data Architect to join our team to develop enterprise level BI solutions including customizations for large Microsoft Dynamics projects.  In this role the candidate is responsible for architecting and implementing complete BI solutions. The candidate will ensure quality and customer satisfaction in Mazars’s implementations by ensuring all delivered solutions meet the documented functionality and the customer’s needs.   QUALIFICATIONS: The candidate has 5+ years’ experience in data engineering/data warehousing Experience with Dynamics 365 (F&O, CE, or DataVerse) Strong knowledge of Power BI and DAX Design and develop scalable data ingestion frameworks to transform a wide variety of datasets Ability to provide T-SQL programming, including stored procedures, triggers, analytical functions, and query tuning or database administration Hands-on experience with the Azure Data Platform: Azure SQL Databases, Azure Synapse, Azure Data Factory and Azure Data Lake or Azure Databricks Understanding of data warehouse design principles and development approaches Experience as an Enterprise Architecture for data strategy Experience building & delivering analytical solutions using Kimball methodology, including in-memory models and star-schemas  Ability to interpret and translate business requirements into reporting solutions Experience supporting sales