Data Warhouse Developer

Náplň práce, pravomoci a zodpovědnosti

Collaborates with business unit liaisons to understand and develop business and functional requirements
Change management of existing database tables/views and data models
ETLs job creation, maintenance and supervision
Database programming (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

Jiné výhody

We are now looking for a Data Warehouse Developer/Architect to further strengthen our team. The position is based in Brno, Czech Republic.

The Data Warehouse Developer is responsible for database structures manipulation, transformation, ETL development for the data warehouse and ad hoc data extractions. Developer partners with analysts, information data architect and business liaisons to understand the requirements to ensure that the data are loaded and maintained in a consistent, logical, error-free, and optimal manner.

What we offer
We care about the environment and the people who live in it. With us, you will have the chance to develop personally and professionally, work with a team of passionate people, and positively impact the lives of others.

What is more:
Competitive salary
Annual bonus connected to company performance
Relocation package
Lunch fully paid, office refreshment
Strong work/life balance, flexible working hours
5 weeks paid holiday
Oriflame products for free
Company mobile phone tariff with contribution (available to family members)
Company team-building activities
Onsite training about Oriflame business, system architecture & technologies
Position in an international environment with informal friendly atmosphere
Opportunity for short-term assignment abroad
Work in attractive UNESCO listed historical town, enjoying active outdoor life style in quiet environment

Osobnostní předpoklady a dovednosti
- Characteristics
Strong analytical, logical thinking and attention to detail
Understanding of the business processes related to the data
Regular daily use of English is a standard with presenting, cooperating with stakeholders, attending team/corporate meetings

- 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 – desirable
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

- Qualifications
Degree in Computer Science, Software Engineering, Statistics, Mathematics or similar
At least 3 years of experience in database development
English written, spoken level B1

Práce v oboru: IT

Lokality: Jihomoravský kraj