Position: Junior DWH/BI Engineer
Company: Exadel
Experience required: 1y
Category: SQL
English level: intermediate
Published: 2020-09-01T00:00:00+03:00

**Requirements**:
• SQL basic skills;
• Knowledge of Core Databases: MS SQL 2014+;
• Strong engineering process and hygiene skills e.g. source control, coding standards, code reviews;
• Comfortable working in an agile team (SCRUM);
• Comfortable working with a remote team;
• English level: Intermediate.

**Nice to have**:
• Experience in DWH development;
• Familiar with ETL processes;
• Use of Slack, JIRA, Confluence and other collaboration tools;
• Exposure to other Relational Database Management systems;
• Some Python exposure;
• Familiarity with Jenkins, Docker.

**Responsibilities**:
• Determine data requirements by interviewing customers; analyze business requirements and applications; evaluate existing systems, hardware, and software; define and analyze data sources; validate data required; document requirements;
• Analyze data by defining quality requirements; assess data quality, availability, and change data capture;
• Implement data schema by developing program, process, procedure, and quality solutions for data acquisition, extraction, cleansing, transformation, integration, loading, and replication; develop filtering, formatting and data delivery processes to data marts; build SQL code, stored procedures, and triggers;
• Design interfaces by developing visualization and access methods; design application reports and testing;
• Design, build and deploy BI solutions (e.g. reporting tools);
• Evaluate and improve existing BI systems.

**About the Customer**:
You will work with an international management consulting firm that focuses on retail services. The company is headquartered in New York City with 60+ offices in the Americas, Europe, Asia Pacific and the Middle East and employs over 4,500 professionals!

**About the Project**:
The majority of the Customer’s projects are data driven. The project provides stores with statistics about goods sold, which in turn helps stores to arrange goods more efficiently. The work will be mostly done from our offices, but business trips to London/Dublin once every half of a year are possible.

**We offer**:
•  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.
You can find more information about Exadel in Ukraine here: www.facebook.com/exadelukraine