Description
Scope of Responsibilities:
- Model and analyze data utilizing SQL best practices for OLAP / OLTP query and database performance
- Leverage Data Build Tool (DBT), Snowflake, Airflow, AWS infrastructure, CI/CD, testing, and engineering best practices to accomplish your work
- Generate innovative approaches to datasets with millions of daily active users and terabytes of data
- Translate business requirements for near-real-time actionable insights into data models and artifacts
- Communicate findings clearly both verbally and in writing to a broad range of stakeholders
- Administrative duties for Snowflake, Tableau, and DBT/Airflow infrastructure
- Test, monitor, and report on data health and data quality
- Lead the charge on data documentation and data discovery initiatives
The ideal candidate:
- Are proficient in SQL and understand the difference between SQL that works and SQL that performs
- Have worked with data modeling and orchestration tools
- Have experience with relational (SQL), non-relational (NoSQL), and/or object data stores (e.g., Snowflake, MongoDB, S3, HDFS, Postgres, Redis, DynamoDB)
- Have a solid understanding of ETL vs. ELT processes, data warehouses, and business intelligence tools
- Have prior experience clearly communicating about data with internal and external customers
- Are highly motivated to work autonomously, with the ability to manage multiple work streams
- Interest in building and experimenting with different tools and tech, and sharing your learnings with the broader organization
- Have developed and maintained DBT or Airflow in production environments
- Have experience programmatically deploying cloud resources on AWS, Azure, or GCP
- Have successfully implemented data quality, data governance, or disaster recovery initiatives
- Are proficient in at least one imperative programming language (i.e., Python)
Compensation:
At Fetch, we offer competitive compensation packages to the exceptional folks we hire. The base salary range for this position is $120,000 - 130,000.
At Fetch, we'll give you the tools to feel healthy, happy and secure through:
- Equity for everyone
- 401k Match: Dollar-for-dollar match up to 4%.
- Benefits for humans and pets: We offer comprehensive medical, dental and vision plans for everyone including your pets.
- Continuing Education: Fetch provides ten thousand per year in education reimbursement.
- Employee Resource Groups: Take part in employee-led groups that are centered around fostering a diverse and inclusive workplace through events, dialogue and advocacy. The ERGs participate in our Inclusion Council with members of executive leadership.
- Paid Time Off: On top of our flexible PTO, Fetch observes 9 paid holidays, including Juneteenth and Indigenous People’s Day, as well as our year-end week-long break.
- Robust Leave Policies: 20 weeks of paid parental leave for primary caregivers, 14 weeks for secondary caregivers, and a flexible return to work schedule.
- Calvin Care Cash: Employees who are welcoming new family members will also receive a one time $2,000 incentive to assist employees with covering the cost of childcare, clothing, diapers and much more!
- Hybrid Work Environment: Collaborate with your team in one of our stunning offices in Madison, Birmingham, or Chicago. Or you can work fully remotely from anywhere in the US. We’ll ensure you are equally equipped with the hardware and software you need to get your job done in the comfort of your home.