Data Management & Reporting Analyst
Bevi is a Series C startup that has raised over $60 million to bring customizable, healthy hydration to offices and facilities across the US and Canada. Founded in 2013, our co-founders set out to out-design bottled water. Within five years time, Bevi has saved the waste generated by over 50 million plastic bottles and seen revenue grow by 10x over the past 2 years! With offices now in Boston, New York, and San Francisco, we continue to grow our healthy flavor offerings and constantly strive to bring the next level of customization to the Bevi hydration experience.
We are seeking a Business Data Management & Reporting Analyst to help define and stabilize the data model for the company’s wealth of data. This is a key position reporting directly to the Director of Enterprise Applications, working to define Bevi’s organizational data management practices and centralized reporting strategy. This role will be responsible for driving Bevi’s Business Intelligence tool development and taking ownership of the organizational data model, positioning the company for rapid scalability and enabling data-driven decisions across all business units.
What you will do:
- Utilize Business Intelligence tool (Looker) to build reports and dashboards to monitor end-to-end business operations, including Sales, Order Management, Customer Support, Supply Chain, and Product Performance
- Work with leadership team to clearly define and document reporting requirements and KPI’s to enable data-driven decisions
- Manage data connections using Fivetran to multiple business systems (Zendesk, Salesforce, Handshake, NetSuite) and monitor data quality, accuracy, and consistency
- Develop and maintain a data model across all systems within Data Warehouse (Snowflake) to be considered central source of data for all business reporting needs
- Ensure that data model and collection methodologies are consistent with business process changes; contribute to development of organization-wide change management processes
- Contribute to creation of table schema and dimensional models that can support measures and variables necessary for downstream analysis
- Write SQL queries to manipulate data and power reports spanning across multiple data sets and dimensions
- Create and maintain a data dictionary within Looker for all data attributes, dimensions, and metrics to provide clear definitions of data sources and meanings to end users
- Construct, communicate, and execute an organization-wide data cleansing action plan
- Contribute to ongoing NetSuite implementation, preparing data and managing migration activities for item, inventory, order, financial and master data
- Simplify and automate data extraction, transformation, and load activities for multiple data sources
- Develop training materials and educate general business users on how to leverage BI to improve their day-to-day efficiency
How you will grow:
- Engage with talented and growing Enterprise Applications and Leadership teams drawn from diverse sectors, and mentor and coach junior team members in their career journeys
- Learn cross-functionally from Supply Chain, Sales, Marketing, Finance, and Order Management teams, and work at the heart of a start-up in high-growth mode
- Deploy your energy and expertise to further the company's mission of sustainability, wellness, and positive personal and environmental change
- Gain valuable, hands-on experience with cutting edge data management and business intelligence platforms
Requirements
We think you will bring:
- A Bachelor’s degree in computer science or related field
- 2+ years of relevant experience and proven track record of success in data management and leading reporting and business insight initiatives
- A high-level of emotional intelligence, and an ability to work with and influence a diverse set of internal stakeholders within fast moving start-up culture
- Possess an expert level knowledge of SQL
- Experience with modern BI tools (Looker, Tableau, Domo, Qlik, etc.)
- Experience with Looker and LookML a plus
- Strong data visualization skills; adept at displaying complex quantitative information in a clean and intuitive format to business users
- An ability to understand business process and requirements and translate them into actionable and reportable metrics
- An ability to cleanse and link complicated and disparate data sets from multiple sources.
- Have experience with Zendesk, Salesforce, and / or NetSuite a plus
- Effective verbal and written communication skills
Benefits
Apply to learn more about what makes Bevi a great place to work and grow!