ANKITA PRADEEP
Bridgewater
Summary
Senior Data Engineer with 6+ years designing and operating production data platforms. Expertise in scalable ELT pipelines, automated ingestion, data reliability engineering, and orchestration (Cloud Composer / Airflow) for secure third-party fintech integrations, alongside AI-assisted analytics (RAG/agents) on GCP (BigQuery, GKE, Vertex AI) for internal incident and availability insights.
Overview
8
8
years of professional experience
Work History
Software Engineer III
Wayfair
Boston
05.2025 - Current
- Built and deployed an Incident Analytics AI bot using Google ADK with RAG pipelines on GKE, enabling teams across Wayfair to query incident data, generate analytical insights, and visualize trends via natural language.
- Led first-of-its-kind near-real-time customer data exchange pipeline with Citi Bank supporting WFCC underwriting via BigQuery, Aerospik and external APIs, enabling a projected 10%+ lift (~12K incremental cards) in approval rates.
- Provisioned and managed decoupled GCP projects using Terraform and CI/CD (Buildkite), enabling secure, compliant data integrations and repeatable infrastructure for platform and analytics workloads.
- Developed an automated postmortem action reminder bot to enforce ownership of remediation items, improving 30-day PMA SLA compliance by 28% and strengthening incident prevention and reliability accountability.
- Led an org-wide PagerDuty service health analysis across ~3,000 services, identifying inactive or misconfigured monitoring (~27%) and driving service catalog cleanup to eliminate monitoring blind spots and silent failures.
Data Engineer III
Wayfair
Boston
04.2023 - 04.2025
- Led multi-month payment and fraud data pipeline initiatives, partnering with analytics and engineering teams to deliver production-grade ETL pipelines and datasets supporting a new customer payments platform spanning PSPs, banks, and downstream financial systems.
- Owned the design and delivery of a reusable automated file ingestion framework built in Python with containerized CI/CD workflows (Docker, Kubernetes), supporting SFTP, GCS, and AWS S3 data exchange; enabled secure third-party integrations with fintech partners (e.g., Stripe, Braintree, PayPal, Klarna, Citi) and reduced ingestion latency from days to under 30 minutes.
- Acted as a multiplier across the organization by mentoring engineers and contractors, co-running mentorship programs, owning sprint prioritization, and coordinating execution across multiple teams on large data initiatives.
- Built end-to-end analytics and reporting for the Wayfair Loyalty Rewards program, supporting a 1.2M-member program responsible for ~16% of Wayfair’s GRS, with visibility into acquisition, rewards earn/redeem activity, customer behavior, and financial performance.
Data Engineer II
Wayfair
Boston
01.2021 - 03.2023
- Built and maintained ELT pipelines and Looker reporting across Fintech and Loyalty, supporting analytics for credit cards, financing, gift cards, payments, fraud, and third-party data integrations.
- Designed and implemented a restricted data project to securely handle sensitive financial data, leveraging Terraform, IAM, and BigQuery to meet privacy and access-control requirements.
- Reduced SLA misses across 50+ data products by developing self-healing ETL logic that automatically resolved primary-key duplication, allowing downstream pipelines to continue running and meet end-to-end SLAs.
- Developed metadata-driven data quality checks and automated error handling, reducing manual data triage by ~2 hours per day, and improving overall pipeline reliability.
- Mentored and managed junior engineers while supporting Fintech and Loyalty reporting needs, leading sprint planning, roadmap execution, and cross-team collaboration across analytics and software engineering
Data Engineer I
Wayfair
Boston
08.2019 - 12.2020
- Executed the data engineering roadmap and core data architecture to unify multi-granularity metrics (order, product, customer, and operational) into a cohesive ~35-metric reporting suite on BigQuery and Data Studio, enabling optimization insights across a ~$1.6B multi-box product portfolio.
- Supported the end-to-end migration of a primary data mart from on-prem to GCP, improving SLA compliance and data availability by 2,800 bps for over 2,000 monthly active users in Global Operations and Logistics.
- Built end-to-end supply chain analytics by designing fact and dimensional models in Vertica (SQL), developing 40+ KPIs in AtScale OLAP cubes, and delivering Tableau dashboards to track delivery, supplier performance, transportation, inventory, and fulfillment metrics, enabling faster detection and resolution of operational issues.
Business Intelligence Analyst Co-op
Wayfair
Boston
07.2018 - 12.2018
- Developed and optimized SQL pipelines on Vertica and designed multi-dimensional OLAP cubes in SSAS (SQL Server) using Visual Studio, including dimension and metric modeling to support analytical reporting on fill rate, order thresholds, and delivery performance.
- Developed 16 interactive Tableau dashboards for business stakeholders to monitor the on-time registration rates and label printing compliance of over 30,000 suppliers.
Education
Master of Science - Data Analytics Engineering
Northeastern University
Boston, MA05.2019
Bachelor of Engineering - Industrial Engineering
Visvesvaraya Technological University
Karnataka, India05.2014
Skills
- Programming Languages: Python, SQL (Advanced)
- Cloud Platforms: GCP (BigQuery, GKE, Vertex AI, Google Cloud Storage)
- Databases (SQL): PostgreSQL, MySQL, SQL Server, BigQuery
- Data Warehousing: BigQuery, analytical data marts, dimensional modeling (fact/dimension, multi-granularity datasets)
- Workflow Orchestration: Cloud Composer (Apache Airflow), DAG design, dependency management, backfills, SLA enforcement
- ETL / ELT Tools: dbt, Dataform
- Data Pipeline Architecture: ELT/ETL design, batch & near-real-time processing, change-data & audit patterns, automated ingestion (SFTP, GCS, AWS S3)
- API & Integration Development: REST APIs, Slack API integrations, PagerDuty API ingestion, CloudQuery data integrations, webhook-driven workflows
- AI & Agent Development: Google ADK agents, retrieval-augmented generation (RAG), tool/function calling, prompt design, agent workflows, analytical Q&A systems
- Data Visualization: Looker, Tableau, Google Data Studio, Power BI
- DevOps / Infrastructure: Terraform (Infrastructure as Code), IAM, decoupled project setup, CI/CD (Buildkite), Docker, Kubernetes
- Data Governance & Quality: Data reliability engineering, observability, alerting, self-healing pipelines, access control, runbooks, postmortems
Awards
Outstanding MS Student Leadership Award, Northeastern University, 05/19
Timeline
Software Engineer III
Wayfair
05.2025 - Current
Data Engineer III
Wayfair
04.2023 - 04.2025
Data Engineer II
Wayfair
01.2021 - 03.2023
Data Engineer I
Wayfair
08.2019 - 12.2020
Business Intelligence Analyst Co-op
Wayfair
07.2018 - 12.2018
Master of Science - Data Analytics Engineering
Northeastern University
Bachelor of Engineering - Industrial Engineering
Visvesvaraya Technological University