Position: Junior DWH/BI Engineer (O)
Company: Exadel
Experience required: 1y
English level: intermediate

A career with us means you will work alongside exceptional experienced people and be empowered to reach your professional and personal goals. As a successful, high-growth company, we know that our employees are the foundation of what makes Exadel a strong, stable company. We value our people, engage and develop them to their greatest potential!

**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.

**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
Written and spoken **English** (B1+(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