Data Engineer III

Join us! We are looking for a talented Data Engineer with 3-5 years of experience in ad data platform engineering, specializing in SQL/Presto query optimization, data pipeline development, revenue metrics analysis, and data quality management. Play a key role in delivering innovative data solutions that drive strategic growth and actionable insights. 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 with 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. Benefits • 401(k). • Dental Insurance. • Health insurance. • Vision insurance. • We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people. • The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs. Additional Responsibilities • Participate in OP monthly team meetings and participate in team-building efforts. • Contribute to OP technical discussions, peer reviews, etc. • Contribute content and collaborate via the OP-Wiki/Knowledge Base. • Provide status reports to OP Account Management as requested. About Us At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we’ve been challenging the status quo of the consulting industry serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.