Position: Senior SQL developer with Python
Company: 8allocate
Experience required: 5y
English level: upper

**8allocate** is an IT outsourcing company with headquarters in Estonia and R&D offices in Ukraine and Poland. We provide custom software development services for clients from the UK and the USA, specializing in FinTech and EdTech.

Currently, we are looking for a **Senior SQL developer with Python.**

**Client/Project:** Our client is an alternative fixed-income investment manager focused on opportunities in the Agency MBS markets. The firm’s investment process is distinguished by its reliance on fundamental research, tactical trading, and an extensive and flexible analytics infrastructure for valuation and risk management. They offer a global community of institutional and high-net-worth investors access to commingled vehicles and separately managed accounts.
They leverage their deep and specialized knowledge in fixed-income trading and structured products to pursue an Agency Mortgage-Backed Securities ("MBS"​) arbitrage strategy on behalf of a global investor base of institutional and high-net-worth clients.

**Project description:** Migrating data from SAP Sybase IQ prepay database to AWS Redshift: rewriting procedures, and building the correct data processing sequence.

**Tech stack:**
Amazon Workspace, AWS, BitBucket, PyCharm, MWAA Airflow AWS-based, Cloudwatch for Redshift, Redshift, SAP IQ, Redshift Spectrum, S3.

**The team:**
Overall 15 developers with different roles on a project.
— Spark-related team, processing SEC data files with Spark & loading them to Redshift.
— SAP IQ / Redshift migration team.
— UI/UX team, responsible for creating an internal dashboard for making investment decisions based on processed data.

**English:** B2.

**Requirements:**
— 5+ years of experience in SQL development, and experience in data migration projects is a bonus.
— Familiarity with both **SAP Sybase IQ** and **AWS Redshift platforms**.
— Strong knowledge of Python.
— Experience in testing SQL procedures for bug identification and resolution related to data discrepancies.
— Familiarity with Apache Airflow, especially in terms of creating and tuning Airflow DAGs.
— Past experience or knowledge in translating legacy bash scripts.
— Good analytical skills with a knack for understanding and breaking down complex business logic.
— Strong communication skills to effectively liaise with different departments and stakeholders.

**Responsibilities:**
— Understand and analyze existing SQL procedures in SAP Sybase IQ.
— Rewrite complex SQL procedures, considering both business logic and redundancy.
— Ensure the effective and optimal data transformation between SAP Sybase IQ and AWS Redshift.
— Regularly test the rewritten SQL procedures to ensure correctness.
— Identify, troubleshoot, and rectify any bugs or data-related issues.
— Develop custom Python scripts to perform data quality checks and validate data consistency between SAP IQ and Redshift.
— Translate legacy bash scripts into efficient Apache Airflow DAGs.
— Maintain and optimize these Airflow DAGs to ensure smooth and efficient data processing.
— Collaborate with other teams to ensure any dependencies or prerequisites are correctly set up in the Airflow environment.
— Document all processes, codes, and scripts for future reference and training.

**Why choose us?**
— “Family and Friends”. We are no longer a start-up, but we still, have a family atmosphere in our supportive and spirited team, who are all working together on the same goal.
— “Just break down all barriers and find a better way”. Every day you’ll meet with interesting and challenging (international) projects that are covering industries from commercial aviation to fintech (different technologies, different products).
— “Hungry for learning”. You will get a lot of chances for career advancement and the development of new skills, opportunities for mentorship, or learning from more experienced colleagues.

**Benefits from 8allocate:**
— You’ll work with a supportive and spirited team of professionals.
— Corporate events, holidays, and team buildings for your joy.
— Training and development: we have a huge library (about 500 books!) and a budget for your professional development.
— Coverage of psychologist sessions.
— Сoverage of sports activities.
— People-oriented management without bureaucracy.
— Paid vacation and sick leaves.