BI Developer

Location: North York, ON, Hybrid, 3 days per week on-site
Language: Strong written and verbal English communication required
Duration: 3 month contract

About the Opportunity
Join a forward-thinking financial services regulatory organization as a Senior Power BI Developer, where you’ll help build enterprise reporting solutions that support informed decision-making and strengthen data-driven operations. This contract offers the opportunity to work across both cloud and on-premises BI environments while contributing to a collaborative, agile culture.

You’ll partner directly with business stakeholders and technical teams to turn complex requirements into scalable, high-performing dashboards, reports and data models. Your work will have meaningful visibility across the organization, with a strong focus on data quality, governance and reliable reporting.

What’s In It for You
• Work on enterprise-scale Power BI solutions spanning cloud and on-premises environments
• Gain exposure to a diverse Microsoft data ecosystem, including SQL Server, SSIS, SSAS, Azure and Microsoft Fabric
• Collaborate with engaged business and technical stakeholders in an agile environment
• Enjoy a hybrid schedule that balances in-person collaboration with remote work

Your Responsibilities
• You’ll design, develop and maintain interactive dashboards and reports using Power BI Service and Power BI Report Server
• You’ll integrate SQL Server, Excel, APIs, flat files and cloud sources into reliable, reusable data models
• You’ll write and optimize complex T-SQL queries, stored procedures and views, while developing ETL pipelines using SSIS
• You’ll build SSAS tabular or multidimensional models and create efficient star or snowflake schemas with DAX measures
• You’ll troubleshoot report, model and refresh performance while maintaining data accuracy, consistency and governance
• You’ll collaborate with stakeholders to gather requirements, provide status updates and translate business needs into technical solutions

Skills and Qualifications
• 5–8 years of hands-on Power BI development experience, including Power BI Service and Power BI Report Server
• Strong SQL Server and T-SQL expertise, including query optimization, stored procedures and views
• Solid experience with SSIS, SSAS, DAX, data modelling and performance tuning
• Experience building reporting solutions using multiple data sources and managing complex enterprise data requirements
• Strong analytical, facilitation and communication skills, with the ability to manage parallel workstreams and stakeholder discussions
• Experience with Power BI administration, role-based access, Power BI Gateway, Direct Lake, Azure SQL, Azure Data Factory, Azure Synapse or Microsoft Fabric is an asset
• Bachelor’s degree in Computer Science, Information Systems or a related field, or equivalent practical experience. Microsoft Power BI or Azure Data certifications are an asset

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.