Position: Data Warehouse Developer
Company: KitRUM
Category: SQL
Experience required: 3y
English level: upper
Published: 2021-03-01T00:00:00+02:00

**Main requirements:**
— 3+ years of experience in Data Warehouse/Data Integration;
— Knowledge and understanding of data warehouse concepts (such as Kimball or Inmon methodologies);
— Hands-on experience using one of the mainstream data integration products such as Talend or similar;
— Experience in managing semantic layer of Business Intelligence/Analytical platforms such as Tableau or similar;
— Extensive experience in SQL query writing and optimization experience;
— Strong experience in mainstream DBMS like MySQL, PostgreSQL, etc.;
— Ability to obtain, analyze and synthesize information from multiple sources;
— Good problem-solving skills;
— Keen attention to detail and data quality;
— English Level: Upper-Intermediate.

**Will be a huge plus:**
— Basic experience in business analysis and requirements gathering from business users;
— Previous work experience with databases greater than 1TB will be considered an asset;
— Experience with columnar databases such as Amazon Redshift;
— Experience with AWS or GPC cloud platform services;
— Experience in a cloud environment will be considered an asset.

**What we offer:**
— High compensation according to your technical skills;
— Long-term projects (12m+) with great Customers;
— 5-day working week, 8-hour working day, flexible schedule;
— Democratic management style & friendly environment;
— WFH mode;
— Annual Paid vacation — 15 b/days + unpaid vacation;
— Paid sick leaves — 6 b/days per year;
— Ukrainian official holidays;
— Corporate Perks (external training, English courses, corporate events/team buildings);
— Cozy office in the center of the city;
— Coffee, cookies, and other goodies;
— Professional and personal growth.

**Duties:**
Be a part of the team responsible for maintenance and further development of the existing company data warehouse system in the cloud environment (AWS), which acts as a single point of truth for making data-driven business decisions.

The work will consist of data modeling and data transformation design, development of new and improving existing data load processes, ensuring that the data warehouse has the best architecture, data quality and that the system is performant, scalable & maintainable while processing high volumes of data and executing complex ETL and reporting queries.