Сучасна диджитал-освіта для дітей — безоплатне заняття в GoITeens ×
Sunvery is an agency of dedicated professionals. We care about all small details in the recruitment process to save time of the client and create the best candidate’s experience. Working with us you will feel all the advantages of having business with people that love what they do. It is our job to help you.
4 квітня 2021

Senior/Tech Lead Data Warehouse Engineer/BI (вакансія неактивна)

Київ, Харків до $5000

Необхідні навички

● Must have strong technical expertise in database architecture, design & data modelling
● Intermediate English level
● Expertise in gathering and analyzing system requirements and designing conceptual and logical data models
● Ability to build conceptual, logical, and physical data models in Erwin and/or ER Studio
● Strong SQL query writing skills
● Experience working with Big Data
● Ability to speak to the differences in data modeling technology and philosophies of Codd, Kimball, and Inman
● Knowledge of data model types and terminology including OLTP, OLAP, cubes, dimensional star/snowflake modelling, and graph/NoSQL
● Prior experience in databases like Oracle, SQL Server, Aurora MySQL, MongoDB
● Experience with HIVE is an advantage
● Familiarity with data visualization tools like Tableau/MicroStrategy
● Understanding of and ability to apply data naming standards and to explain your definition of “best practices in data modeling”

Буде плюсом

● Experience working in the AWS ecosystem

Пропонуємо

● Vacation is 20 working days / till 20 working days per year for sick leaves;
● Full payment of taxes;
● English courses;
● Flexible work schedule;
● Friendly environment;
● Medical insurance;
● Opportunity for career growth

Обов’язки

● Design and develop integration data models between multiple data sources and consolidate them into a single common data model or enterprise data model
● Maintain version control of the data model(s), as well as ensure consistency between the data model and deployed instances of the model

Про проєкт

ortonworks is the current vendor. It will be replaced by Amazon EMR. Tableau is going to be the BI vendor. Microstrategy currently exists and will be phased out by early 2023.

All data is sent to the data lake, and the customer can do industry reporting. These data are used by a data science team to build new products and an AI model.

We will be moving to real-time streaming using Kafka and S3. We are doing POC to use Dremio and Presto for the query engine.

We’re migrating to version 2.0 using Amazon EMR and S3, and Query engine is bucketed under 2.0 project.

Гарячі вакансії

Всі вакансії