Test Data Architect

The Opportunity

John Hancock has an unique opportunity for the incumbent to define and implement enterprise wide processes to consume and streamline test data provisioning test data masking automation and environment set up tasks that can easily transform data for use by the quality engineering team.

This role is responsible for designing and implementing strategies for Test Data Management across software development lifecycle. This includes data Provisioning ensuring HIPAA and other regulatory compliance. This role needs to be a dedicated role that works collaboratively with data architects to engineer test data into the lower environments. The data architects are confined to leading data initiatives and are seldom engaged in understanding the transactional test data needs. An architect is needed to understand the underlying data structure and work with the Test Data Lead and Test Environments Manager to maintain test data. This is not a QA Testing role rather a Test Data Architect role.

Office location: Boston - USA (ideally) or Toronto - Canada or Waterloo - Canada

Work arrangement: Hybrid - 3 days in office 2 days from Home;

Remote working option is not available.

Position Responsibilities:

• Design and Implement test data Management frameworks and solutions

• Develop strategies for synthetic data generation data masking etc.

• Define and Enforce data Governance and access Controls for test environment.

• Understand the overall design and structure of data landscape in the organization.

• Implement processes for data integration.

• The candidate will also be working with the other Solution and Enterprise Architects in the team to understand data requirements across the segment and implement industry best practices to refine test data architecture.

• Implement processes to consume test data in lower environments

• Architect reusable frameworks to adopt data masking and data provisioning

• Support data versioning and rollback strategies for various test scenarios

• Define and enforce data quality standards across platforms

• Produce key test design documents and incremental data architecture artifacts based on project needs and our architectural target state

• Develop related test data frameworks design patterns proof-of-concepts and best practices for managing a robust test data network

• Align on environment data governance

• Architect synthetic data generation solutions to enable robust testing in non-production environments

• Drive AI led data initiatives and self-service capabilities

• Help synchronizing systems to have accurate data

• Support all functional and non-functional testing needs

• Collaborate with global data engineers architects DevOps teams

• Propose efficient data solutions to manage transition of data downstream

Required Qualifications:

• At least 8 year IT industry experience

• 6 years of experience in data management and data systems is required

• Current with modern data engineering principles frameworks and design patterns in a Cloud environment Azure preferred

• Expertise in data masking synthetic data generation and sub setting techniques

• AI driven data strategies

• Experience with data modelling

• MUST have solid understanding of Test automation framework and Test strategies

• MUST have some Data Architecture experience but overall solid knowledge and understanding of it

Preferred Qualifications:

• Working knowledge with various python libraries/frameworks such as NumPy Pandas Matplotlib PyTorch Tensorflow Keras is a definite plus.

• Experience with most of the following technologies is desirable - Informatica (ETL CDI TDM IICS DQ); DB/Middleware - SQL Oracle MySQL Postgres DB2 Hadoop WebSphere Pega; Analytics/Governance Synapse Databricks MLOps Purview; MDM Informatica InfoSphere Quality Stage; Reporting Power BI Cognos Tableau Erwin.

• Bachelors in a Data Science/Data Architect field

• Certifications are highly desired but not an absolute must have.

When you join our team:

• Well empower you to learn and grow the career you want.

• Well recognize and support you in a flexible environment where well-being and inclusion are more than just words.

• As part of our global team well support you in shaping the future you want to see.

#LI-JH

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider helping people make their decisions easier and lives better. To learn more about us visit is an Equal Opportunity Employer

At Manulife/John Hancock we embrace our diversity. We strive to attract develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment retention advancement and compensation and we administer all of our practices and programs without discrimination on the basis of race ancestry place of origin colour ethnic origin citizenship religion or religious beliefs creed sex (including pregnancy and pregnancy-related conditions) sexual orientation genetic characteristics veteran status gender identity gender expression age marital status family status disability or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process contact .

Referenced Salary Location