BI - Data Engineer

Our client is an American software company who currently looking for a Data Engineer who is passionate about data and BI processes, and who is not afraid of dealing with billions of rows and terabytes of data.  What You Do: Develop data expertise, be a data steward evangelist, and own data pipelines. Architect, build, and deploy new data solutions that provide forward-thinking data opportunities. Design and develop extremely efficient and reliable data pipelines to move massive amounts of data into the Data Warehouse and other data platforms. Use expert coding skills in Python and Shell. Own solutions end-to-end. Develop and implement data auditing strategies and processes to ensure data accuracy and integrity. Manage multiple projects in a fast-paced environment. Assist in the maintenance of an enterprise data warehouse. About you: Excellent communication skills including the ability to communicate data technologies and architectures. Advanced SQL skills and SQL query optimization, also solid Python and shell scripting will be a must. ETL Design and Implementation exposure. Some RDBMS knowledge OLTP and/or analytic columnar RDBMS including data Мodelling concepts (3NF vs Dimensional modeling). DBA and monitoring skills. Working knowledge of Linux including system administration. Would be a plus: 2+ years of Java or other OO development experience, with source code control (Git) and build/release process, Airflow. Machine learning and recommendation systems Experience with Tableau, MySQL, Hive, Spark Passion for something that Smule is about: music, games, social experiences, outstanding software What we can offer you: Advanced and Latest Technologies Growth and Learning opportunities Additional Health and Dental Insurance Benefit pack a huge variety of benefits to choose from Hybrid mode WFH/WFO Stock Options Plan Discount program Attractive Refer a talent program with bonuses 22 vacation days, increasing to 28 for all loyal employees Office food and beverages Recreation area (you can play music) and relax zone Happy hours and office fun events, team buildings, etc.