GIT Consult

Architect/programmer for Data Warehouse – SQL

Architect/programmer for Data Warehouse - SQL Published: 13.11.2019

Description

Our client is now looking for a Data Warehouse Architect/Developer - Senior - to further extend our team.
In this role you will be responsible for database structures manipulation, transformation, ETL development for the data warehouse and ad hoc data extractions.
DEVELOPER mostly partners with analysts and data architect to understand the requirements to ensure that the data are loaded and maintained in a consistent, logical, error-free, and optimal manner.

Responsibilities

What RESPONSIBILITIES you can expect:

· Collaboration with Business analysts to understand and develop business and functional requirements
· Change management of existing database charts/views and data models
· ETLs job creation, maintenance and supervision
· Database development (procedures) and administration of BI/DWH back office
· Attends team meetings and daily scrums with in-house as well as remote colleagues
· Ad-hoc analysis and data extractions
· Performs technical analyses for development of new features
· Maintains the knowledge base and follows documentation process rules

Requirements

What QUALIFICATIONS you should have:

· Degree in Computer Science, Software Engineering, Statistics, Mathematics
· At least 3 years of experience in database development
· English on level B1 – spoken and written

Technical Skills – MUST HAVE
· Ability to write software code in database environments:
· SQL knowledge is essential
· Understanding of RDBMS architecture
· Data warehousing and ETL principles

Technical Skills – NICE TO HAVE
· Knowledge of Agile and iterative methodologies like SCRUM, KANBAN
· Experience with Oracle & PL/SQL
· Experience with IBM Cognos BI or other business intelligence tools
· Experience with Data Science (Predictive Analytics, Machine learning, R)
· Experience with RDBMS performance tuning, partitioning and indexing strategies, materialized views management

We offer

What we want to OFFER:

· Competitive salary
· Annual bonus connected to company performance
· Lunch fully paid, office refreshment
· Strong work/life balance, flexible working hours
· 5 weeks paid holiday
· Company mobile phone tariff with contribution (available to family members)
· Company team-building activities
· On site trainigs for system architecture & technologies


Location
Brno
Category
Job type
Full-time
Contact person
Marcela Slovakova
Drop files here browse files ...