Data Engineer Job at SGS Consulting, Remote

QmlVaFhMYWpJdndCT0k2aFRiVFBJYTJ6b3c9PQ==
  • SGS Consulting
  • Remote

Job Description

Job 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

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
  • Extensive hands-on knowledge of building pipelines
  • Data modeling experience
  • Strong Python coding experience

Education/Experience:

  • 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

Job Tags

Remote job

Similar Jobs

MicroTech Systems, Inc

Business Development Executive Job at MicroTech Systems, Inc

 ...addition to following up on leads from marketing activities. There may be some warm leads that come mainly from referrals, but new sales will largely come from opportunities that the Business Development Executive will uncover by researching and cold calling. The ideal... 

Marriott

Event Management Director Job at Marriott

JOB SUMMARY Functions as the strategic business leader of Event Management, including the departments of Event Planning, Banquets/Catering, Event Service and Event Technology (Destination Management, if applicable). Position oversees the development and implementation... 

Carpet City Flooring Center - Marshfield, WI

Warehouse Associate - Material Handler Job at Carpet City Flooring Center - Marshfield, WI

 ...and team members with locating materials Perform routine inventory checks and support stock accuracy Operate equipment (forklift experience a plustraining available) Were looking for someone dependable, organized, and ready to stay active throughout the day.... 

EG Workforce Solutions

Class A Gordon Food Service Delivery Driver Job Job at EG Workforce Solutions

Class A Gordon Food Service Delivery Driver JobWorking as a Delivery Driver consists of the following:Enjoy an established route, building...  ...- likely 12-14 drops per dayGet a workout with loads of up to 350 lbs on a two-wheelerConnect with the customer to be sure... 

RAM Partners, LLC

Assistant Property Manager Job at RAM Partners, LLC

 ...RAM Partners, LLC, is a full-service real estate management company that manages more than 80,000 apartments...  ...Overview Have experience in multi-family property management? The Tomlin is looking for an Assistant Property Manager with financial experience. Making...