Position: Middle+ / Senior ETL Data Engineer
Company: SPD-Ukraine
Category: Python
Experience required: 3y
English level: upper
Published: 2021-12-01T00:00:00+02:00

SPD-Ukraine is looking for a ETL Data Engineer to join an insurance project that is focused on helping other businesses to simplify insurance processes for their company and their employees. The project has been live for a few years already. Business is based in Denver CO and Washington, D.C. And there is an active communication planned between the development scrum team based in Ukraine and the US team.
SPD-Ukraine is a leading provider of software development services. Established in 2006, the company was created to focus on high-end business solutions. Over the years, SPD-Ukraine extended the range of its services and has built strong relationships with clients across the globe.
**Team:** 1TL, 1 Tech Lead, 1 QAA, 1 BA, 1 ETL.  
**Stack:** Datawarehouse: Snowflake
Data sources: MongoDB, PostgreSQL, MS SQL, S3
Data workflow management: Airflow
BI tool: Looker
Other tools/tech: sqitch, sqlfluff, github 

**Few words about SPD-Ukraine**
At SPD-Ukraine, great people create great software. Our story started in 2006. Now the team of 500+ cool specialists continues to write our story. Located in Ukraine (Kyiv, Cherkasy), we create products used by people all over the world. And what we do is what gets us out of bed in the morning. 

**Required qualifications:**
* 3-5 years working in data as an engineer. Building data solutions for a company that uses data as a primary part of their business.
* Experience in data warehouse and/or data analytics. Qualified candidates may also come from a strong database skill-set involved in analytics architecture.
* Strong experience in writing complex SQL queries.
* Strong experience in ETL/ELT platforms is strongly preferred. (Airflow as a plus)
* Exposure to one major SQL RDBMS or analytics database. (Snowflake, Redshift, MySQL, Postgres, Oracle, SQL Server, etc.)
* Experience with AWS (or other cloud providers) would be a plus
* Big Data and Business Intelligence exposure would help in the success of this role. (Looker as a plus)
* English: Upper-Intermediate level

**Scope of your responsibilities:**
* As a Data Engineer, you’ll be a member of the team responsible for transforming the commercial insurance market by delivering best-in-class data architecture solutions and driving more accurate data-driven decision making.  
* This role will work in data architecture, data analytics, ETL development, and data reporting.
* Success in this position will be establishing how data comes into and flows through the platform.

**What we offer for that**
Conditions / Space
You’ll have 20 paid holidays. Get sick? Stay home and get better — sick leavers are paid. Flexible working hours. Work remote or at the office (Kyiv, Cherkasy). You’ll be free to adjust your working space — choose a type of chair and model of laptop (depending on the project).
Clients / Projects
You’ll be engaged in the creation of products granted SIIA CODIE and GeekWire awards. Our clients are startups and companies with strong investments and innovative ideas. You’re free to change a project — internal rotation is available.
Learning / development
Online corporate library, soft skills training, internal educational events are available for you. Our Career Advisor helps you with a Personal Development Plan. SPD-Ukraine covers your expenses on conferences, certifications, etc. Plus, free English classes with native speakers.
Sport / Health
You’ll get compensation for sports activities. If you take COVID testing, SPD-Ukraine covers your expenses. Medical insurance is also available. You’ll be able to get online support from psychologists and mentors provided by a third-party service.
Fun / Activities
You’ll enjoy two big company events (SPD Summer Party and SPD Winter Awards). Every month you’ll be able to have team-building activities. Presents are waiting for you for big life events (marriage, childbirth) and nice presents just for fun.

 Does this sound like the kind of place you want to work at? We look forward to hearing ’hi’ from you :)