Data Engineer – GCP

Bengaluru, Karnataka

Factspan Overview:

Factspan is a pure play data and analytics services organization. We partner with fortune 500 enterprises to build an

analytics center of excellence, generating insights and solutions from raw data to solve business challenges, make

strategic recommendations and implement new processes that help them succeed. With offices in Seattle, Washington and

Bengaluru, India; we use a global delivery model to service our customers. Our customers include industry leaders from

Retail, Financial Services, Hospitality, and technology sectors.

Project Overview

This role is part of the MarTech Data Engineering POD supporting a large-scale ESP (Email Service Provider) migration

program from Oracle Responsys to Adobe Journey Optimizer. The initiative aims to build a scalable, real-time marketing

data foundation integrating customer journeys, preference orchestration, and omnichannel personalization across email,

mobile, and direct channels.

The offshore team will focus on designing, building, and maintaining data pipelines across SAS, OES, Wunderkind, and AEP

(Adobe Experience Platform), enabling real-time campaign execution and advanced targeting capabilities.

Key Responsibilities:

• Design and develop data ingestion, transformation, and orchestration pipelines using GCP (BigQuery, Dataflow, Cloud

Composer) and Airflow.

• Implement and maintain data integrations between AEP and data lake, ensuring high performance and scalability.
• Build and optimize ETL/ELT workflows to support campaign orchestration, preference logic, and audience

segmentation.

• Implement data quality checks, monitoring, and exception handling frameworks to ensure clean and reliable data.
• Work closely with Lead DE and SME to translate campaign archetypes into data pipelines and orchestration rules.
• Support performance tuning, data reconciliation, and defect resolution during testing and hypercare phases.
• Collaborate with QA team for end-to-end test validation and ensure production readiness.
• Participate in daily Agile ceremonies, sprint reviews, and deployment planning.

Key Skills:

• Strong hands-on experience in GCP services: BigQuery, Dataflow, GCS, Cloud Composer (Airflow).
• Proficiency in SQL for data profiling, transformation, and performance optimization.
• Proficiency in Python for pipeline automation, scripting, and orchestration.
• Experience building batch and streaming data pipelines.
• Exposure to working with marketing or customer engagement platforms is a plus.
• Understanding of data quality, logging, monitoring, and alerting best practices.

Preferred Skills:

• Experience in Airflow DAG development for complex data pipelines.
• Familiarity with MarTech platforms such as Adobe Experience Platform or similar ESPs.
• Knowledge of data modeling for campaign orchestration and audience segmentation.
• Experience with CI/CD and DevOps principles for data deployments.
• Strong troubleshooting and performance tuning skills.

Soft Skills & Attributes:

• Strong problem-solving skills and attention to detail.
• Ability to work effectively in a distributed global POD model (onsite + offshore).
• Proactive communication and ownership mindset.
• Comfortable working in fast-paced agile environments with tight timelines.
• Excellent verbal and written communication skills

Education Qualification:

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• GCP certifications (e.g., Professional Data Engineer) preferred but not mandatory.

If you are passionate about leveraging technology to drive business innovation, possess excellent problem-solving skills,

and thrive in a dynamic environment, we encourage you to apply for this exciting opportunity. Join us in shaping the

future of data analytics and making a meaningful impact in the industry.