About the Role:
As a Senior Analytics Engineer, you will build systems that can model data in a clean, clear way. These systems consolidate multiple data sources and enable both internal and external stakeholders to answer questions on an ongoing basis. You may be working on a small, cross-functional team that may include other engineers, a product manager, data scientist and other roles. Success in this role requires the ability to take on ambiguous, complex problems and design & develop innovative solutions.
In this role, you will build the tools which will allow some of the largest brands in the world to better understand their customers and reimagine the shopping experience. Join us in transforming the way that brands reach their customers and empowering consumers to Live Rewarded through the power of Fetch Points!
This is a full-time role that can be held from one of our US offices or remotely in the United States.
What you'll do at Fetch:
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
In your Toolbox (Minimum Requirements):
3+ years of professional experience in a technical role requiring advance knowledge of SQL
Understand the difference between SQL that works and SQL that performs
Experience with data modeling and orchestration tools
Experience with relational (SQL) and non-relational (NoSQL) databases
Experience with object data stores (e.g., Snowflake, MongoDB, S3, HDFS, Postgres, Redis, DynamoDB)
Understanding of ETL vs. ELT processes, data warehouses, and business intelligence tools
Experience clearly communicating about data with internal and external stakeholders from both technical and nontechnical backgrounds
Ability to thrive in a highly autonomous, matrixed organization and manage multiple, concurrent work streams
Bonus Points (Preferred Requirements):
Proclivity for building and experimenting with different tools and tech, and sharing your learnings with the broader organization
Experience developing and maintaining DBTorAirflowin production environments
Experience programmatically deploying cloud resources on AWS, Azure, or GCP
Experience implementing data quality, data governance, or disaster recovery initiatives
Proficiency in at least one imperative programming language (i.e., Python)
At Fetch, we'll give you the tools to feel healthy, happy and secure through:
Equityfor 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. 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.