Are you a data expert looking to make a tangible impact on public services? Our Calgary client is seeking a specialized Business Intelligence and Analytics consultant for an initial 12-month contract engagement focused on enhancing their data delivery capacity. This is an excellent opportunity to work within a sophisticated IT ecosystem, where you will use your expertise in ETL development and data visualization to support a diverse portfolio of municipal projects.
...
Advantages
• Work on a high impact portfolio that directly supports municipal infrastructure and services.
• Engage with a modern tech stack including Azure Data Factory, Synapse, and Microsoft Fabric.
• Collaborate with a professional IT Governance team to validate and implement architectural solutions.
• Flex your skills across multiple industry leading platforms like Informatica and SAP BusinessObjects.
• Take on a leadership role by mentoring other developers and guiding technical best practices.
Responsibilities
• Coordinate with subject matter experts to define and document complex reporting requirements.
• Collaborate with the IT Governance team to validate all solution architectural proposals.
• Review and update existing data marts to ensure they meet evolving business needs.
• Develop and modify ETL scripts for new tables to maintain data integrity.
• Build and manage data pipelines within the Azure Data Factory environment.
• Create interactive reports and dashboards using approved visualization technologies.
• Prepare comprehensive technical documentation and provide training to internal support staff.
Qualifications
• Five or more years of experience developing successful business intelligence and analytics solutions.
• Extensive background using PowerCenter Informatica, SAP BusinessObjects, or Microsoft data platforms.
• Five or more years of experience applying data modelling principles such as Kimball Dimensional Modelling.
• Proven history working with database technologies and scripting in Oracle or SQL Server.
• Two or more years of experience mentoring and providing technical guidance to junior developers.
• Current Azure AZ-104 certification is required and Microsoft DP-600 or DP-700 certifications are highly preferred.
Summary
If you are a seasoned data professional who enjoys solving complex problems and building scalable analytics solutions, we want to hear from you. Please apply directly to this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
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.
show more
Are you a data expert looking to make a tangible impact on public services? Our Calgary client is seeking a specialized Business Intelligence and Analytics consultant for an initial 12-month contract engagement focused on enhancing their data delivery capacity. This is an excellent opportunity to work within a sophisticated IT ecosystem, where you will use your expertise in ETL development and data visualization to support a diverse portfolio of municipal projects.
Advantages
• Work on a high impact portfolio that directly supports municipal infrastructure and services.
• Engage with a modern tech stack including Azure Data Factory, Synapse, and Microsoft Fabric.
• Collaborate with a professional IT Governance team to validate and implement architectural solutions.
• Flex your skills across multiple industry leading platforms like Informatica and SAP BusinessObjects.
• Take on a leadership role by mentoring other developers and guiding technical best practices.
Responsibilities
• Coordinate with subject matter experts to define and document complex reporting requirements.
• Collaborate with the IT Governance team to validate all solution architectural proposals.
...
• Review and update existing data marts to ensure they meet evolving business needs.
• Develop and modify ETL scripts for new tables to maintain data integrity.
• Build and manage data pipelines within the Azure Data Factory environment.
• Create interactive reports and dashboards using approved visualization technologies.
• Prepare comprehensive technical documentation and provide training to internal support staff.
Qualifications
• Five or more years of experience developing successful business intelligence and analytics solutions.
• Extensive background using PowerCenter Informatica, SAP BusinessObjects, or Microsoft data platforms.
• Five or more years of experience applying data modelling principles such as Kimball Dimensional Modelling.
• Proven history working with database technologies and scripting in Oracle or SQL Server.
• Two or more years of experience mentoring and providing technical guidance to junior developers.
• Current Azure AZ-104 certification is required and Microsoft DP-600 or DP-700 certifications are highly preferred.
Summary
If you are a seasoned data professional who enjoys solving complex problems and building scalable analytics solutions, we want to hear from you. Please apply directly to this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
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.
show more
