**Job Title:** Data Engineer II **Description:** In this role, you'll be building and maintaining scalable data pipelines and analytics solutions. **Experience: 2** –4 years **Location:** Chennai, India We're looking for a Data Engineer with 2–4 years of experience building and maintaining scalable data pipelines and analytics solutions. The ideal candidate has strong SQL, solid data warehousing and dimensional modeling skills, and hands-on experience with cloud platforms — preferably Google Cloud Platform (GCP). You'll work with business stakeholders, analysts, and engineering teams to build reliable data solutions that power reporting, analytics, and AI-driven initiatives. **Key Responsibilities** + Design, build, and maintain scalable ETL/ELT pipelines. + Develop data models, dimensional schemas, and data marts for analytics and reporting. + Ensure data quality, consistency, and governance across platforms. + Optimize SQL queries and pipelines for performance and cost. + Partner with analytics teams to turn data requirements into technical solutions and curated datasets. **Required Skills** + **2–4 years in Data Engineering** with strong ETL/ELT and pipeline design experience. + **Advanced SQL** and a strong grasp of data warehousing, dimensional modeling, star/snowflake schemas, and facts/dimensions/metrics. + **Hands-on GCP experience** (BigQuery, Dataflow, Cloud Storage, Composer, Pub/Sub, etc.). + **Proficiency in Python** for data processing and automation. **Preferred (Added Advantage)** + GCP Professional certification(s) and/or AI/ML certifications. + Familiarity with lakehouse architectures, Databricks, or data governance tools. + Looker/LookML semantic modeling and dashboard development. + Understanding of BI/reporting concepts; experience with tools like Looker, Power BI, or Tableau. **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 [email protected]. **Job:** Engineering **Job Family:** TECHNOLOGY **Organization:** OCTO **Schedule:** FULL\_TIME **Workplace Type:** Hybrid **Req ID:** 24707