A highly data-driven company and we strongly believe in using analytics to understand how users use our product, and how to prioritize and strategize changes. With over 100 million users (and 2 million new users a month), we collect over a billion events a day. That’s a huge 1 terabyte of data added daily! Our Business Analysis Group is made up of 50+ business analysts and data scientists who use cutting-edge technology to process, store and query our data, including tools we develop ourselves and ones we integrate with like Hadoop and Presto.
A BI Developer with 2+ years designing and implementing BI solutions, preferably in a consumer web company. You also have 2+ years experience implementing Big Data solutions processing unstructured and structured data into columnstore DBs, along with 2+ years implementing data processing systems (ETL). Your SQL skills are strong, which means you’re able to write complex queries and optimize them for performance. Also strong are your Dimensional Modeling skills, plus you’re familiar with Data Warehouse concepts and are fluent in English. Bonus points if you have experience with Hadoop ecosystem (Hive, PIG, Presto, SPARK, SQOOP), Columnstore DBs (Redshift, Vertica), Python, SCALA, MS SQL Server, Tableau and/or Amazon solutions.
• Work with business analysts to understand business priorities and translate requirements to data models.
• Design, implement and support robust, scalable solutions to enhance business analysis capabilities, identify gaps and design processes to fill them.
• Collaborate with a broad forum of experts and stakeholders, including architects and engineers, to create high-quality deliverables.
• Be a technical lead and set querying methodology across the analyst guild.