Data Security Analyst

This role is designed to ensure the compliance, optimization, and securing of access and business roles throughout the entire project lifecycle. You will be responsible for ensuring that security is maintained or enhanced during the migration and accurately reflects corporate standards in the new technological landscape.

This is a long-term contract ending on March 31, 2027. The position is 100% remote, offering total flexibility.

Advantages
Secure your professional path with a stable contract agreement spanning more than a year.

Enjoy total flexibility with a fully remote work environment.

Play a critical role in a major cloud integration and database modernization project.

Collaborate closely with architects, database administrators, and cybersecurity experts.

Responsibilities
Inventory existing access in SQL 2016 instances and identify gaps that need to be corrected for migration.

Extract security configurations such as logins, roles, permissions, and directory groups to produce a complete access matrix for the current and target environments.

Perform access scrubbing prior to migration to eliminate outdated, redundant, or non-compliant entitlements.

Adapt the matrix to the new capabilities of SQL Server 2022 and the requirements of the cloud environment.

Implement or review a standardized Role-Based Access Control model to be used in the cloud and target environment.

Validate access with IT, corporate security, and business units to ensure permissions reflect actual responsibilities.

Participate in workshops, impact analyses, and validations with architects and security teams.

Contribute to the access migration strategy including the transition to modern cloud authentication methods.

Validate post-migration access to ensure compliance and business continuity.

Document final configurations and produce reference guides for operations teams.

Qualifications
Strong expertise in database access management.

Solid experience with identity management in the cloud including Azure EntraID and Role-Based Access Control.

Knowledge of database security principles, encryption, permission management, and corporate policies.

Understanding of database migration processes and hybrid cloud environments.

Strong analytical skills paired with extreme documentary rigor.

Excellent command of the English language is mandatory for this role. Bilingualism in French and English is an asset, but unilingual English candidates are fully welcomed.
**Our client operates in Canada. The company takes all reasonable steps to limit the number of positions in Quebec that require knowledge of a language other than French, and only requires it when necessary and its existing bilingual employees are unable to perform these duties.

Based on an assessment conducted by our client, it has been determined that this position requires candidates to be fluent in English (both spoken and written). In particular, this position will require the employee to interact with centralized internal departments (e.g., Operations / HR / Finance / Legal / Contracts / Sales) that support the organization in Canada and that do not speak French.**


Summary
We are looking for a meticulous Data Security Analyst with strong expertise in SQL Server migrations and cloud identity management. If you excel at creating access matrices, implementing role-based security, and are looking for a fully remote mandate until 2027, this opportunity is for you.

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.