Big Data Engineer

We are looking for a Big Data Engineer/ETL Developer for the DWH department!

The Data Warehouse department is aimed at helping projects to make smart business decisions by integrating and processing huge amounts of data and providing efficient calculations and reports based on stored information. Our team of experienced data-enthusiastic engineers wants to expand by hiring a committed and creative specialist. We use cutting-edge data processing technologies and improve through constant learning. 

Reports to

Team Lead of Big Data

What will you do?

• Enhancements, new development, defect resolution, and production support of Big data ETL development
• Write ETLs to clean/transform data into clear data models (snowflake, Athena, using our python framework, a little bit Impala, Hive, Oracle)
• Work with and finalize the requestor’s requirements

60% of your work will relate to writing SQL queries, you should also understand what kind of data you work with and think about what kind of solution will solve the internal customer’s problem better.

Who are we looking for?

• 3+ years of experience with DWH/BI
• Good knowledge of data querying and transformation: SQL, Oracle PL/SQL, impala/hive SQL, Snowflake SQL
• Experience with versioning systems (SVN, git)
• Ability to work with and finalize the requestor’s requirements
• Expertise in ETL processes design and implementation, data lifecycle management
• Desire to learn
• Fluency in English and Russian

What additional skills will help you stand out?

• Performance tuning in any DBMS
• Experience with cloud data solutions
• Experience with Spark
• Experience using Python, S3, EC2, Athena in AWS environment. 

Benefits

Benefits and perks are tailored to the local market and culture. Our benefits in Prague include:

• 5 weeks of Annual Leave per calendar year
• Up to 10 Personal Days per calendar year
• Career development and education opportunities within the company
• Language courses (English, Russian, Czech) fully covered by the company upon Manager’s approval.
• Meal card – 150 CZK net contribution for each business day
• Multisport Employee discounts
• Personal Gaming Account 
• Transportation allowance
• Premium private health care
• Coffee, fruits, snacks in the office
• Company events
• Seniority Awards  
• Referral program - You can recommend the best talents to the company and receive a reward  
• To learn more about our studio in Prague, follow this link: https://prague.wargaming.com/