View Our Website View All Jobs

Data Architect

CafeMedia is looking for a seasoned and multi-talented data architect to help us create our overarching enterprise data architecture, build and manage the build-out of the underlying databases, implement tools and technologies to serve business users, specify and build ETL processes, and implement go-forward best practices for managing our database as we grow.

CafeMedia is enormous and has enormous cool data sets that YOU want to mess with!

We have multiple large-scale and/or complex data sets that live independently that need to be holistically unified. The data sets include:

  • Customer database
  • DFP
  • Ad Exchanges
  • Google Analytics
  • Custom Tracking Pixels
  • CMSs
  • Scraped data from a variety of third party platforms, APIs, scripts and data files

Job responsibilities:

  • This is a mix of big-picture strategy (25%) and very “in the weeds” execution work (75%) – talking with the CEO and writing SQL
  • Full ownership of the process from end-to-end and significant autonomy to make the best decisions for the company
  • Interviewing business stakeholders across the company to understand all needs
  • Investigating all data sources to understand formats, structure, quality, etc
  • Proposing and selling-in the overarching data structure – and implementing that structure
  • Writing requirements and specifications around the ETL and aggregation processes – and creating those processes
  • Setting best practices for the ingestion of new data and managing go-forward operations
  • Recommending and implementing user tools
  • Opportunity to choose platforms, tools and technologies across the entire project – but we’re heavily biased to open source technologies and the Amazon Cloud for the underlying systems

Requirements:

  • 10+ years of experience in data architecture/modeling
  • Background in digital content/digital advertising a significant benefit
  • Self-starter
  • Excellent communicator
  • Great dancer (just kidding)
  • Great karaoke performer (not kidding)

 

 

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file