Data Engineer

New York, United States Full-time

About US

ERGO is a marketing technology company that drives the relevance of what’s inside an email with Smart Content. The best way to understand what we do is to imagine that you’re reading your favorite magazine, and with every page you turn, the magazine learns to anticipate your needs and interests and adapts with relevant content.

Our platform leverages big data to drive our Smart Content modules in digital channels. We use our technology platform and professional-services offering to help grow Fortune 1000 brands.

Please apply with your resume and a thoughtful cover letter telling us why you're the best fit for the job.

 

About the Role

The Data Engineer is responsible for developing, maintaining, testing and evaluating data solutions systems in order to load, transform and query large data sets from a variety of sources.

  • Design, develop and optimize database queries
  • Work with our Data Scientists to create data-driven insights and reports for senior management
  • Assist Data Scientists in developing processes to migrate data from various formats and data sources (Oracle, MySQL, Sybase, flat files, etc.) to database architecture
  • Design and implement tools to analyze very large data set of raw data
  • Process unstructured data into a form suitable for analysis
  • Perform ad hoc data updates and other follow-on data services
  • Automate recurring analytics reports for clients

 

What the Role Requires

  • Bachelor’s degree or higher in Computer Science, Information Systems or related field
  • Highly proficient in SQL (MySQL, Postgres)
  • Expertise with relational databases (implementation, queries, modeling)
  • Working knowledge of distributed data stores (Cassandra, Redshift, Hadoop, HBase)
  • Proficient in scripting language of choice (Python, R, PHP, Ruby)
  • Expertise with optimizing query performance
  • Familiarity with NoSQL technologies (Mongo DB, DynamoDB)
  • Deep understanding of data structures and schema design
  • Detail-oriented, proactive problem solving skills

 

Perks

  • Choice of Blink Gym or Citibike membership
  • Bagel Mondays
  • Working From Home Fridays
  • Total of 23 PTO package that includes things like: company shut down between Christmas and New Years, three 4-day weekends on the summer holidays, and a 4-day Thanksgiving break. This also includes 10 PTO days to use at your convenience.
  • Office bar cart, daily produce, healthy and unhealthy snacks, Nespresso
  • Pool table
  • Health, vision & dental benefits
  • 401k plan with matching
  • Pet-friendly office
  • Referral bonus program
  • A comprehensive career development program and training
  • Fun company outings and events
  • Very cool industrial-style West Village studio space

 

The best perk? Our people. If you’re ready to join us, apply now!