Forbes Advisor Logo

Forbes Advisor

Lead Data Engineer

Posted 4 Days Ago
Be an Early Applicant
Hybrid
Mumbai, Maharashtra, IND
Mid level
Hybrid
Mumbai, Maharashtra, IND
Mid level
The Lead Data Engineer is responsible for designing data pipelines, optimizing data models, and collaborating with marketing teams to ensure data quality and effective decision-making in campaigns.
The summary above was generated by AI
Company Description

Forbes Advisor is a new initiative for consumers under the Forbes Marketplace umbrella that provides journalist- and expert-written insights, news and reviews on all things personal finance, health, business, and everyday life decisions.  We do this by providing consumers with the knowledge and research they need to make informed decisions they can feel confident in, so they can get back to doing the things they care about most.

We are looking for a highly skilled Data Engineer (L3) with strong expertise in Python, data ingestion pipelines and marketing data systems, particularly with the Meta Ads ecosystem. This role sits at the intersection of data engineering and social/native platforms, enabling scalable data pipelines, high-quality datasets, and lead generation and business decision-making.

This role goes beyond building pipelines - will be responsible for: 
·    Designing scalable data architecture
·    Driving business outcomes (revenue, lead quality, conversion efficiency)
·    Owning how data is used, trusted and acted upon

The ideal candidate will not manage campaign buying or bidding directly but must clearly understand ad platform mechanics, attribution models and lead quality scores and will work closely with the Data Lead / Engineering Lead, acting as a key contributor in shaping solutions, making technical decisions, and delivering high-impact data products.
 

Job Description

Responsibilities: 
1. Data Engineering & Pipelines
·    Design, build, and maintain robust data data pipelines for social marketing and product data sources (APIs, event streams, batch systems)
·    Develop scalable ETL/ELT workflows / microservices using Python and SQL
·    Ensure high data quality, reliability and observability across pipelines
·    Optimize data models for analytics and reporting use cases
2. Marketing & Ad Platform Data
1.    Own ingestion and modeling of data from Meta Ads (Facebook) and other digital marketing platforms
2.    Build datasets that support:
·    Campaign performance tracking
·    Lead funnel analysis
·    Attribution and conversion tracking
3.    Understand key concepts such as:
·    Campaign structure (campaign/ad set/ad level)
·    Bidding & optimization signals
·    Attribution windows
·    Pixel / event tracking
3. Business Understanding & Collaboration
·    Translate business requirements from marketing, growth and product teams into scalable data solutions
·    Define success metrics tied to revenue and performance
·    Enable self-serve analytics through well-structured datasets
4. Data Quality & Governance
·    Implement validation checks, monitoring and alerting for pipelines
·    Ensure consistency across different marketing data sources
·    Maintain clear documentation of data models and pipelines
5. Business Collaboration & Use Case Ownership
•    Work closely with marketing, growth, and analytics teams to:
    Understand real-world use cases
    Define success metrics tied to revenue and performance

•    Own key use cases such as:
    Lead funnel optimization
    Campaign attribution
    Revenue reporting and forecasting

•    Ensure data enables decision-making, not just reporting
6. Engineering Standards & Best Practices
·    Design and implement modular, reusable microservices that enable the scalable development of data products.
·    Drive standardization through well-architected, loosely coupled services that can be leveraged across multiple use cases.
·    Uphold high standards in:
    Code quality and modularity
    Pipeline reliability and monitoring
    Documentation and data contracts
·    Contribute to shared frameworks and reusable components
·    Promote best practices across the data engineering team
 

Qualifications

Required Skills & Qualifications
1.    Core Technical Skills
·    Strong proficiency in Python (must-have)
·    Advanced SQL skills for large-scale data processing
·    Hands-on experience with data ingestion from APIs (rate limits, pagination, retries)
·    Experience with data orchestration tools (e.g., Airflow or equivalent)
·    Familiarity with cloud data platforms (BigQuery, etc.)
·    Experience building scalable data ingestion systems
·    Familiarity with microservices-style or modular data systems
·    Strong understanding of performance and cost optimization

2.    Ad Platform Knowledge
·    Solid understanding of Meta Ads platform fundamentals
·    Familiarity with:
•    Campaign hierarchy and metrics (CTR, CPC, CPA, ROAS)
•    Conversion tracking and attribution models
•    Lead generation workflows and funnel metrics
·    Ability to interpret marketing data beyond surface-level metrics
·    Exposure to event tracking systems (GA4, Snowplow, etc)
Good to Have
·    Experience with other ad platforms (Google Ads, Bing Ads, etc.)
·    Knowledge of data modeling best practices (e.g., star schema, dbt)
·    Experience with real-time or near real-time data pipelines
What Success Looks Like
·    Reliable, scalable pipelines for marketing data ingestion
·    High-quality datasets enabling accurate campaign and lead analysis
·    Strong partnership with marketing teams, translating business needs into data solutions
·    Improved visibility into lead quality, attribution and campaign performance
·    Clear ownership of end-to-end data use cases, not just components

 

Additional Information

Why Join Us
·    Work at the intersection of data engineering and growth marketing
·    Solve high-impact problems in performance marketing and attribution
·    Own meaningful data products end-to-end
·    Influence both technical architecture and business outcomes
·    Be part of a team that values ownership, impact and engineering excellence

 

Perks:

  • Day off on the 3rd Friday of every month (one long weekend each month)
  • Monthly Wellness Reimbursement Program to promote health well-being
  • Monthly Office Commutation Reimbursement Program
  • Paid paternity and maternity leaves

Top Skills

Airflow
BigQuery
Python
SQL

Similar Jobs

5 Days Ago
In-Office
Senior level
Senior level
Healthtech • Logistics • Pharmaceutical
The Lead Data Engineer will design and implement data pipelines in Databricks, ensuring data quality and governance while collaborating with internal audit teams.
Top Skills: AirflowAzure Data FactoryDatabricksDelta LakePysparkPythonSparkSQL
6 Days Ago
In-Office
Mumbai, Maharashtra, IND
Senior level
Senior level
Fintech • Financial Services
As a Lead Data Engineer, you'll guide the development of enterprise data solutions, leveraging advanced technologies while mentoring a team and ensuring collaboration with various stakeholders.
Top Skills: Ai/Ml TechniquesApache AirflowGenaiPower BIPythonShell ScriptingSnowflakeSQL
7 Days Ago
In-Office or Remote
IN
Mid level
Mid level
Insurance
The Lead Data Engineer will design and build scalable data pipelines on Databricks, develop ETL/ELT pipelines with PySpark, and mentor engineering teams for data transformation and analytics.
Top Skills: DatabricksPysparkPythonSQL

What you need to know about the Mumbai Tech Scene

From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account