Senior/Lead Python Engineer (DWH) (вакансія неактивна)

We sincerely hope that you are alright!
At this difficult time, we are receiving many reports of difficulties from some colleagues in the IT industry.
We understand that many professionals are now responsible not only for their lives, but also for their families and their safety.
SoftConstruct supports our colleagues, who are actively involved in all possible spheres of our country’s defense and also we are ready to offer jobs for IT specialists and a stable salary with all taxes coverage, both in Ukraine (remotely) and in Yerevan (with relocation coverage).
If you are looking for a job in Python specialization we would be more the happy to offer you our position Senior Python Engineer:

About Company:

Data Platform that delivers the performance, simplicity, concurrency and affordability for data collecting, rapid analytics, and extracting data-driven insights for business users.

Lambda architecture, designed to handle massive quantities of data by taking advantage of both batch and stream-processing methods. This approach to architecture attempts to balance latency, throughput, and fault-tolerance by using batch processing to provide comprehensive and accurate views of batch data, while simultaneously using real-time stream processing to provide views of online data.

In many organisations, data consumption processes for timely reporting or crucial analytical requirements are hindered by both delays in query execution and information presentation. Main challenge is to minimize decision delay with the help of flexible solutions with open and simplified architecture and high performance based on future oriented technologies using AI models and forecasting analytics.

In numbers:

• Up to 1 PB of data from 500+ partners in long-term storage
• 30+ M new records daily
• Latency for insight based on data delivery time <5 sec

About team:

Kafka (KSQL, Streams), Kafka Connect, Google Cloud as Cloud Hadoop, Google Dataflow (Apache Beam), BigQuery, SQL, Kubernetes, Java/Python, Apache Airflow

Skills & Experience:

• 5+ years of experience in Python;
• Experience working on NoSQL databases (Elasticsearch, Redis);
• Experience in writing complex SQL queries;
• Experience working on Linux, Kubernetes, Docker;
• Exceptional problem solving, technical and data analysis skills;
• Strong Computer Science fundamentals.
• Extensive knowledge of best practices in software design and design patterns;
• Experience in incorporating and utilizing BDD / TDD / Unit testing;
• Experience with Cloud Services (preference to Google Cloud Platform);
• Knowledge of performance tuning of ETL jobs, SQL’s, Partitioning, Indexing;
• Experience working on relational databases (PostgreSQL, Microsoft SQL Server).

Nice to have:

• Knowledge of Data Warehouse concepts;
• Experience with designing, implementing RESTful API’s (Aiohttp, FastAPI);
• Some experience in any Graph databases (Neo4j, AgensGraph);
• Some experience working with Workflow tools (such as Apache Airflow);
• Some experience with near real-time data processing.
• Some experience with IaC Tools (Terraform, Ansible);
• Some experience in any Big Data technologies (MapReduce, Spark, Presto, Drill...);
• Experience with Data visualization/Business Intelligence tools.

Main responsibilities:

• Development and support of Python applications;
• Keep tech solution in the agreed scope and acceptable timing;
• Work closely with data analysts, data scientists, IT, and business partners;
• Define, design and implement different data ingestion patterns based on business needs and requirements;
• Participate in complex project design teams;
• Solve issues that arise on a daily basis;
• Participate in groomings, demo and other Scrum/Kanban activities;
• Escalate blockers to PM and stakeholders.

What can we offer you:

• Annual leave: 20 working days per year
• All paid sick days with a doctor’s note (no limit on the number of times, but for 1 time it is paid up to 2 weeks) and 6 short terms sick leave
• Registration of FOP 3 group (the company pays all taxes and the commission of banks in addition),
• there is an accountant for conducting FOP (free of charge)
• Individual English classes at EnglishDom online school (within 50%of the amount of compensation)
• 450 USD annual budget for training and/or sports (within 50% of the compensation of the amount of
• expenses) after the probationary period
• Free health insurance after probationary period

Sounds interesting? Then, apply now, don’t wait up. SoftConstruct is a cool place to work, where you’ll have fun, make friends, and grow professionally.