Data Analyst- Hybrid in Winnipeg

Please send your resume at anila.dada@amyantek.com if you are interested in this 6 month contract with Workers Compensation Board Manitoba (WCB) with a possibility of extension, If you are not interested, please feel free to pass it in your network for anyone looking for work.

Position title:
RFP 098-WCB-26-017 Data Analyst

Working Status: Hybrid - Onsite at the WCB's facilities and from the Contractor's facilities located in Canada, as applicable

Location: 333/363 Broadway in Winnipeg, Manitoba

Start Date: April 27th, 2026

Hours per week: 36.25 Hours

The resources should have experience and knowledge including but not limited to the following:

• Ability to perform in a hybrid technical role that bridges Regulatory Compliance (Privacy/Security) and Database Engineering.
• Hands-on SQL engineering experience, with the ability to work effectively in Microsoft SQL Server environments. Must understand execution plans, metadata schemas (e.g., sys.tables, sys.columns), and data profiling techniques.
• Experience delivering projects involving FIPPA, PHIA, GDPR, CCPA, or HIPAA, with the ability to translate policy and compliance requirements into technical specifications.
• Experience managing data across on‑premises SQL Servers and Azure services (e.g., SQL Managed Instance, Data Factory), including an understanding of security considerations when transferring data between environments.
• Experience working in a regulated environment where every change is documented, peer-reviewed, and auditable.
• Knowledge of data discovery and data classification techniques, including familiarity with automated classification tools such as Azure Purview, Informatica, Titus, or other industry-standard solutions.
• Solid understanding of data‑masking techniques, including substitution, shuffling, blurring, and nulling.
• Experience performing post‑encryption and post‑masking quality assurance (QA) to ensure application functionality remains unaffected.
• Familiarity with Azure Data Factory (ADF) for data movement and Azure Monitor for tracking audit controls.
• Basic understanding of Key Management Services (KMS) and/or other networking and Infrastructure concepts and workflows.
• Knowledge of database backup/recovery patterns to ensure security and data controls are maintained during disaster recovery events.
• Meticulous approach to documentation, with the ability to produce “audit‑ready” artifacts demonstrating secure handling of data.
• An experience in implementing at least two of the following at scale: Data Classification, Static/Dynamic Data Masking, or Database Encryption (TDE/Always Encrypted) will be considered an asset.
• Strong interpersonal skills to collaborate effectively with Data Architects (on design), Infrastructure SMEs, DBAs (on implementation), and Legal/Compliance (on requirements).

Project Background

The WCB is running several initiatives and projects that are data-driven and as such intends to procure the services of an experienced data analyst on a contractual basis. These initiatives are fundamental in nature and involve Data classification, Data Encryption and Data Masking at enterprise level.

The WCB anticipates that this RFP will result in proposals from entities who are capable of providing an individual resource with the requisite experience and qualifications to work effectively as part of the team at the WCB that includes roles such as Database administrators, Solution Architects, technical Architects, data Architects, Project Managers, Business Analysts, Change Managers, Infrastructure specialists (include cloud) among others.

The WCB data landscape includes SQL (majority), some DB2, SQL MI and other ad hoc data sources.

The WCB's Business Intelligence team currently uses SQL, SQL MI, SSIS, SSAS, SSRS and Power BI reports.

The proposed data analyst should demonstrate strong teamwork and communication skills be able to work effectively within a Unionized/ Crown Corporation environment.

Change Management Requirements

The WCB has adopted the Prosci® methodology and the ADKAR® model as its enterprise approach to Change Management. The Successful Vendor resource should be well versed with the change management principles and should have an ability to work with the change management team as needed to effectively participate in and contribute to the change management activities associated with the data initiatives.

Description of Services

The WCB requires the Contracted resource to undertake activities that include, but not limited to, the following:

• General Responsibilities
• Act as a liaison between compliance requirements and technical data implementation.
• Translate privacy, security, industry and regulatory requirements into executable data analysis activities.
• Perform hands-on data analysis across MS SQL Server databases using SQL toolsets.
• Write and optimize SQL queries in SQL toolsets for data profiling, validation, metadata analysis, and reporting.
• Support gap analysis by comparing current data states against the desired data security posture.
• Collaborate closely with Data Architects, DBAs, Infrastructure, Security, BI, and Vendor teams to support the implementation of data management practices and a data management toolset implementation.

Maintain analysis artifacts, validation outputs, and supporting documentation to meet audit and review requirements.

• Data Classification
• Collaborate with WCB stakeholders to review and refine data classification outcomes.
• Conduct analysis of source data structures including schemas, tables, columns, and metadata repositories focusing on key data aspects that are considered confidential, restricted or privacy related.
• Develop and execute SQL queries for metadata extraction and classification analysis.
• Maintain and update the classification database in alignment with approved classification decisions.
• Implement approved classification changes within the classification database.
• Support tool-based automation and integration for data classification.
• Participate in classification reviews and incorporate stakeholder feedback.
• Plan and execute ongoing data validation and data sanitization activities in collaboration with database administrators (DBAs).
• Contribute to and provide support for Disaster Recovery (DR) and Business Continuity Planning (BCP) as it pertains to data and databases.
• Develop and maintain a calendarized data classification review process to ensure continuous classification updates and alignment with audit and compliance obligations.

• Data Encryption
• Assist in maintaining an up-to-date inventory of databases requiring encryption.
• Support impact analysis and assessment for encryption of operational, production and nonproduction Server databases.
• Assist with post-encryption testing and validation to ensure application and data integrity are maintained.
• Collaborate with Infrastructure teams to identify and implement required changes to backup, replication, and disaster recovery processes post-encryption.
• Assist in the design, setup, configuration, testing, and validation of Key Management Services (KMS) in line with encryption standards requirements and operational support requirements.

• Data Masking (Supporting Track)
• Identify data elements requiring masking based on approved data classification outcomes.
• Support the selection of appropriate masking techniques for identified data elements.
• Configure, execute, and validate masking rules within the approved data masking tool.
• Perform quality assurance (QA) and validation to ensure masking is applied as designed.
• Validate masked datasets to confirm there are no risks of reverse masking or re‑identification.
• Collaborate with Data Architects and vendors to support masking configuration and implementation.
• Assist in conceptualizing, designing, operationalizing and running a data masking service in the organization.

• Azure and Platform Support
• Provide comprehensive support for Azure-based environments, including Azure SQL Managed Instance, Azure Data Factory, and Azure data storage solutions, with a focus on data operations, analysis, and architecture.
• Assist in the design, implementation, and maintenance of data replication processes, data pipelines, data retention strategies, and storage management activities.
• Conduct data analysis, and validation across on-premises and Azure environments.
• Support data mapping and reporting activities to optimize processes that support classification, encryption, and masking initiatives.
• Develop and implement data audit and control frameworks to ensure secure and compliant management of data within cloud-based services.

• Data Management System Implementation and Support
• Act as a subject matter expert (SME) on implementation teams, providing functional and technical advisory support throughout system deployment and integration efforts.
• Develop, maintain, and deliver system documentation to support SMEs, operational teams, and ongoing data governance practices.
• Oversee and support the management of data management systems, specifically those related to data masking and classification ensuring alignment with industry standards and best practices.