Analytics Engineer

  • вработување
  • од дома
  • Од каде било
  • Аплицирањето е завршено

What is Slice?

Slice is the leading technology and marketing platform made exclusively for local pizzerias, making it super easy to order delicious, authentic local pizza anywhere, anytime. We serve the $45 billion U.S. pizzeria market in two ways: by providing a pizza-centric mobile and web ordering experience for consumers, and by empowering local restaurants with the technology, tools, and marketing to grow their business, while helping them compete with Big Pizza.

Yes, we have a pizza philosophy

Across the country, pizza is made by people who care about craft, history, and culture. We created Slice to champion the small pizzerias by connecting those proud makers with customers who are just as passionate about their pizza. We celebrate pizza as the ultimate shareable food that brings people together for more than just a bite.

We’re growing our team every day — so, if you’ve got a passion for local, authentic pizza and the drive to help share it with the world, we’d love to have you on the team!
You will be responsible for building and maintaining the data pipelines that are providing business insight here at slice. The role involves productionizing analytics and optimizing query performance on our chosen technologies. You’ll work closely with the data engineering team, analysts and data scientists  to provide Slice with data products that can be relied on throughout the business.

The analytics engineers will be responsible for owning the development and optimization of analytic pipelines and building out clear dashboards to allow executives to understand the impact of the analysis. You’ll ensure that data is accurate and timely to meet the needs of Slice. You’ll have the opportunity to grow this role within Slice and have input into the correct technologies to deliver this function

 

What you’ll do:

Work with delta lake in DataBricks analytical platform, extend existing delta lake by adding tables with aggregations needed for Data Science and Data Analysts team

Analyze requirements, prepare technical documentation, ER diagram, and implement them in the DWH schema by creating appropriate fact and dimension tables

Schedule DWH incremental loads in DataBricks and Airflow

Maintain and optimize existing data extraction transformation processes for calculating metrics

Be able to analyze and understand existing Python (Airflow) solution and extend according needs

Build and maintain Looker Dashboards

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery

Research technologies and build automated solutions to support daily work of Data Scientists and Data Analysts

Act as an intermediary between Data Scientists and Data Engineers and find solutions for data processing challenges

Manage, monitor, and troubleshoot the analytics and machine learning infrastructure.

Work with complex data infrastructure, data lake (AWS S3 bucket), delta lake DataBricks

Essentials:

More than 3 years work experience in DWH/DB Development/Business Intelligence/ETL

Advanced SQL development knowledge and experience working with OLTP and OLAP databases

Experience with Python in data related context

Experience with data visualization tools

Performance optimization (query tuning, indexing data, optimization practices, querying system tables and views) is
considered as very important strength

To be able to experiment with new technologies and acquire new skills to find clever solutions to the unique challenges we will encounter along the way.

To speak fluent English (our company language).

Desirable:

Experience working with Business Intelligence reporting tools/platforms

Experience working with ETL tools/platforms

Python knowledge

What we offer:

Competitive salary and full benefits.
Career advancement opportunities and working with a young, smart and motivated team.
Flexible work arrangements, because a life/work balance is important and this is the 21st century. Work how you work best!
Ability to work remotely if you can’t move and work in our offices.
Great office spaces with all amenities.
The best equipment on the market! Including a new MacBook Pro!
Health and wellbeing benefits.
Annual conference attendance and training/development budget.
Annual self-learning budget.
Pizza parties and team outings.
All the support that you need to be successful.