Data Engineer - Advertising Data Pipelines

itD is seeking a Data Engineer to design, build, and maintain scalable advertising data pipelines that power revenue reporting, analytics, and decision-making across monetization platforms. This role contributes directly to data reliability, performance, and insight generation by delivering high-quality datasets that support advertising efficiency and business growth. The ideal candidate brings deep experience in ads data platform engineering, data pipeline development, and revenue metrics analysis, with a proven ability to deliver reliable, production-grade data solutions.

Location: Remote (U.S.-based; Pacific Time collaboration preferred)

We provide comprehensive medical benefits, a 401(k) plan, paid holidays, and more. Please note that we are only considering direct W2 candidates at this time, as we are unable to offer sponsorship.

Responsibilities

• Develop, maintain, and optimize large-scale advertising data pipelines and warehouse tables supporting monetization and reporting use cases.
• Build and author scalable, high-performance ETL/ELT pipelines with strict SLA requirements.
• Support revenue metrics reporting, KPI development, and opportunity score calculations used for advertising insights.
• Perform data quality validation, troubleshoot pipeline and data issues, and conduct root cause analysis to ensure data integrity.
• Provide technical guidance on data source selection, data modeling, and SQL/Presto query optimization.
• Assist with data governance, privacy compliance, and Tier-0 certification processes for critical data assets (tables, pipelines, dashboards).
• Collaborate with cross-functional teams including product, sales, analytics, and engineering to deliver actionable, high-quality data and support ad hoc data requests.
  
  

Internal Responsibilities

• Attend regular internal practice community meetings.
• Collaborate with your itD practice team on industry thought leadership.
• Complete client case studies and learning material (blogs, media material).
• Build out material to contribute to the Digital Transformation practice.
• Attend internal itD networking events (in person and virtual).
• Work with leadership on career fast-track opportunities.
  
  

Required Qualifications And Skills

• 3–5 years of experience in data engineering, with a focus on advertising, monetization, or revenue-focused data platforms.
• Advanced SQL expertise with deep experience using Presto for large-scale data analysis and pipeline development.
• Proven experience designing and building scalable ETL/ELT pipelines and data warehouses.
• Strong data modeling experience supporting analytical and reporting use cases.
• Strong Python coding experience for data processing, pipeline development, and automation.
• Extensive experience with KPI and revenue metrics reporting, including metric design, analysis, and visualization.
• Demonstrated expertise in data quality management, troubleshooting, and root cause analysis.
• Solid understanding of advertising data models, campaign structures, and ads reporting requirements.
• Excellent written and verbal communication skills for technical documentation and stakeholder collaboration.
  
  

Preferred Qualifications And Skills

• Experience with Hive tables and data warehouse optimization.
• Knowledge of data governance, privacy compliance, and permission management frameworks.
• Experience supporting Tier-0 or highly critical data assets with strict SLAs.
• Ability to work effectively with cross-functional teams including sales, product, and analytics.
• Prior experience in large-scale advertising or monetization platforms.
• Exposure to AI-driven analytics or advanced data use cases.
  
  

Education

• Bachelor’s degree in a relevant field or equivalent work experience required.
  
  

Company Description

About itD: We are part of a new generation of consulting and software development company that blends diversity, innovation, and integrity with real business results. Our structure rejects any strong hierarchy, empowering us to deliver excellent results. We are a woman- and minority-led firm. Every day, we challenge ourselves to be considerate, fair and to re-think what great outcomes mean for our customers. This permeates down to how we approach every interaction, on every project, for every client. You’ll thrive here if you are a dynamic self-starter, a difference-maker or someone who wants to deliver great results, without constraints.

The itD Digital Experience: Joining us means you’ll be part of our global community, you have a say about your own career journey, and you’ll get a chance to give back to causes that matter. You will experience working with Fortune 500 companies and high-performance teams across numerous industries. itD offers our employees excellent benefits such as medical, dental, vision, life insurance, paid holidays, 401K + matching, networking & career learning and development programs. We are growing and we want to see you grow! Visit https://itdtech.com/careers to learn more about what working at itD can mean for you.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. itD is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or to perform the essential functions of a position, please contact us at recruiting@itdtech.com and let us know the nature of your request and your contact information.

Additional Info

Dynamic environment in a culture of respect, empowerment and recognition for a job well done, apply today!