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


  • 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

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

Paste your resume here or Attach resume file