OP ยท 1 day ago
Data Engineer III
OP is a technology consulting and solutions company that helps clients harness the power of technology for maximum impact. They are seeking a skilled Data Engineer III to develop and maintain data pipelines, support revenue metrics reporting, and ensure data quality within their Ads Common Data Platform.
EnterpriseInformation ServicesInformation Technology
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
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
Qualification
Required
3-5 years of experience in ad data platform engineering
SQL/Presto query optimization
data pipeline development
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
Preferred
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
Company
OP
OP is one of the fastest-growing technology consulting and solutions companies in the U.S.
H1B Sponsorship
OP has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (8)
2024 (5)
2023 (1)
2022 (8)
2021 (6)
2020 (11)
Funding
Current Stage
Growth StageCompany data provided by crunchbase