Position: Data Warehouse Specialist
Company: K&C
Category: Data Engineer
Experience required: 5y
English level: fluent
Published: 2023-07-01T00:00:00+03:00

**Project Overview:**
We are in the early stages of developing a new data warehouse which will aggregate data from multiple operational databases. This project requires a skilled and experienced data warehouse specialist to help us in the design, development, and implementation stages.

**Responsibilities:**
1. Collaborate closely with the internal team to understand project requirements and objectives.
2. Design, build, and deploy a robust data warehouse solution using Google BigQuery.
3. Oversee the extraction, transformation, loading (ETL) of data from various operational databases into the new data warehouse.
4. Design and implement data modeling techniques to ensure the warehouse can efficiently support the required BI reports and dashboards.
5. Develop and implement data warehouse architectural strategies to handle large scale data, optimize performance, and ensure data security.
6. Work with the internal team to troubleshoot any operational issues, ensuring robust and stable data operations.
7. Document and communicate the data warehouse architecture, structure, and data flow to the team for proper understanding and usage.
8. Provide training and guidance to internal team members on data warehousing principles and best practices.

**Qualifications:**
1. Proven experience as a Data Warehouse Specialist, Data Warehouse Engineer, or similar role.
2. Extensive experience with Google BigQuery, including data warehouse design and optimisation.
3. Strong knowledge of ETL processes and tools.
4. Deep understanding of database structures, data modeling, and data architecture principles.
5. Proficient in SQL and experience with other programming languages such as Python, Java.
6. Excellent problem-solving skills and attention to detail.
7. Strong communication skills to effectively collaborate with team members and stakeholders
8. Experience with data visualisation tools (e.g. Tableau, Power BI) is a plus

**Required skills:**
- Google BigQuery - 3 years
- ETL - 3 years
- Data Engineering - 4 years
- Data Warehouse - 4 years
- Experience in Data modelling
- Experience in SQL
- Experience in Python
- Experience in Java
- Experience in Tableau