Business Intelligence Analyst

Who you are

• Experience writing complex queries, views and functions from scratch in PostgreSQL or SQL in a fast-paced business environment
• Demonstrable understanding of relational databases and data pipelines
• Confident interpreting data and sharing it in a relatable way
• A strong desire to learn Tableau, or existing basic experience
• Experience working with Salesforce data pipelines, Heroku and/or Databricks desirable
• Experience documenting data structures, flows and reporting
• Excellent numeracy skills and attention to detail
• Clear and concise written communication skills
• Thrives in a fast-paced environment with ever changing priorities and working with a variety of teams
• A great communicator who can naturally build rapport with a wide variety of people across all parts of the business
• Comfortable with ambiguity and able to adapt to changing business needs
• A creative problem solver with initiative
• A quick learner who thrives learning new skills
• Ability to manage multiple concurrent workstreams

What the job involves

• This role would be perfect with someone with a solid understanding of relational databases (particularly building complex views and functions in SQL or PostgreSQL ) who is ready for their next challenge building Tableau dashboards in a business facing role
• You will be hands-on developing Tableau dashboards, but developers in our team are responsible for the full data pipeline. Building the queries, views and functions in SQL is often the most complex part of this process, so we want you to have those skills already
• You’ll need to be confident building rapport with people from across the business as well as using your SQL skills to bring together the data they need to make faster, better decisions. If you have existing SQL skills, are a quick learner and understand what makes good visual design, we can teach the Tableau skills
• Gather dashboard requirements from a variety of stakeholders
• Use SQL and PostgreSQL to build the views, functions and data flows needed to bring together data for Tableau analysis
• Create and adapt Tableau dashboards across the Business Intelligence team
• Design, test and maintain insightful Tableau dashboards to provide our key stakeholders with the data they need
• Manage and improve existing dashboards across Promotions, Ticketing, Finance and more
• Create thorough documentation for all parts of the process, from database to dashboard
• Assisting Business Intelligence team with any other duties as required

Benefits

• HEALTH: Medical, Dental and Vision benefits for you and your family, including Flexible Spending Accounts (FSA) and Health Savings Accounts (HSAs)
• YOURSELF: Paid time off policy including holidays, sick time, and day off for your birthday, free concert tickets
• WEALTH: 401(k) program with company match, Stock Program Reimbursement
• FAMILY: New parent programs & support including caregiver leave and baby bonus, infertility support
• CAREER: Tuition reimbursement, student loan repayment internal growth and development programs & trainings
• OTHERS: Volunteer time off, crowdfunding network