Data Engineer III
Role: Data Engineer III Location: Remote, high preference in PST Experience Level: 3+ Years Data Engineer with 3-5 years of experience in ads data platform engineering, SQL/Presto query optimization, data pipeline development, revenue metrics analysis, and data quality management. Key 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 Required 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 Additional Qualifications: - 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 Must have Skills: - Extensive hands on knowledge of building pipelines - Data modeling experience - Strong Python coding experience Nice-to-have Skills: - Ads industry knowledge - AI Experience