Data Analyst

Overview:

Wage:

$70,000 - $95,000 depending on meeting requirements

Benefits:

• 100% employer-paid medical, dental and vision for employees
• Annual review with raise option
• 22 days Paid Time Off accrued annually, and 4 holidays
  • After 3 years, PTO increases to 29 days. Employees transition to flexible time off after 5 years with the company—not accrued, not capped, take time off when you want
  • The 4 holidays are: New Year’s Day, Fourth of July, Thanksgiving, and Christmas Day
• Paid Maternity and Paternity Leave
• 4% company matching 401(k) with no vesting period
• Quarterly "Work Wherever" allowance
  • Use to make your remote work wherever set up more comfortable, for continuing education classes, a plant for your desk, coffee for your coworker, a massage for yourself... really, whatever
• Open concept office with friendly coworkers
• Creative environment where you can make a difference
• No dumb benefits like free dog walking on the weekends that snobby hipster places have to make you feel cool, but mathematically won't cost the company much money because you won't use it
• Trail Mix Bar --- oh yeah

Responsibilities:

• Effectively communicate complex information to a variety of stakeholders to help inform business decisions
• Identifies problems or needed changes, recommends resolution, and participates in quality improvement efforts
• Collaborates with the analytics team to plan and scale analytics, working to harvest and grow the data culture across the company
• Consults stakeholders in the development of KPIs, ad hoc analyses, and automated reporting to best fit their needs and act as a leader in promoting data literacy
• Builds and maintains snowflake schemas designed to improve reporting and analysis by cleaning and transforming transactional data using DBT modelling
• Supports the company with innovative efforts by using trends and predictive analyses to inform recommendations to the company
• Extracts data from relational databases using PostgreSQL to structure data for analysis and automated reporting
• Organizes and prioritizes tickets using Jira and Confluence
• Designs, builds, and maintains dashboards for the business using our business intelligence program, Metabase

Requirements:

• 2+ years of experience in an analyst role, data analyst experience preferred
• Demonstrated analytical and problem-solving skills
• Ability to communicate complicated information to a wide variety of stakeholders
• Bachelor’s (BA or BS) in business, accounting, or related field, or relevant experience
• Experience using SQL to extract data from relational databases (Postgres, MySQL, T-SQL, etc.)
• Experience extracting meaning from large data sets
• Experience building dashboards and reports using business intelligence tools (Tableau, PowerBI, Looker, Metabase etc.). Metabase experience would be a plus
• Ability to act as a consultant to help stakeholders create relevant KPIs and understand the meaning behind the data
• Self-starter who is not afraid to dive into data for exploration and discovery
• PREFERRED: Experience presenting insights to executive leadership
• PREFERRED: Experience working on ETL processes and data modeling. DBT experience is highly preferred