Data Engineer
Department: Tech
Employment Type: Full Time
Location: Brighton
Reporting To: Damir Becarevic
Compensation: £40,000 - £55,000 / year
Description
* Who we’re looking for: Someone who understands the methodology and fundamentals rather than specific tools. You’ll be ideal for this role if you have a demonstrable passion for automation and collaboration.
* The challenge: you will be responsible for implementation of database clusters, tables, schemas, indexes, and ETL pipelines. This also includes database and query performance tuning.
* Where you’ll work: This role will be based in our Hove office 2 days a week.
Day to day this role will
* Building and maintaining database schemas and tables.
* Building and maintaining ETL pipelines.
* Query and index performance tuning.
* Database backup/recovery, monitoring and alerting.
* Working in an agile way following DevOps principles.
* Helping developers with database related queries.
* Advising data and software engineers on best practices.
Who we’re looking for
* Experience with relational databases (MySQL, PostgreSQL, SQL Server, Oracle, or similar).
* Exposure to no-SQL data stores (ElasticSearch, Redis, DynamoDB, Cassandra, Presto, MongoDB, or similar).
* Experience in working with ETL tools (preferably dbt).
* Working knowledge of Git, or other source version control system.
* Good knowledge of SQL.
* Knowledge of Python and development best practices.
* Experience with a Cloud Provider such as AWS, GCP, or Azure.
* Knowledge of Linux and Bash.
* Strong sense of collaboration and experience working with development teams.
It’s not essential, but we’d love to hear about it if you have experience with:
* Experience with building and deploying containers in Docker.
* Experience deploying and operating applications on Kubernetes.
* Knowledge of Python-based data science tools (Pandas, NumPy, Matplotlib).
* Exposure to MPP and columnar relational databases (Redshift, Snowflake, BigQuery, Vertica, Greenplum, or similar), or data lake platforms such as Databricks.
* Exposure to business intelligence and analytics tools such as Tableau, Power BI, Looker, or QuickSight.
* Experience of instruction, and mentoring for the training of peers.
* Knowledge of CI/CD processes.
Benefits
We offer all our employees trust and empower our team to work with flexibility and autonomy. We’re a close-knit team and love working collaboratively, with our hybrid model, our team can come together at our fantastic office in Hove, but also focus in their own space. The Tillo team are a motivated bunch and we all work hard to push Tillo forwards, always innovating. We completely understand the importance of work/life balance and offer a supportive and collaborative working environment with the following benefits:
* Enhanced annual leave of 26 days per annum.
* Private Medical care through Vitality.
* Designated share options.
* Access to Tillo’s Storefront with discounts & gift card vouchers.
* Hybrid Working.
* Top spec equipment including laptop, mouse, keyboard, monitor.
* Anniversary gifts.
* Monthly breakfasts, drinks, snacks and events.
* Individual Learning & Development budget.
#J-18808-Ljbffr