Microsoft Azure Data & BI Expert
Work Model & Location: Hybrid – remote with occasional onsite meetings in Ottawa
Contract Term: 7-hour workdays, initial contract term (details to be confirmed), with possible extension
Industry: Our client in the higher education sector
Our client is seeking a Microsoft Azure Data & BI Expert with strong experience in Azure Synapse, dataflows, pipelines, and semantic modelling to support enterprise-wide reporting and analytics. The successful candidate will design and deliver scalable data solutions, develop bilingual semantic models, and provide business intelligence insights to improve operational and strategic decision-making.
Bachelor’s degree in Computer Science, Information Technology, Business Analytics, or related field (or equivalent experience)
Minimum 3 years of experience developing and implementing system/software programs on Microsoft Azure technologies
Strong hands-on experience with Azure Synapse Analytics, Pipelines, Dataflows, Notebooks, PySpark, Power BI
Experience in data manipulation, integrity checking, and building datasets/facts/dimensions for reporting and analytics
Knowledge of Medallion Architecture (Raw, Silver, Gold layers) and business intelligence concepts (semantic data modelling, star schemas)
Experience with multiple data formats (Parquet, Delta, JSON), SQL queries, stored procedures, REST APIs, and JIRA
Strong programming/analytical skills and ability to debug and optimize ELT processes
Experience creating bilingual semantic models and dashboards for Power BI
Bilingualism – French and English (spoken and written)
Experience with statistical analysis tools (R, Python, SPSS, SAS, SQL Developer)
Experience in big data/cloud integrations and API services
Strong stakeholder engagement and project management experience
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Whenever possible, reach out to a named contact rather than a general inbox - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at
Welcome on behalf on the Altis Recruitment team! Altis has a long-standing business relationship with the Defence community. For more than 30 years, we have been grateful to work alongside the Department of National Defence and countless military professionals. We know that family members of military personnel often make many personal sacrifices to support their loved ones. We understand that it can be difficult to pursue a career when embracing sudden changes like relocation and deployment. For some, this has meant putting a pause on career goals or professional development. We would like to provide you with everything you need for a successful and confident job search – in addition to access to job opportunities. Download the checklists our experts have created to help you be at your best from application to interview.