Data Engineer

Location: San Mateo, CA

Type: Contracted

Min. Experience: Mid Level

FocusKPI, Inc. is looking for a Data Engineer to work for our client in San Mateo, CA. This is a full-time contract position.


Key Objective 

  • Gather Yield Data Foundation requirements from pricing, packaging, forecasting initiatives
  • Perform data analysis and data profiling on existing data sources
  • Build a Yield datamart and establishing the source of truth for WMG Display advertising KPIs using DFP log files, DFP API extractions and other sources
  • Maintain and improve existing datamarts on Sponsored Products including pipeline, mapping and business logic changes
  • Create a Data Quality framework for Yield metrics
  • Assist in data migration to Google Cloud Platform
  • Build dashboards on Tableau to conduct scalable data analyses and insightful visualizations to share insights


Skill Requirements

  • 2+ years' experience with Python
  • 2+ years' experience with SQL and relational databases (for example Hive, DB2, Oracle, SQL Server) 
  • Experience with data visualization tools such as Tableau, Looker and Domo
  • Experience in data engineering and building data pipelines using Python
  • Experience in a distributed computing environment such as GCP or Hadoop
  • Experience with workflows such as Oozie or Airflow



Thank you for applying!

FocusKPI Hiring Team 

About FocusKPI:   
FocusKPI Inc. is an analytics consulting business providing solutions such as CRM customization, Risk Management, Business Intelligence, Advanced/Operational/Web/Digital Analytics as well as Human Resources for our clients.

Apply for this Position
* Required fields
First name*
Last name*
Email address*
Phone number*

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

How many years of Related Work Experience*
Human Check*