Analytics Engineer
Provi is innovating the 240-billion dollar alcohol industry—do you want to be part of something game-changing? We were a hungry team in 2016 when we started and we’re still a hungry team, living our values—Host, Serve, Deliver and Celebrate—every day. We make sure that as the company grows, our people grow too and we’d love to have you on board.
Frequently cited statistics show that women and underrepresented groups apply to jobs only if they meet 100% of the qualifications. But guess what? No one ever meets 100% of the qualifications. Trust your experience and apply!
Provi is looking for a Senior Analytics Engineer that will provide leadership in building the business-facing side of our data warehouse. If you are excited about transforming raw data into clean, easy-to-use tables that are ready for analysis, this is the role for you. You will be part of Provi’s Analytics team and empowered to make key decisions in how our data warehouse is architected.
What you’ll be doing
- Design, build, and maintain the analytics tables in our Snowflake data warehouse
- Collaborate with analysts and other business users to understand the business questions for which they need answers
- Collaborate with software engineers to understand our data sources and changes in those data sources
- Be a steward for our data by developing data documentation and ensuring data quality
What we’re looking for
- Bachelor’s Degree in Analytics, Engineering, Statistics or related field
- 3+ years of experience in a data engineering or analytics engineering role
- Expertise in translating business requirements into database schemas
- Expertise in designing well performing database tables, both aggregated and granular
- Experience with cloud data warehouses and their best practices (Snowflake experience preferred)Ability to communicate and collaborate effectively across teams
- Experience working with semi-structured data types such as JSON and XML
- Expert in SQL, including writing complex queries, stored procedures, query optimization and data compression
- Experience with Github or other version control tools
- Experience with DBT (Data Build Tool) preferred
- Previous experience in high growth startups is a plus
- Prior experience in marketplace business is a plus.
What you can do at Provi:
Make an impact: Work directly with the management team to help grow the business.
Find your groove and grow: Provi keeps growing and you should too. Expand your skill set, diversify your experience and develop along with us.
Enjoy competitive benefits: Health, Dental, Vision, 401K, Commuter Perks, Long/Short Term Disability, Employee Assistance Program, Generous PTO and ½ day Fridays in the Summer.
Energize at work: We are remote now, but when we can safely return you will work out of our amazing office in River North, enjoying snacks, drinks, happy hours and more!
Be a part of something big: Join a dynamic and innovative team that is working to change a major industry.
Provi is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.
#BI-Remote