QA and Data Analyst (Microsoft Dynamics)

WPP IT is in charge of providing IT services for WPP, the largest global communications services group. As a company dedicated to creative transformation, WPP aids its clients in reshaping the future through exceptional work. WPP IT plays an essential role in this journey, and we take pride in providing technology for some of the world’s most creative brands.

Why we're hiring:

The function of a QA/Test and Data Analyst is to assure the quality and accuracy of data used in various systems and applications. They are tasked with analyzing data, pinpointing anomalies, and verifying data integrity. The QA/Test and Data Analyst collaborates with stakeholders to comprehend data requirements, devise testing methodologies, and implement data quality checks. Their role is indispensable in ensuring data consistency, reliability, and adherence to data standards, ultimately supporting well-informed decision-making and reliable data-driven insights for the organization.

Reporting to the QA/Test Manager for D365, you will be instrumental in working in the program from its initial setup through to delivery and across future market deployments and platform updates (a minimum of 2 mandated per year)

What you'll be doing:

The primary responsibilities of the D365 QA/Test and Data Analyst encompass:

• Ensuring the accuracy, completeness, and consistency of data within the Microsoft Dynamics 365 system.
• Conducting data analysis to identify patterns, trends, and anomalies within the D365 data to provide valuable insights to stakeholders.
• Designing and executing data validation tests to confirm the integrity and reliability of data used in D365 processes.
• Aiding in data migration efforts, verifying data mappings, and ensuring successful data transfers into D365.
• Developing test plans and test scenarios specific to data validations and data-driven functionalities in D365.
• Conducting data-centric testing, verifying data transformations, and validating data-driven functionalities in D365.
• Identifying and documenting data-related defects and working with the development team to resolve issues.
• Creating data visualizations and reports to present data analysis findings to stakeholders.
• Maintaining detailed documentation of data validations, test results, and data analysis reports.
• Working closely with other team members, such as QA testers, developers, and business analysts, to ensure effective communication and coordination.
• Ensuring compliance with data governance policies and data privacy regulations within the D365 environment.
• Identifying and recommending data cleaning processes to maintain data quality.
• Taking part in data transformation efforts to align data with business requirements and standards.
• Using data mining techniques to extract significant information and support business decision-making.
• Detecting opportunities to improve data quality, testing processes, and data analysis methodologies.
• Cooperating with business stakeholders to construct test and meta data to support test case execution.
• Demonstrable experience in testing integrations across various implementation methods including but not limited to batch, real time, overnight, message queues, API, Web Services.

By fulfilling these responsibilities, the D365 QA/Test and Data Analyst plays a critical role in ensuring the accuracy and reliability of data within Microsoft Dynamics 365, providing valuable data insights to stakeholders, and contributing to the successful implementation and usage of D365 solutions within the organization.

What you'll need:

The skills necessary for a D365 QA/Test and Data Analyst typically include a mix of technical, analytical, and communication skills. Here are some key skills needed for this position:

• Strong data analysis skills to assess data quality, identify patterns, trends, and anomalies within the D365 system.
• In-depth familiarity with Microsoft Dynamics 365, its data structures, and functionalities to effectively carry out data analysis and validations.
• The ability to design and execute data validation tests to ensure data integrity and accuracy within D365.
• Proficiency in data visualization tools and techniques to present data analysis findings in a clear, meaningful manner.
• A good knowledge of queries and database management to access and manipulate data within D365.
• An understanding of data transformation processes to align data with business requirements and standards.
• Knowledge of data mining techniques to extract valuable insights and support decision-making processes.
• Skills in developing test plans and executing data-centric test scenarios to validate data-driven functionalities in D365.

• Knowledge of test automation tools and frameworks to automate repetitive test cases and improve testing efficiency. Ideally, should have experience with RSAT.

  • The ability to identify, document, and communicate data-related defects to the development team.
  • Excellent communication and interpersonal skills to effectively collaborate with team members and present data analysis findings to stakeholders.
  • Strong problem-solving skills to troubleshoot data-related issues and identify solutions.
  • An understanding of data governance principles and data privacy regulations to ensure compliance within the D365 environment.
  • The capability to work collaboratively with cross.