Position: Data Engineer with Python Experience and AWS Skills, Banking System
Company: DataArt
Category: Data Engineer
Experience required: 2y
English level: intermediate
Published: 2022-10-01T00:00:00+03:00

DataArt's experts together with developers on the client's side are creating new banking apps and upgrading the old ones.

Working on this project will provide you an opportunity to participate in the technological modernization of a large financial institution, creating a product that will have millions of users, and obtain relevant experience in Agile software development.

The project is to take data from 2 sources:
1) SQL Server database
2) A JSON Web-service
And publish the data into an AAWS-hosted Snowflake database.

**Client**
Our client is a British bank, one of the largest finance companies in the world. The bank was founded three centuries ago, and today its assets are estimated at trillions of US dollars. 

Throughout its history, the bank has offered various banking products to clients. Its technical support has become more complex and expensive due to the expansion of its product line and the growth of its customer base. The development of technologies has led to a growth in customer expectations for banking apps as well as the automatization of bank account interactions. Therefore, it became clear that all the IT systems of our client needed an upgrade. Now they have been improved in accordance with modern technologies, and the user interfaces of the apps have been modernized as well.

The DataArt team is now working on closer integration of the apps. An incredible amount of paperwork with which the specialists of the bank are engaged is going to be automated and transferred to electronic format.

**Position Overview**
We are looking for a Data Engineer with experience in using Python to extract and transform data.
We would expect the Engineer will have experience in Financial Services and will have used Pandas & NumPy.
The task is to extract data using web-service calls and parse JSON responses which will be published to AWS S3.
In addition to this, the developer should also have experience in Snowflake development to transform uploaded data in AWS S3 into the data warehouse model.

**Technology Stack**
* Python + Webservices & JSON
* StreamSets
* AWS S3
* Snowflake
* AutoSys

**Requirements**
- Experience in Python
- Experience in financial services
- Experience working with Pandas & NumPy
- Experience in Snowflake development
- Spoken English

**Nice to have**