Position: BI Analyst/Developer
Company: Lumenity
Category: Business Analyst
Experience required: 2y
English level: upper
Published: 2021-09-01T00:00:00+03:00

**About Project:**
You will become a part of the product company developing, improving and taking care of hundreds of thousands of customers every month. The UK leads in the retail business everything5pounds.com and wowlondon.com.
We are a B2C product with a great team of enthusiastic people delivering stable, comfortable, and user-friendly experiences for our clients who are ordering thousands of items a day.
We are seeking a BI analyst / developer join our team. The ideal candidate should have prior experience in BI projects in the eCommerce / retail domain. You will be a major contributor working on our product launches, improvements and optimizations. Let’s grow business together!
**As BI analyst / developer you will be the focal point of BI, with End to End responsibility:** 
scheme design, write data transformations, integrate data sources, build data aggregations, maintain and develop dashboards & reports, in Big Data environment, for various of eCommerce assets. 
**Responsibilities:** 
- Manage and maintain data warehouses built on Google Big Query.
- Build and maintain data pipeline written in Python.
- Orchestrate data pipelines using Airflow DAGs.
- Manage and maintain reporting / Dashboards using Tableau.
- Interface with engineers, product managers and product analysts to understand DWH / reporting requirements.
- Build data expertise and own data quality for allocated areas of ownership.
- Design, build and launch data models and ETLs in production environments, using Python.
- Support existing processes running in production.
- Investigate and explore big data solutions to innovate and improve DWH infrastructure.
**Requirements:**
- BSc or MS degree in Computer Science / economics / industrial engineering or a related technical field.
- At least 1-2 years of experience with dimensional data modeling & schema design in Data Warehouses.
- 1+ years of experience in custom or structured ETL design, implementation and maintenance
- 1+ years of experience with BI tools like Tableau / Power BI / any market leading tool 
- Must have experience with programming in Python
- Must have strong and proven SQL skills
- Experience with Amazon solutions (AWS) / Google cloud -BigQuery / - Apache Airflow - an advantage  
- Linux Skills – an advantage 
- Working with APIs / Json file – an advantage
- Autodidact, with passion to learn and work with big-data tools
**We offer:**
- Competitive remuneration
- Medical insurance
- Office location in Kyiv — Regus Volodymyrsky business center (currently — remote work)
- Flexible working hours.