SQL Developer (Remote)

| Remote | Hybrid
Sorry, this job was removed at 12:08 p.m. (CST) on Tuesday, March 29, 2022
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Who We Are:

Fetch is a build-first technology company creating a rewards program to power the world. Over the last 5 years, we’ve grown from 0 to 13M active users and taken over the rewards game in the US with our free app. The foundation has been laid. In the next 5 years we will become a global platform that completely transforms how people connect with brands. 

It all comes down to two core beliefs. First, that people deserve to be rewarded when they create value. If a third party directly benefits from an action you take or data you provide, you should be rewarded for it.

Second, we also believe brands need a better and more direct connection with what matters most to them: their customers. -- Brands need to understand what people are doing, and have a direct line to be able to do something about it. Not just advertise, but ACT.

Fetch’s next step in evolving the shopping experience will require a SQL Developer. You will build a highly performant data lake and warehouse that integrates with the tools leveraged by our Data Analytics, Data Science, and Business Intelligence teams. Success in this role requires the ability to take on challenging problems and design & develop amazing solutions using the best technology for any given use case.

The Role:

  • Model and analyze data utilizing SQL best practices for OLAP / OLTP query and database performance
  • Develop on a real-time OLAP database (Druid, and work with distributed processing engines (PrestoDb or Trino, Hive)
  • 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
  • Communicate findings clearly both verbally and in writing to a broad range of stakeholders
  • Test, monitor, and report on data health and data quality

In your tool-bag:

  • 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
  • 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
  • Love Dogs! . . . Or at least tolerate them. We're a very canine-friendly workplace!

Bonus Points:

  • 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)

We're committed to building an empowered and inclusive community of innovative and passionate people. As a growing organization, we need team players who can go above and beyond their individual responsibilities to help our company build towards its vision. If you are a creative, hard-working, and fun-seeking person interested in working with a close-knit group of highly talented people, this is the right place for you.

Fetch Rewards is an equal employment opportunity employer.

At Fetch Rewards, we'll give you the tools to feel healthy, happy and secure.

  • Stock Options
  • 401K Match - Up to 3%
  • PPO and HDHP plans | Dental | Vision | Life Insurance
  • Pet Insurance
  • Education Reimbursement
  • Unlimited PTO
  • 10 Paid Holidays + End of Year Break
  • Flexible 9 weeks of Parental Leave
  • Full time wellness coach to help meet your exercise & wellness needs
  • WFH Setup. Whatever hardware and software you need to get the job done
  • Regularly scheduled virtual events, happy hours, cooking classes, etc.

#BI-Remote

#LI-Remote

Read Full Job Description
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

Location

Fetch Rewards has offices or co-working spaces in Madison, WI (Our HQ), Chicago, Boston, New York, San Francisco (in transition). We have remote employees in 39 states, and growing!

Similar Jobs

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about FetchFind similar jobs