Once a Pollen Experience is reserved and paid for, we need to make it happen! The first critical part of this is fulfilment, which involves shipping people their access passes, putting people in the rooms they’ll love, close to the people they love travelling with, providing essential information to both people travelling and the vendors (e.g. rooming lists for hotels, ski/snowboard boot rental, dietary requirements for brunch vendors). These are information heavy workflows, and we need an analytics engineer to help build the reporting products that form a critical part of this workflow.
What you’ll do in the next 6 months
- Clearly establish and articulate fulfillment information needs: Shadow the fulfilment team and work with the product manager to clearly define the information requirements for current Fulfillment workflows, ultimately converting them into data & reporting specifications. Success will be measured by the number of fulfilment workflows that have clearly documented information requirements (e.g. data specifications, data user journeys if applicable)
- Build reporting products for the 5 most critical fulfilment workflows: Work with the product manager and back end engineers to build the reports and that enables Fulfilment teams to execute without direct support of a data professional. Success will be measured by the number of ad hoc fulfilment information requests needed while executing those 5 critical workflows (fewer the better, ideally 0!)
- Join the team as the go-to-person for ad hoc data needs: Integrate into the Fulfilment team’s rhythms and help to satisfy their data needs as they execute to prepare everything our Members and Vendors need to enjoy their experience!
- Synthesis ad hoc requests and additional capture and scope new fulfilment needs before addressing them: Reduce ad hoc requests over time and become the goalie of all information new requests in #Fulfilment slack channel and team rhythms, creating tickets for work, clarifying the need, adding to existing workflow documents and developing or iterating on the reports to satisfy the needs. Success will be measured by the low volume of ad hoc needs and the number of executional tasks that can be performed by fulfilment team without your direct support.
- Build all operational reports needed into Retool: Build the reports into retool and work with Engineering teams to make them available in our internal Django product environment. Success will be measured by the % of information requests that can be satisfied in that Product environment (ie. without further work in Excel or Looker)
What you’ll need to be successful
- SQL: Extremely high level of SQL wizardry, capable of developing and performance optimising queries from complex snowflake-type schemas. Comfortable producing views and materialised tables in various SQL-based environments (e.g. analytical environments such as Snowflake, BigQuery, Redshift and operational data environments such as postgres)
- Github: Lives by the PR/merge request. Sets the standard for forking branches, using version control, pushes early and often and prunes at the end of each sprint. Capable of committing code to a production environment.
- Scoping information needs: Able to autonomously work across with stakeholders to understand their workflow specific information needs and convert them into data and reporting specifications
- Solution Design: Able to design interactive reports that facilitate scoped workflows above e.g. by knowing when to use a filter vs an interaction.
- BI Tooling: Experience working in a variety of BI environments (e.g. Looker, Tableau, Power BI) and at least some exposure to developing reports in a production application environment (e.g. using Retool, or an embedded looker/tableau capability)
- Organizational skills: Ability to self organise around delivering to pre specified objectives and major milestones (e.g. by doing own story and task-level sprint planning)
Team skills: Experience working in a cross functional team and communicating with non-technical stakeholders
About our culture
- We are results focused so you can choose your own hours & take as much vacation as you need to drive results and perform at your best. Watch our CEO talk about our innovative culture.
- Read our CEO’s open letter about our focus on Belonging, and about the mission of our women’s programme Illuminate.
- Everyone is an equity owner in the company.
Find out more about our culture and life at Pollen on Instagram.
Pollen builds, curates, and delivers the best travel experiences using technology, a network of global partners, and a data-driven customer-led mindset – pairing world class entertainment with the world’s most exciting destinations.
Pollen brings you all the best experiences on pollen.co. We have two offerings: Pollen Presents and Pollen+. Pollen Presents curates experiences around your tastes and preferences you can’t find anywhere else. These experiences bring together music, sports, wellness and beyond to enable you and your friends to connect around one-of-a-kind itineraries in exciting destinations. Pollen+ always gets you more at music festivals and events when you book through us. Pollen+ partners with the biggest promoter brands and music festivals, including We Are FSTVL, Austin City Limits, Bonnaroo, C3, Electric Zoo, Live Nation and more.
Pollen was founded in 2014 by brothers Callum & Liam Negus-Fancey. Pollen is backed by prominent investors including Kindred, Northzone, Sienna Capital, Backed and Draper Spirit. Pollen has raised over $100 million in VC funding.
When you apply to a job on this site, the personal data contained in your application will be collected by Streetteam Software Limited t/a Pollen (“Controller”), which is located at 3 Loughborough Street, Vauxhall, London, SE11 5RB and can be contacted by emailing firstname.lastname@example.org. Controller’s privacy officer is Stephanie Ng-Fragner, who can be contacted at email@example.com. Your personal data will be processed for the purposes of managing Controller’s recruitment related activities, which include setting up and conducting interviews and tests for applicants, evaluating and assessing the results thereto, and as is otherwise needed in the recruitment and hiring processes. Such processing is legally permissible under Art. 6(1)(f) of Regulation (EU) 2016/679 (General Data Protection Regulation) as necessary for the purposes of the legitimate interests pursued by the Controller, which are the solicitation, evaluation, and selection of applicants for employment.
Your personal data will be shared with Greenhouse Software, Inc., a cloud services provider located in the United States of America and engaged by Controller to help manage its recruitment and hiring process on Controller’s behalf. Accordingly, if you are located outside of the United States, your personal data will be transferred to the United States once you submit it through this site. Because the European Union Commission has determined that United States data privacy laws do not ensure an adequate level of protection for personal data collected from EU data subjects, the transfer will be subject to appropriate additional safeguards under either the standard contractual clauses or the Privacy Shield. You can obtain a copy of the standard contractual clauses by contacting us at firstname.lastname@example.org.
Your personal data will be retained by Controller as long as Controller determines it is necessary to evaluate your application for employment. In the event that you are unsuccessful during the recruitment process, your personal data will still be retained by Controller for up to a year for the purposes of assessing your application for future vacancies. Under the GDPR, you have the right to request access to your personal data, to request that your personal data be rectified or erased, and to request that processing of your personal data be restricted. You also have the right to data portability. Please notify us if you would like your personal data erased. In addition, you may lodge a complaint with an EU supervisory authority, including the Information Commissioner’s Office, the UK regulator for data protection issues (www.ico.org.uk).