détails d'emploi
We are seeking a highly skilled Database Analyst / Information Management Administrator to support major Business Intelligence (BI) and Customer Relationship Management (CRM) initiatives within a leading federal innovation program. In this role, you will design and optimize database structures, develop and execute ETL workflows, and integrate co
...
mplex datasets from multiple sources into a unified client view. You will apply advanced SQL, data modeling, and text analysis techniques to ensure data quality and generate meaningful insights that directly enhance services to Canadian SMEs. The ideal candidate brings hands-on experience with Azure Data Factory, Power BI, Business Objects, and Git, and thrives in Agile (SCRUM) environments. This is a multi-year engagement offering the opportunity to make a direct impact on how innovation support is delivered nationwide.
*** Remote position ***
*** Bilingual (French/English) communication skills required ***
*** Candidates must be eligible for Government of Canada Reliability clearance ***
Advantages
•Work from anywhere in Canada while contributing to impactful national innovation projects.
•Gain hands-on experience with advanced BI and CRM initiatives in a collaborative Agile environment.
Responsibilities
•Design, develop, and maintain data integration workflows, including extracting, transforming, and loading (ETL) data from multiple sources such as REQ, ONBIS, CIPO, LinkedIn, and government datasets.
•Design and optimize database structures, leveraging advanced SQL to create, update, and manage tables, views, stored procedures, fields, and indexes.
•Develop logical and physical data models to consolidate and harmonize supplier and client data.
•Perform data quality checks and audits, ensuring the accuracy, consistency, and integrity of data across systems.
•Leverage advanced text analysis techniques (including fuzzy matching algorithms) to identify trends, detect patterns, and resolve duplicate or similar records.
•Administer databases, including auditing, backup/restore, optimization, and performance profiling.
•Utilize cloud-based data tools such as Azure Data Factory to process and integrate large, complex datasets.
•Support BI reporting and analytics by working with tools such as Business Objects and Power BI.
•Collaborate with Agile development teams (SCRUM) to deliver CRM and BI-related enhancements and solutions.
•Work with stakeholders to gather requirements and design scalable data solutions aligned with business needs.
•Create documentation, deliver training sessions, and conduct demonstrations for clients and developers.
•Apply version control best practices using Git, including branching strategies, code reviews, and collaborative workflow management.
Qualifications
•5+ years in database administration (MS SQL Server or Oracle), including performance tuning, security, and backup/recovery.
•5+ years developing Transact-SQL scripts for ETL, data transformation, and optimization.
•5+ years using Azure DevOps or JIRA in Agile environments.
•1+ year working with Git (branching, code reviews, workflows).
•Strong skills in SQL, ETL, data warehousing, and cloud platforms (Azure Data Factory).
•Experience with BI tools (Power BI, Business Objects) and text analysis (fuzzy matching).
•Knowledge of data modeling, query optimization, and performance tuning.
•Bilingual in English and French (spoken and written).
Summary
If you're interested in learning more please submit your résumé and one of our senior Recruiters would be happy to give you a call to discuss further.
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.
voir plus
We are seeking a highly skilled Database Analyst / Information Management Administrator to support major Business Intelligence (BI) and Customer Relationship Management (CRM) initiatives within a leading federal innovation program. In this role, you will design and optimize database structures, develop and execute ETL workflows, and integrate complex datasets from multiple sources into a unified client view. You will apply advanced SQL, data modeling, and text analysis techniques to ensure data quality and generate meaningful insights that directly enhance services to Canadian SMEs. The ideal candidate brings hands-on experience with Azure Data Factory, Power BI, Business Objects, and Git, and thrives in Agile (SCRUM) environments. This is a multi-year engagement offering the opportunity to make a direct impact on how innovation support is delivered nationwide.
*** Remote position ***
*** Bilingual (French/English) communication skills required ***
*** Candidates must be eligible for Government of Canada Reliability clearance ***
Advantages
•Work from anywhere in Canada while contributing to impactful national innovation projects.
...
•Gain hands-on experience with advanced BI and CRM initiatives in a collaborative Agile environment.
Responsibilities
•Design, develop, and maintain data integration workflows, including extracting, transforming, and loading (ETL) data from multiple sources such as REQ, ONBIS, CIPO, LinkedIn, and government datasets.
•Design and optimize database structures, leveraging advanced SQL to create, update, and manage tables, views, stored procedures, fields, and indexes.
•Develop logical and physical data models to consolidate and harmonize supplier and client data.
•Perform data quality checks and audits, ensuring the accuracy, consistency, and integrity of data across systems.
•Leverage advanced text analysis techniques (including fuzzy matching algorithms) to identify trends, detect patterns, and resolve duplicate or similar records.
•Administer databases, including auditing, backup/restore, optimization, and performance profiling.
•Utilize cloud-based data tools such as Azure Data Factory to process and integrate large, complex datasets.
•Support BI reporting and analytics by working with tools such as Business Objects and Power BI.
•Collaborate with Agile development teams (SCRUM) to deliver CRM and BI-related enhancements and solutions.
•Work with stakeholders to gather requirements and design scalable data solutions aligned with business needs.
•Create documentation, deliver training sessions, and conduct demonstrations for clients and developers.
•Apply version control best practices using Git, including branching strategies, code reviews, and collaborative workflow management.
Qualifications
•5+ years in database administration (MS SQL Server or Oracle), including performance tuning, security, and backup/recovery.
•5+ years developing Transact-SQL scripts for ETL, data transformation, and optimization.
•5+ years using Azure DevOps or JIRA in Agile environments.
•1+ year working with Git (branching, code reviews, workflows).
•Strong skills in SQL, ETL, data warehousing, and cloud platforms (Azure Data Factory).
•Experience with BI tools (Power BI, Business Objects) and text analysis (fuzzy matching).
•Knowledge of data modeling, query optimization, and performance tuning.
•Bilingual in English and French (spoken and written).
Summary
If you're interested in learning more please submit your résumé and one of our senior Recruiters would be happy to give you a call to discuss further.
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.
voir pluspartager l'offre d'emploi
