Junior Data Test Engineer (JR101787)

Clarion Events; London; On-site; GBP 30,000 - 50,000; Full time

Job summary

Join a dynamic global business as a Junior Data Test Engineer, where you will be part of a rapidly growing data team. This exciting opportunity involves assisting in designing and maintaining the testing strategy for a customer data platform and BI solution. You will collaborate with a talented team of database architects and developers to enhance your skills in SQL, Python, and Azure. The role offers a chance to work on innovative projects in a supportive environment that values creativity and teamwork. If you are passionate about data and looking to grow your career, this is the perfect opportunity for you.

Benefits

25 days’ holiday plus bank holidays

End of year wellbeing shutdown

Celebration day off

Summer Hours in August

Helping Our World (HOW) Days

Pension Scheme

Private Medical Insurance

Health Cash Plan

Employee Assistance Programme

Free on-site gym and shower facilities

Qualifications

• Experience in testing data validation scenarios and ETL processes.
• Familiarity with big data engineering tools and Agile methodologies.
• Hands-on experience with SQL and No-SQL database systems.

Responsibilities

• Assist with developing test plans and execute test scripts.
• Conduct various testing types including system and integration testing.
• Communicate defects identified in testing to developers using Jira.

Skills

SQL

Python

ETL

Agile Software Development

Data Validation

Data Ingestion

Testing Development Practices

API Calls

Education

Bachelor's degree in Computer Science or related field

Tools

Jira

Power BI

Azure

Synapse

Hive

Presto

Dig Dag

YAML

Job description

At Clarion, our people are at the absolute heart of what we do. We’re proud that our core values of PASSION, CARE, IMAGINATION, and TRUST define the way we carry out our work across all of our exhibitions and conferences.

If you share our values and want to be a part of a successful, dynamic, and creative global business then we want to hear from you.

The Opportunity:

This is a great opportunity for a Junior Data Test Engineer to join a rapidly growing data team in Clarion. Reporting to the Senior Architect, you will be responsible for assisting with designing and maintaining the testing and testing strategy across our customer data platform and BI solution. You will be working with a small team which consists of database architects, developers, testers, administrators and integration developers and can grow your development skills in Azure, Synapse, Python and SQL.

Key Responsibilities:

• Assist with Developing Test Plans, test scripts and execute the test scripts.
• Conduct system testing, integration testing, functional testing, and end to end testing throughout various project iterations/sprints.
• Learn to develop complex SQL queries for querying data against different databases or source systems for data verification.
• Prepare the test plan and testing strategies for data warehousing applications.
• Interact with developers, business, and management teams to understand project business requirements and ETL design document specifications.
• Participate in regular project status and QA meetings.
• Communicate defects identified in testing/dev environment to developers using Jira.
• Create test cases for ETL mappings and design documents for production support.
• Work with flat files, XML, and JSON data sources.
• Write scripts to test files data in the databases.
• Effectively communicate testing activities and findings in oral and written formats.
• Work on issues with migration of data from development to production environments.
• Test Power BI reports to validate data and report cosmetics.

Knowledge, Skills, and Qualifications:

• Experience in testing data validation scenarios and data ingestion, pipelines, and transformation processes (e.g. ETL, ELT).
• Understanding of big data engineering tools and their strategic applications (beneficial).
• Understanding of information governance principles applicable in a testing capacity.
• Hands-on experience with issue and defect management.
• Experience in testing systems that capture, verify, and maintain field generated metadata.
• Familiarity with multiple back-end and front-end languages and libraries, databases, and database design (e.g. SQL, Hive and/or Presto, Azure environment preferred. Python, DAX, Dig Dag, YAML beneficial).
• Knowledge and experience with modern testing development practices and integrated testing products.
• Experience working with a wide variety of technologies and diverse problems.
• Experience with Agile Software Development and Testing methods for cloud deployments.
• Experience with SQL and No-SQL database systems.
• Experience with Power BI.
• Experience working with API calls to retrieve data.
• Basic knowledge in creating Test Plans, Test Cases, Test Scenarios, and Test Strategies for Quality Assurance.

About Clarion Events

Clarion Events is one of the world’s leading event organisers, producing and delivering innovative and market-leading events since 1947. (https://clarionevents.com/welcome)

Clarion Events embrace diversity and equal opportunities in all that we do. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. The more inclusive we are, the better our work will be.

Clarion is private equity backed and owned by Blackstone. Blackstone is one of the world’s leading global investment funds, investing capital for the long term in order to build successful, resilient businesses. (https://www.blackstone.com/)

Our purpose is to deliver exceptional customer outcomes and experiences by making every connection count.

Our vision is to ensure that every one of our products is a market leader in customer satisfaction and delight.

Benefits:

• 25 days’ holiday plus bank holidays
• End of year wellbeing shutdown (closed for the last week of the year)
• Celebration day off (e.g. birthday, Diwali, Eid, etc)
• Summer Hours in August (3pm finish on Fridays)
• Helping Our World (HOW) Days – one paid day per quarter to carry out charity work
• Pension Scheme
• Private Medical Insurance
• Health Cash Plan
• Employee Assistance Programme (EAP) – a 24/7, 365-day confidential helpline
• Subsidised Café
• Season Ticket Loan
• Cycle to Work Schemes
• Free on-site gym and shower facilities
• Free eyesight tests
• Free flu vaccination – offered on site once a year for all employees