Position: Middle Data Engineer (MS SQL + ETL), Professional Certification
Company: DataArt
Category: Data Engineer
Experience required: 3y
English level: intermediate
Published: 2022-03-01T00:00:00+02:00

CLIENT
One of the largest professional certification associations in the finance industry globally uses DataArt as its primary technology execution and development partner. This highly prestigious and recognizable organization has thousands of certified members worldwide and has drastically increased its reliance on DataArt over the past year.

TEAM:
The DataArt team consists of several dozens of people: developers, testers, architects.

POSITION OVERVIEW:
We are assembling a team that will develop and upgrade the systems of the international association of financial industry professionals. The company that unites 200 thousand investment experts uses more than a hundred different applications.

TECHNOLOGY STACK:
Azure, Python, MS SQL, Snowflake, JavaScript, Azure Data Factory, Azure SQL.

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 experience with Python.
- 3+ years of proven experience in SQL Server products, SQL programming.
- Strong experience of Snowflake.
- Experience with JavaScript.
- Extensive experience using RDMS, ETL pipelines and MS SQL.
- Solid experience with data warehousing, data modelling and data wrangling.
- Experience with Azure Datawarehouse.
- Hands-on experience with Azure Data Factory, Azure Data Lake, Azure SQL Server / Database, Azure Storage Accounts.
- Experience of ETL technical design.
- Good knowledge of automation and scripting in a mixture of on-premise and cloud environments.
- Understanding of working with Git.
- Able to work with CI/CD pipelines and code repositories to manage change.
- Good understanding of systems and software development lifecycle.
- Good understanding of data tuning, automated data quality testing.
- Good spoken English.

Nice to have:
- Experience with Azure cloud platform (Azure SQL, ServiceBus, AppServices, Active Directory, Application Insights, DataBricks or Spark (PySpark)).
- Experience in task estimation.
- Excellent knowledge and practical experience with Agile methodology.
- Proven experience with financial services.