Position: Data Engineer (AWS), Banking System
Company: DataArt
Experience required: 3y
English level: intermediate

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:
- 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.

Responsibilities:
- Developing and supporting services that provide for the deployment and management of SQL database technologies.
- Providing tools for monitoring, managing, alerting, and improving customer database performance.
- Developing and implementing automated processes that ensure the uninterrupted updating and correction of database vulnerabilities.
- Publishing documentation that enables a smooth transition of database services from the build and development phase to production support.
- Providing consultations, training, and mentoring for the development team.
- Active participation in upgrading systems.
- Root cause analysis and troubleshooting.
- Support for production systems, must be prepared for regular on-call duty.

Requirements:
- 3+ years of proven experience with financial services.
- Experience with AWS Integrations.
- Experience in SAS Macro development.
- Experience with Hadoop Spark.
- Hands-on experience with Impala/Hive. 
- Experience with Scala.
- Extensive experience using RDMS, ETL pipelines and SQL.
- Good understanding of data tuning, automated data quality testing.
- Solid experience with data warehousing, data modelling and data wrangling.
- Strong experience of Oracle/Snowflake/Informatica and Feature Engineering.
- A good understanding of modern code development practices.
- Spoken English.