Data Engineer III

American IT Systems • Redmond, WA

5d • Remote

About The Position

We are seeking a Data Engineer III with 3-5 years of experience to join our team. This role focuses on ads data platform engineering, SQL/Presto query optimization, data pipeline development, revenue metrics analysis, and data quality management. The ideal candidate will be instrumental in developing and maintaining our Ads Common Data Platform (ACDP), supporting critical revenue metrics, and ensuring data quality and compliance.

Requirements

• 3-5 years of experience in ads data platform engineering
• 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

Nice To Haves

• 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
• Prior Meta Ads industry knowledge
• AI Experience

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed