Duration: 6 months contract (possibility of conversion to permanent)
Location: Mississauga, ON. Hybrid (2 days per week onsite)
Language: Strong written and spoken English communication skills
About the Opportunity
Were looking for a Business Intelligence Analyst who thrives at the intersection of data, technology, and business decision-making. In this hands-on role within a large enterprise environment, youll take ownership of executive-facing reporting and semantic modeling, helping leaders access reliable insights to plan, manage, and operate technology effectively.
Youll work closely with engineering, operational, and cross-functional partners to transform complex business questions into scalable analytics solutions. This is an opportunity to influence how data is modeled, governed, automated, and ultimately used, while contributing to Power BI, automation, AI, and data engineering initiatives.
Whats In It for You
Youll have meaningful ownership of enterprise-scale analytics solutions and exposure to modern technologies across the Microsoft data ecosystem. Youll also have the opportunity to solve complex problems, collaborate with technical and business partners, and help shape standards that improve reporting, automation, and data-driven decision-making.
Your Responsibilities
Youll own and evolve enterprise Power BI semantic models, including scalable star schemas, relationships, calculation groups, advanced DAX, and reusable metrics.
Youll create executive-grade dashboards and self-service reporting solutions while establishing standards for governance, security, performance, and report design.
Youll build data models, pipelines, and integration patterns across Azure, Databricks, Fabric, and multiple source systems.
Youll maintain and lightly enhance an existing R/Shiny application, applying sound Git and documentation practices.
Youll automate operational workflows using Python, Power Platform, Power Automate, Copilot Studio, and enterprise channels such as Microsoft Teams.
Youll develop AI-powered solutions and apply forecasting, clustering, anomaly detection, and segmentation where they create lasting value.
Youll identify data quality issues, drive resolution with partners, and translate ambiguous questions into clear analytical frameworks.
Skills and Qualifications
Demonstrated deep, hands-on Power BI development experience, including enterprise semantic modeling, advanced DAX, administration, row-level security, and executive dashboard delivery.
Strong proficiency in SQL, DAX, and Python.
Familiarity with Azure, Databricks, Fabric, and data architecture within the Microsoft ecosystem.
Working knowledge of R and Shiny, with the ability to maintain and lightly extend a production application.
Experience building AI-powered workflow tools and thoughtfully integrating AI into analytics and automation.
Experience integrating multiple data sources and resolving data quality and reconciliation issues.
Strong communication skills, self-direction, and the ability to collaborate effectively across teams.
Why Partner with Altis
If youve never worked with a staffing agency before, we make it easy. We work with top employers across Canada who have great jobs to fill, each vetted and verified by our team. When you apply for a job with Altis, we get to know you as a candidate and learn what your strengths are. Then, if youre a solid match, we handle all the logistics, advocating for you as a candidate for the role, providing access to coaching and connecting you directly with the hiring manager. And rest assured, all our services are free of cost for candidates.
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.