Data Engineer - L2

· Build and maintain data ingestion pipelines from APIs and other data sources

· Write efficient Python and SQL for data transformation and processing

· Support ETL/ELT workflows, microservices and ensure timely data availability

· Troubleshoot pipeline failures and assist in performance improvements

Marketing Data Support

· Assist in ingestion and modeling of data from Meta Ads and similar platforms

· Help create datasets for:

o Campaign performance reporting

o Lead funnel tracking

· Develop familiarity with:

o Campaign structure (campaign/ad set/ad level)

o Basic performance metrics (CTR, CPC, CPA)

o Conversion tracking concepts

Business Collaboration

· Work with marketing and analytics teams to understand data requirements

· Support analysis related to lead quality and campaign performance

· Help translate business needs into data queries and datasets

Data Quality & Maintenance

· Implement basic data validation checks

· Monitor pipelines and resolve data issues

· Maintain documentation for pipelines and datasets

· Required Skills & Qualifications

· Core Technical Skills

· Proficiency in Python (data processing, API handling)

· Strong SQL skills

· Experience with data ingestion from APIs (basic handling of pagination, retries)

· Familiarity with workflow orchestration tools (e.g., Airflow or similar)