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 Guildford include:

• 5 weeks of Annual Leave per calendar year
• Dog-friendly office
• Onsite canteen (with an endless supply of snacks and beverages)
• Video game areas, Warhammer painting station, a bespoke D&D table, Adjustable height desks
• Wellbeing perks (Mental Health Days, Dedicated Well-being room, Team of Mental Heath First Aiders, Professional counseling)
• Health Insurance (including family coverage), Life Insurance, Pension contribution
• Career development and education opportunities within the company
• Employee discounts
• Personal Gaming Account 
• Company events 
• Seniority Awards 
• Referral program - you can recommend the best talents to the Company and receive a reward 
• Working in one of the main European hubs for mobile game development
• Startup within a company with 25 years of experience on the market
• To learn more about our studio in Guildford, follow this link: https://dpsgames.com/studio