Data Engineer [Remote]

Job Responsibilities:

• Develop and maintain ACDP (Ads Common Data Platform) data pipelines and warehouse tables
• Support revenue metrics reporting and opportunity score calculations, and help onboarding new advertiser guidance data to ACDP
• Perform and implement data quality checks and troubleshoot pipeline issues
• Assist with ACDP privacy compliance and data asset (table/pipeline/dashboard) TIER0 certification processes
• Provide technical guidance on data source selection and query optimization

Skills:

• SQL/Presto Expertise: Advanced proficiency in crafting complex SQL queries, with deep experience using Presto for large-scale data analysis and pipeline development.
• Data Pipeline Authoring: Proven track record in designing and building scalable, high-performance ETL/ELT pipelines, data warehouses, and orchestrating workflows with
• modern tools.
• KPI & Revenue Metrics Reporting / Visualization: Strong industry knowledge in revenue reporting and business intelligence KPI development, including metric design, analysis, and reporting.
• Data Quality &Troubleshooting: Exceptional analytical skills for detecting data discrepancies, performing root cause analysis and implementing robust data validation processes.
• Ads Domain Knowledge: Solid understanding of advertising data models, campaign structures, and reporting requirements within the advertising industry.
• Excellent communication skills
• Extensive hands-on knowledge of building pipelines
• Data modeling experience
• Strong Python coding experience

Education/Experience:

• Experience with Hive tables and data warehouse optimization
• Knowledge of data governance and compliance requirements
• Ability to work with cross-functional teams including sales, product, and analytics teams
• Strong communication skills for technical documentation and stakeholder support