HN Jobs

Contact Jordan@scopely.com for more info! Los Angeles VISA, FULL TIME SCOPELY (www.scopely.com) Title: Lead/Sr. Data Wizard/Engineer/Master/Munger Cloud hosting, external API consumption, data ingestion and batch processing services like Hadoop are your focus if this is the right position for you. What will you do? Build an A/B testing service to help project revenue outcomes of potential games Automate the import of data from a variety of sources (ad providers, for example) into a singular data source. (Technical: RESTful API, AWS, Command Line Code) Aggregate, normalize and process data and work with Product Managers in an effort to gain perspective on user behavior and monetization strategy. (Technical: Python, RedShift, MySQL, Hadoop) Produce automated high-level reports, dashboards and visualizations for many teams at Scopely including Revenue Operations and Product Management. (Technical: Pandas/Python ---> Tableau, d3) Create the infrastructure to drive an ad-mediation service for determining optimal ad-selection for certain users via application of intelligent algorithms (Technical: Green field) What do you need? Batch processing service experience via Hadoop or similar proprietary variants (Voldermort, etc.) Python or Perl or Shell Scripting programming experience (OO) SQL Mastery. Inner and outer joins, windowing functions, you should know it all. Experience with third-party API integration. AWS or similar experience. Big plusses for S3/Redshift experience. Experience in large throughput environments. Stats, for perspective: Daily data ingestion rate: ~100 GB per day SQS: approx. 35 million messages per day Number of rows in the largest table > 4 Billion Size of the largest table = ~ 1TB Total row count in our Data Warehouse > 35 Billion Total size of our data warehouse > 9TB 1.2B API requests per week - all generating analytics events.