Position: Middle Data Engineer, Media Conglomerate
Company: DataArt
Experience required: 3y
English level: intermediate

A distributed team of 40+ people from DataArt and teams from the client's side, including high-quality Data Engineers (Python, SQL), API Developers (Java), QA Automation Engineers (Java, Python), DevOps engineers (AWS), and Product Owners.

**Client**
The world's major music company comprises an array of businesses aimed at helping artists achieve long-term creative and financial success while providing consumers with the highest-quality music content available. The client is engaged in the recorded music business (including artist services) and the music publishing business.

**Position Overview**
We are looking for data engineering specialists to help us actively develop the platform, create data pipelines and improve the quality of data. The project will allow you to gain experience in working with modern, cutting-edge platforms, frameworks and standards, such as Serverless, Event-driven, ELT, Amazon Web Services and Snowflake SAAS, and will introduce you to different aspects of the music business. Our main data consumers are Data Scientists, Marketing departments, BI Analysts, artists, and their managers.

**Technology Stack**
AirFlow, Amazon Redshift, AWS, Python, Redshift, Snowflake.

**Requirements**
- Strong understanding of DWH/ETL fundamentals and concepts
- Expert SQL knowledge in one or few RDBMS: MSSQL/PostgreSQL/Oracle
- Experience with one or few ETL tools and frameworks (MS SSIS, Pentaho, Talend, Informatica, etc)
- Experience with any of the following DWH: AWS Redshift, Snowflake, BigQuery
- Experience with AWS Cloud Platforms
- Analytical mindset
- Spoken English

**Nice to have**
- Snowflake experience
- Python experience
- Experience with BI tools (Tableau, Looker, etc)
- Experience with NoSQL databases: Cassandra, MongoDB, DynamoDB, OrientDB
- Understanding CI/CD concepts
- Big Data concepts and experience with Hadoop/Spark
- Experience in the Media industry and its standards