Position: Middle Data Warehouse Engineer for Just Eat Takeaway
Company: Ciklum
Category: Data Science
Experience required: 3y
English level: upper
Published: 2021-06-01T00:00:00+03:00

Responsibilities:

- Develop/maintain the data warehouse applying the industry’s best practices
- Apply known “best practice” / “lessons learned” knowledge to create reliable, multiple times a day or continuously running agents, possibly aware of model changes and other possible occurring issues
- Collaborate excellently with the team and stakeholders in agile iterative processes


Requirements:
- 3 + year in data integration / ETL projects
- Strong experience with Kimball modelling approach
- Experience with parsing structured and unstructured data and creation of ETL pipelines for data warehousing
- Understanding DWH and Data Lake architecture
- Advanced SQL and relational databases including queries, database definition and schema design
- Experience with Python (general knowledge is enough)
- Experience with database performance optimization
- Knowledge about how to model data and processes, how to test data, how to implement proper logging, and how to troubleshoot issues swiftly
- Experience with MPP databases like Redshift/Greenplum/Teradata/Snowflake etc or with DBMS like Postgres/Oracle/MySQL with a BI and/or analytics focus
- Knowledge of data warehouse modelling methodologies such as dimensional modelling, data vault


What's in it for you:

- We’ll believe and trust in you and your abilities. So you and your team will have the authority to make the technical decisions you need to meet your responsibilities to the rest of the platform and company
- An environment in which good, evidence-based arguments are always listened to, and will win out
- Regular 1-to-1 meetings with your manager, with support and guidance to set and then meet personal career objectives
- An open, friendly and fun environment; we have a relaxed dress code and regular social events
- Regular hackathons – use your imagination, ideas and technologies of your choice to innovate and deliver prototypes of new products
- Social benefits
- Educational opportunities