Position: Data Warehouse
Company: Blackbird Lab
Experience required: 3y
English level: upper

In 2021 we partnered with a Canadian software company that is providing software products to supply chain companies like Sony, Procter & Gamble, Pfizer, Loreal etc.

**Position & client**
This software solution allows brands to manage manufacturing in facilities, setup and process work orders, shipments, etc. This software is used by hundreds of manufacturers in North America and Europe, this is a core product of our client that’s been used for over 10 years. This product has L1 and L2 support teams and development’s team main focus is maintenance, troubleshooting and bug fixing. Company also has a Data Warehouse that is used by manufacturers and a dedicated Data team that owns it. 

**Stack of the project**
- Snowflake 
- SQL
- Python
- AWS

**Responsibilities**
- Analyze business requirements, implement data projection and transformation
- Participate in technical discussions, improve platform performance
- Communicate with other development teams
- Estimate your tasks and be responsible for code reviews

**Requirements**
- Strong knowledge of SQL, SQL optimization
- Experience with big volumes of data, batch processing
- Upper-Intermediate English speaking level

For Seniors
- 5+ years of experience in engineering
- 2+ years of experience in data engineering
- Experience with data pipelines

**Will be a plus:**
- Experience with real-time processing
- Experience in automation testing and deploying

For Middles
- 2+ years of experience in engineering
- 1+ years of experience in data engineering

**Team setup & processes**
- Lead Data Engineer (Canada)
- 2 Data Engineers (Canada)
- Middle and Senior Data Engineer (Ukraine) - open positions

The team is following 2-week Sprints with Story Point estimates, refinements, plannings, demos and retrospectives.

**Interview process**
- HR interview (30 mins)
- Technical interview with Senior Engineer (90 min)
- Interview with Project Manager (60 min)

**Benefits**
We are all for the self-development of each team member. As a part of our team, you’ll be supported in your professional growth, work on Macs, receive certifications, and visit conferences. On top of that, you will enjoy an attractive social package, including

- Сompetitive monthly compensation
- Flexible working schedule
- Working remotely
- 18 paid vacation working days
- Paid sick leaves (with 5 undocumented days per year)
- Health support with medical insurance or sports programs
- English lessons, sports activities, and charity events
- Full support of Private Entrepreneur reporting services (ФОП)