Responsibilities
● Build and enhance SQL tables, metrics, reports, and dashboards that help us actionably understand the health of our business
● Monitor and maintain report data quality, stability, reliability over time
● Conduct analyses for improvement opportunities in business areas not actively monitored by business stakeholders; partner with business stakeholders to do so in other areas
● Ensure stakeholder understanding of data deliverables and value
● Work closely with data engineering/modeling in describing business needs for data warehouse ingests, schema, models, etc from multiple raw data sources
Technologies
● Mode Analytics (SQL, Liquid, python, R)
● DBT (data built tool) (Git/Github, Travis CI, SQL, python, js)
● Snowflake Data Warehouse
● Ingests from internal operational tools, customer facing website/mobile app, and third party systems for employee management, customer service, marketing automation, warehouse management, etc via custom ingest, Fivetran, Segment.
Requirements
● 4+ years professional experience performing data analysis against multiple data sources
● Some experience in food, retail finance, transportation, and/or supply chain & logistics
● A track record of building useful data tools with demonstrable business results
● Ability to work with ambiguous direction, i.e. self-direct, optimize, and prioritize work for long-term vs short-term needs, speed, flexibility, scale, impact per resource cost, etc
● Understanding for business stakeholders across various layers of seniority, technical/analytical abilities, and business domains (digital, supply chain/logistics, food, finance)
● Familiarity with modern data warehousing, manipulation, and visualization tools and workflows (ideally platforms in our data stack) or ability to quickly gain facility with the relevant tools/languages
● Interest and belief in our mission of good food being the most powerful force for change!
Any Graduate