Data Engineer III

American IT Systems • Redmond, WA

4d • Remote

About The Position

We are seeking a Data Engineer III with 3-5 years of experience to join our remote team, with a strong preference for candidates in the PST time zone. This role focuses on ads data platform engineering, SQL/Presto query optimization, data pipeline development, revenue metrics analysis, and data quality management. You 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 query optimization, data pipeline development, revenue metrics analysis, and data quality management
• Advanced proficiency in crafting complex SQL queries
• Deep experience using Presto for large-scale data analysis and pipeline development
• Proven track record in designing and building scalable, high-performance ETL/ELT pipelines, data warehouses, and orchestrating workflows with modern tools
• Strong industry knowledge in revenue reporting and business intelligence KPI development, including metric design, analysis, and reporting
• Exceptional analytical skills for detecting data discrepancies, performing root cause analysis, and implementing robust data validation processes
• 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
• 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
• 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