Staff BI Engineer (AWS) - Artificial Intelligence - Req: 1370

Would you like to make innovation happen? Have you ever dreamed of building Products and Platforms for thousands of employees and having a direct impact on millions of users? Nice! Then we have a seat for you on our team, we are a people-first consumer platform that allows people to voluntarily share information about their visits and experiences at the brand locations they interact with every day. In exchange for their perspective, participants receive cash rewards in the form of digital gift cards.

We are more than 400 Truepers all around the world working remotely. We’re a collective of like-minded techies who love taking on projects together that go beyond the workspace. We believe that true innovation is born out of true collaboration.

What are you going to do?

1. Media Studio Audience Segment Builder - this would be a UI that could enable marketers to build a query based on a number of data elements in our DB and the UI would return results for the Marketer in either .xls, .csv

2. Media Studio Standard Reporting API - we would like to aggregate campaign reporting from a variety of publishers who execute our campaigns from DSPs.

3. Integration with Media Mix Modeling Software - The targeted consumer segments would be automatically uploaded to a DSP and simultaneously we will want to feed a media planning tool to optimize our media plan for delivery.

Your responsibilities

• Build a reporting layer on top of several data providers like AWS Redshift, *Redshift Spectrum, Athena or Apollo.
• Research, design and recommend the best tool to create the solution.
• Understand the business needs in order to create heatmap, time series and other reports on top of existing data
• Work with the business and the technology team to create guardrails on the available data

Why do we need your skills?

• Experience creating reports on top of several data sources using Amazon *QuickSight, Tableau, Microsoft PowerBI, or other business intelligence tools.
• Ability to talk to the business and help designing reports.
• Experience working with data out of AWS Redshift.
• Experience implementing a BI reporting solution from scratch.
• Should be comfortable working on a AWS environment.
• Experience with data visualization tools (e.g. Tableau)
• Integrating such tools in the rendering of selected reports