DWH / BI / Data Engineer (offline)

Role Summary:
We are seeking a talented Data Engineer to play a crucial role in implementing and maintaining a data warehouse. 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 and the Project:
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!

Majority of 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 a half of a year are possible.

Your team: Product Manager & Tech Lead, Senior Data Engineer, Senior Data Engineer, Sustaining, Engineer, Sustaining.

Requirements:
4+ years of experience in DWH development;
Strong SQL skills (SQL syntax, query plans, debugging, partitions);
Development/support experience of ETL processes;
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;
Use of Slack, JIRA, Confluence and other collaboration tools;
Excellent written and spoken English.

Nice to have:
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.

Benefits:
Official and timely pay;
Social perks;
Sick pay, vacations;
Flexible work schedule;
Friendly environment;
Medical insurance.
Interesting job in an innovative company with the latest technologies,
Collaboration with a team full of interesting people.

About Olsys

OLSYS Ltd provides full-service solutions for mid-market and enterprise organizations.

With 15+ years of experience, 100+ projects and 50+ strong technical experts in the team, we continue to grow by expanding our development team in Europe, as well as expanding the base of new clients and projects.

As an enterprise software development company, we are building long term partnerships helping our clients accelerate their digital experiences with reasonable IT investments.
Our tailored approach, e-commerce focus, and flexible solutions allow us to design, develop, and deliver scalable, integrated commerce platforms that drive profits and boost the business.

Our industry focus:
— Banking and Finance (business continuity management, planning system, banking app development);
— Retail and E-Commerce (B2B Commerce, B2C Commerce, Digital/E-Commerce customer experience);
— Healthcare (website development for Healthcare organizations).

Our expertise includes:
— Commerce Solutions
— Development Services
— Creative Services
— Quality Assurance and Testing
— Maintenance and Support
— E-Commerce Consulting

Company website:
https://olsysltd.com/

DOU company page:
https://jobs.dou.ua/companies/olsys/