Data Architect - PowerBI

Location: Toronto, On-site 5 days per week
Language: English, advanced written and spoken communication required
Job type: 1 year contract

About the Opportunity
This opportunity is ideal for an experienced Power BI and Data Architecture professional who enjoys balancing strategic solution design with hands-on development. You’ll support a large-scale public sector or healthcare environment, helping shape a modern analytics solution that turns complex data into reliable, actionable insights.

You’ll work closely with business stakeholders, technical teams and developers to design scalable architecture while delivering high-quality reporting solutions. The role is approximately 40% data architecture and 60% hands-on Power BI development.

What’s In It for You
You’ll have the opportunity to influence enterprise-level data architecture while staying close to hands-on development. This role offers exposure to modern Microsoft and Azure technologies, complex data environments, and collaborative teams where your technical leadership and ability to mentor others will be valued.

Your Responsibilities
• You’ll develop solution architecture documentation, data flow diagrams, conceptual, logical and physical data models.
• You’ll design Databricks Lakehouse architecture, Power BI semantic models, security models and Row-Level Security.
• You’ll establish data governance, lineage, performance, capacity, non-functional requirements and CI/CD architecture.
• You’ll build Power BI dashboards and reports, including DAX measures and KPIs.
• You’ll integrate Databricks data sources and optimize reporting performance.
• You’ll support testing, deployment, technical documentation and knowledge transfer.

Skills and Qualifications
• 7+ years of Business Intelligence and Data Analytics experience, including 5+ years of Power BI development.
• 7+ years of data architecture experience, including dimensional modeling, star schemas and enterprise data warehouse design.
• 3+ years of Ontario Public Service or healthcare experience is required.
• Expert-level DAX, Power Query, Power BI semantic modeling, advanced SQL and data warehouse development skills.
• Strong expertise with Databricks, Azure Data Factory, Data Lake, Synapse and SQL Server.
• Proven experience with data governance, security, RLS, performance optimization and enterprise reporting architecture.
• Strong business analysis, stakeholder management, leadership, mentoring, problem-solving and communication skills.

Why Partner with Altis
If you’ve 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 you’re 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 appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.