Data Engineer III

Pearson; Chennai District; Hybrid; INR 1,800,000 - 3,200,000; Full time

Job summary

Pearson is hiring a Data Engineer to design and deliver data integration solutions across enterprise data platforms in Bengaluru or Chennai. The role focuses on building Azure Data Factory pipelines and SQL transformation logic to move data from operational systems into common data models used by downstream apps.

You will collaborate with Data Modellers and Architects, work in an Agile team, and ensure scalable, maintainable data integration solutions. The position is hybrid with 45-hour weeks.

Qualifications

• Hands-on Data Engineer with strong experience in Azure Data Factory and SQL database development.
• Experience building cloud-based data pipelines and SQL transformation logic.
• Comfortable working in Agile delivery environments.

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.
• Strong hands-on experience developing Azure Data Factory (ADF) pipelines.
• Strong SQL development skills, including complex queries, stored procedures, views and functions.
• 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 using GitHub or similar version control systems.
• Good analytical and problem-solving skills.
• Experience working in Agile delivery teams.
• 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.

Skills

Azure Data Factory

SQL development

Data modeling

Agile delivery

GitHub

Databricks

DBT

Python

CDC

AWS DMS

Tools

Azure Data Factory

GitHub

Databricks

Job description

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.
• Strong hands-on experience developing Azure Data Factory (ADF) pipelines.
• Strong SQL development skills, including complex queries, stored procedures, views and functions.
• 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 using GitHub or similar version control systems.
• Good analytical and problem-solving skills.
• Experience working in Agile delivery teams.
• 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.

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 Family:

TECHNOLOGY

Organization:

Assessment & Qualifications