Data Engineer III

Pearson; Bengaluru; On-site; INR 1,000,000 - 1,700,000; Full time

Job summary

Pearson is hiring a Data Engineer III in India (Bangalore or Chennai) to design and implement data integration solutions across enterprise platforms. You will build Azure Data Factory pipelines and SQL-based transformations, collaborating with Data Modellers, Architects and other Engineers in an Agile setup.

You will work on Azure SQL, PostgreSQL and MySQL, optimise queries, and contribute to CI/CD, with a hybrid office model and a 45-hour work week in India.

Qualifications

• Hands-on experience with Azure Data Factory pipelines.
• Strong SQL development skills including complex queries and stored procedures.
• Experience with relational databases such as SQL Server/Azure SQL, PostgreSQL and MySQL.

Responsibilities

• Design, develop and maintain reusable Azure Data Factory pipelines following engineering standards.
• Develop SQL-based transformation logic to convert source data into target data models.
• Build and maintain database objects in Azure SQL, PostgreSQL or MySQL.
• Analyse SQL execution plans and implement query optimisation and indexing strategies.
• Develop automation scripts for deployment and operations.
• Support schema changes through GitHub and CI/CD pipelines.
• Collaborate with Data Modellers and Architects to implement data models.
• Participate in code reviews and document engineering best practices.

Skills

Azure Data Factory

SQL development

SQL Server/Azure SQL

PostgreSQL

MySQL

ETL/ELT

GitHub

Agile delivery

Tools

GitHub

Databricks

DBT

Job description

Role: Data Engineer III

Division: Assessment & Qualifications Delivery

Location: Bangalore or Chennai, India

About Pearson Qualifications: We are the UK's largest awarding body and we are regulated by Ofqual (England), CCEA Accreditation (Northern Ireland) and Qualifications Wales (Wales). We offer academic and vocational qualifications that are globally recognised and benchmarked, with educational excellence rooted in names like Edexcel and BTEC. In 2025, we issued 6.5 million grades to candidates worldwide.

About the role

The Data Engineer is responsible for developing and supporting data integration and transformation solutions across Pearson's enterprise data platforms.

Working within the Data Engineering team, you will develop Azure Data Factory (ADF) pipelines and SQL-based transformation logic to move data from operational systems into common data models used by downstream applications.

This is a hands‑on engineering role and would suit someone with strong experience in both Azure Data Factory and SQL database development. You will work closely with Data Modellers, Architects and fellow Data Engineers to deliver reliable, scalable and maintainable data integration solutions.

About You

You are a hands‑on Data Engineer with strong experience in Azure Data Factory and SQL database development. You enjoy solving complex data integration problems and are equally comfortable building cloud‑based data pipelines and implementing SQL transformation logic within relational databases.

You have a strong engineering mindset, write clean, maintainable code and are comfortable working within an Agile delivery environment.

Key Responsibilities

• Design, develop and maintain reusable, parameterised Azure Data Factory (ADF) pipelines following established engineering standards.
• Develop SQL-based transformation logic to convert source data into target data models using complex queries, stored procedures, views and functions.
• Build and maintain database objects within Azure SQL Managed Instance, Aurora MySQL or PostgreSQL.
• Analyse SQL execution plans and implement query optimisation and indexing strategies to improve database performance.
• Develop automation scripts to support database deployment and operational activities.
• Support database schema changes through GitHub and CI/CD pipelines.
• Work with Data Modellers and Architects to implement agreed data models and transformation logic.
• Support the diagnosis and resolution of issues relating to data pipelines, data transformations and database performance.
• Participate in code reviews and contribute to engineering best practices.
• Produce technical documentation where required.

Essential Skills & Experience

• Strong hands‑on experience developing Azure Data Factory (ADF) pipelines.
• Strong SQL development skills, including complex queries, stored procedures, views and functions.
• Experience developing large‑scale SQL data transformation solutions.
• Experience analysing SQL execution plans and implementing query optimisation techniques.
• Experience implementing indexing strategies and database performance tuning.
• Strong hands‑on database development experience with SQL Server/Azure SQL, PostgreSQL and/or MySQL, with the ability to apply SQL engineering and performance‑tuning skills across different relational database platforms.
• Experience developing ETL/ELT solutions.
• Experience using GitHub or similar version control systems.
• Good analytical and problem‑solving skills.
• Experience working in Agile delivery teams.

Desirable Skills & Experience

• Familiarity with DACPAC-based database deployment.
• Hands‑on experience with Databricks (Python or Scala) or DBT.
• Experience working with Change Data Capture (CDC).
• Experience with AWS Database Migration Service (AWS DMS) or similar database migration technologies.
• Exposure to enterprise data integration or platform-based environments.
• Azure or AWS certification.

Job Location and Hours

The role is aligned to our Bangalore or Chennai offices in India, working a 45 hour week. All our roles are hybrid working; our current policy requires our team to work from their base office 3 times per week.

Who we are:

At Pearson, our purpose is simple: to help people realize the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are. To learn more: We are Pearson.

Pearson is an Equal Opportunity Employer and a member of E-Verify. Employment decisions are based on qualifications, merit and business need. Qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status or any other group protected by law. We actively seek qualified candidates who are protected veterans and individuals with disabilities as defined under VEVRAA and Section 503 of the Rehabilitation Act.

If you are an individual with a disability and are unable or limited in your ability to use or access our career site as a result of your disability, you may request reasonable accommodations by emailing [e-mail].

Job: Engineering

Job Family: TECHNOLOGY

Organization: Assessment & Qualifications

Schedule: FULL_TIME

Workplace Type: Hybrid

Req ID: 25772