Position: Middle BI Engineer
Company: SoftServe
Category: SQL
Experience required: 1y
English level: upper
Published: 2021-09-01T00:00:00+03:00

**WE ARE**
SoftServe supports our client, one of the biggest delivery services in the world, in improving the quality of their services. They operate in 13 countries with over 50,000 riders who deliver orders from 50,000 restaurants in over 200 cities worldwide. They operate one of the most complex three-sided marketplaces in the world, and they do this in real-time. The algorithms behind that marketplace are the secret sauce that allows them to deliver our orders in under 30 minutes.

Currently, all global users access the same platform infrastructure, and when infrastructure breaks all global users are impacted by any issues or outages. Currently, services have to process data for all our global markets and there is a limit to how much they can be scaled.

We are aiming at dividing our markets across five different shards. Breaking down a single DB into geographically distributed shards will allow distributing order volume as much as possible. Our goal is to migrate ETL pipelines, data processes, reports, queries, and standalone processes to use a new DRN format instead of the current identifiers.

**YOU ARE**
- Possessing at least 2-year engineering experience
- Demonstrating excellent SQL skills
- Skilled in data warehousing, data modeling concepts, and structuring new data tables
- Having a good working knowledge of cloud-based MPP data warehousing (e.g. Snowflake, BigQuery, Redshift)
- Experienced in managing the administration and/or adoption of a data visualization tool (e.g. Looker, Tableau, Power BI)
- Demonstrating SQL ETL/ELT knowledge, experience with DAGs to manage script dependencies
- Showing good communications skills across all levels of stakeholder (business & technical)
- Demonstrating Intermediate Strong+ English level

**YOU WANT TO WORK WITH**
An agile team passionate about utilizing emerging technologies and delivering high-quality and timely code
Cross-functional global teams to define, design, develop, and deliver new features
Continuous exploring, evaluation, and incorporation of new technologies into our products and processes to improve development efficiency
Delivery of quality software solution using Agile development cycle
Analyzing and resolving performance, stability issues

**TOGETHER WE WILL**
Support your technical and personal growth — we have a dedicated career plan for all roles in our company
Enjoy flexible working hours — whether you are a morning bird or a sleepy-head it is ok with us
Take part in internal and external events where you can build and promote your personal brand
Give you access to experienced specialists willing to share their knowledge
Show you our casual atmosphere — no dress code
Care about your individual initiatives — we are open for them, just come and share your ideas
Share many other advantages with you such as attractive salary, modern office, a package of benefits, language classes