See more DevOps & Sysadmin jobs →

← Back to all jobs

Data Architect

Posted Apr 27

Headquarters: New York, NY

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)

Help us maintain the quality of jobs posted on We Work Remotely. Let us know if this job isn’t really remote.

Apply for this position

Interested candidates should follow the below link to apply: We regret that we are unable to respond to each resume. Only those individuals selected for interviews will be contacted. CafeMedia is an equal opportunity employer.