Position: Data Engineer
Company: MEV
Experience required: 2y
Category: Data Engineer
English level: pre
Published: 2022-04-01T00:00:00+03:00

The point of the project is to collect data from hotel management systems, transform this data and generate metrics and visual representations of reports and graphs based on it. This data is used by management companies, hotel owners, marketing and analytical teams who are concerned about the state of revenues and ways to increase them.

**Stack:** Python 3.7+, NodeJS 14+, VueJS, PostgreSQL, AWS (Lambda, Step Functions, SQS, RDS, Elastic Beanstalk).
Serverless architecture (Lambda/Step functions).

**What’s interesting about this project:**
• Narrow focus on the hotel business
• Built-in intelligent system of metrics forecasting
• Ability to study the collected data in historical mode (time travel view).

**Scope of tasks and ownership:**
• Integrations with new sources of raw data (Rest API, sFTP, email reports);
• ETL pipelines design and construction;
• Design of data transformation from raw unstructured or weakly structured data into unified structured data models;
• Upgrade the warehouse system in close cooperation with DevOps team;
• Applying modern AWS servers to handle ever-growing data flow and volume (AWS Glue, AWS QuickSight, etc.).

**What You’ll need:**
• Skills in writing clean code and applying design patterns (SOLID, DRY, KISS, etc.);
• Ability to apply data processing patterns;
• Design of models and data structures focused on analytical needs (dimensional models vs relational models);
• Experience with relational databases (PostgreSQL or similar);
• Experience with any back-end programming language and a willingness to use Python as the primary language for data processing;
• Data Lake/Warehouse design and implementation;
• Cloud programming in AWS or its analogs (Google Cloud, Azure);
• Test writing and TDD approach;
• Experience with Redshift DB or its analogs (Google BigQuery, Azure Synapse Snowflake);
• Ability to clarify requirements and take part in the solution design together with engineering team, BA and PO.

**Our benefits:**
• No micromanagement;
• Freedom to engage in decision-making and implementation;
• Ability to work in a team of professionals (the ratio of middle and above specialists 80/20);
• Participation in the development of high-quality products;
• Direct communication with clients on a partnership level;
• Professional development opportunities ($500 education budget, well-managed processes, communities, internal library);
• Health insurance;
• $500 extra for the health care, sports or mental health;• Accounting services;
• 20 paid working days off and 10 days sick leave;
• Opportunity to work remotely;
• Relocation reimbursement;
• Soulful team buildings and corporate events.

**Join us and be among those who care!**