We are seeking two highly skilled Senior Report Developers to join our team in Toronto for a 12-month engagement. This role is focused on the modernization of operational reporting systems, specifically migrating legacy reports into Power BI (Desktop and Report Builder). You will be responsible for the end-to-end delivery of advanced business intelligence solutions, including complex data modeling, DAX programming, and T-SQL query optimization, while ensuring full compliance with accessibility standards (AODA/WCAG).
...
Duration: 12-month contract with potential for extension
Location: Toronto, ON (Onsite)
Rate: $494.57-$531.17/hr
Advantages
Strategic Modernization: Lead the transition of legacy reporting systems to a modern, enterprise-standard Power BI ecosystem.
High-Quality Standards: Gain expertise in delivering "Accessibility First" reports that meet strict government digital standards.
Technical Variety: Work across the full BI stack, from SQL-based data extraction to advanced front-end visualization and DAX modeling.
Long-Term Continuity: 12-month initial term with a strong potential for extension based on project milestones.
Responsibilities
Reporting Assessment: Participate in needs assessments to understand the design and functionality of current operational reports and define migration strategies.
Solution Design & Development: Perform design and development activities to migrate reports to Power BI Desktop or Report Builder in alignment with AODA and WCAG 2.0 Level AA standards.
Data Modeling: Design, build, and deploy data models optimized for business intelligence, analytics, and third-party system integrations.
Advanced Programming: Utilize DAX and T-SQL/PL-SQL to implement complex logic, financial data reconciliation, and automated reporting features.
Troubleshooting: Perform technical root-cause analysis and apply corrective actions to resolve issues in reports and dashboards discovered during pre-release testing.
Prototyping: Conduct research and develop functional prototypes to help stakeholders visualize future business intelligence capabilities.
Knowledge Transfer: Document all technology designs, scripts, and PBIX specifications; conduct KT sessions for project managers and internal team members.
Qualifications
Power BI Mastery: 2+ years of demonstrated experience with Power BI Desktop and Power BI Report Builder.
Database Expertise: 4+ years of experience writing and optimizing SQL query languages (T-SQL, PL-SQL).
DAX Programming: 2+ years of experience writing DAX code and implementing complex measures/functionalities within BI objects.
Analytical Skills: Proven ability to resolve data quality issues, perform report validation, and troubleshoot complex database queries.
Technical Stack: Experience with ETL tools such as Azure Data Factory and Microsoft SSDT.
Domain Knowledge: Experience with financial data reporting and data reconciliation is a significant asset.
Soft Skills: Excellent consultative and facilitation skills; ability to explain technical tasks to non-technical stakeholders and contribute to a team-based Agile environment.
Summary
If you are a Power BI expert with a deep foundation in SQL and a passion for turning complex data into actionable visual insights, we encourage you to apply today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
We are seeking two highly skilled Senior Report Developers to join our team in Toronto for a 12-month engagement. This role is focused on the modernization of operational reporting systems, specifically migrating legacy reports into Power BI (Desktop and Report Builder). You will be responsible for the end-to-end delivery of advanced business intelligence solutions, including complex data modeling, DAX programming, and T-SQL query optimization, while ensuring full compliance with accessibility standards (AODA/WCAG).
Duration: 12-month contract with potential for extension
Location: Toronto, ON (Onsite)
Rate: $494.57-$531.17/hr
Advantages
Strategic Modernization: Lead the transition of legacy reporting systems to a modern, enterprise-standard Power BI ecosystem.
High-Quality Standards: Gain expertise in delivering "Accessibility First" reports that meet strict government digital standards.
Technical Variety: Work across the full BI stack, from SQL-based data extraction to advanced front-end visualization and DAX modeling.
Long-Term Continuity: 12-month initial term with a strong potential for extension based on project milestones.
...
Responsibilities
Reporting Assessment: Participate in needs assessments to understand the design and functionality of current operational reports and define migration strategies.
Solution Design & Development: Perform design and development activities to migrate reports to Power BI Desktop or Report Builder in alignment with AODA and WCAG 2.0 Level AA standards.
Data Modeling: Design, build, and deploy data models optimized for business intelligence, analytics, and third-party system integrations.
Advanced Programming: Utilize DAX and T-SQL/PL-SQL to implement complex logic, financial data reconciliation, and automated reporting features.
Troubleshooting: Perform technical root-cause analysis and apply corrective actions to resolve issues in reports and dashboards discovered during pre-release testing.
Prototyping: Conduct research and develop functional prototypes to help stakeholders visualize future business intelligence capabilities.
Knowledge Transfer: Document all technology designs, scripts, and PBIX specifications; conduct KT sessions for project managers and internal team members.
Qualifications
Power BI Mastery: 2+ years of demonstrated experience with Power BI Desktop and Power BI Report Builder.
Database Expertise: 4+ years of experience writing and optimizing SQL query languages (T-SQL, PL-SQL).
DAX Programming: 2+ years of experience writing DAX code and implementing complex measures/functionalities within BI objects.
Analytical Skills: Proven ability to resolve data quality issues, perform report validation, and troubleshoot complex database queries.
Technical Stack: Experience with ETL tools such as Azure Data Factory and Microsoft SSDT.
Domain Knowledge: Experience with financial data reporting and data reconciliation is a significant asset.
Soft Skills: Excellent consultative and facilitation skills; ability to explain technical tasks to non-technical stakeholders and contribute to a team-based Agile environment.
Summary
If you are a Power BI expert with a deep foundation in SQL and a passion for turning complex data into actionable visual insights, we encourage you to apply today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
