Joyteractive is a leading mobile game developer and publisher specializing in puzzle games, currently seeking a skilled Middle Data Engineer to join their team of over 60 professionals.
The company is known for its successful game, Cryptogram: Word Brain Puzzle, which ranks #3 among all iOS/Android word games in the US.
The Data Engineer will be responsible for the development of ETL/ELT pipelines, including the design and maintenance of DAGs in Airflow for automated data collection and loading.
The role involves the integration of external sources, configuring incremental data extraction and deduplication from platforms like Appsflyer and Firebase.
Data modeling in dbt is also a key responsibility, which includes creating and maintaining SQL models from staging to marts, along with quality tests.
Requirements:
Candidates must have experience with Apache Airflow, specifically in designing, developing, and maintaining DAGs, as well as managing task dependencies and triggers.
Proficiency in advanced SQL is required, including knowledge of CTEs, window functions, and optimization, with experience in Redshift and/or BigQuery.
Hands-on experience with Python for ETL/ELT processes is essential, including skills in using libraries such as requests, pandas, and logging for building connectors and data transformation.
Additional qualifications that will be considered a plus include experience with BigQuery and GCP services, particularly in migration and optimization, as well as familiarity with Cloud Storage, Pub/Sub, and Dataflow.
Experience with streaming and message queues, such as Kafka, Google Pub/Sub, or AWS Kinesis, is also advantageous.
Familiarity with modern ELT tools like Airbyte, Fivetran, or Meltano, and proficiency in BI tools such as Looker, Tableau, or Power BI for building dashboards and analytical reports will be beneficial.
A solid understanding of mobile and web analytics metrics, including attribution and cohort analysis, as well as knowledge of advertising platforms, is preferred.
Benefits:
The position offers 18 business days of compensated time off each year.
Employees receive 8 paid personal days annually, with an additional day added each year.
There is a flexible public holidays policy in place.
An individual budget for training and growth is provided to support professional development.
The company offers 100% sick leave compensation.
Payment for wear and tear on personal equipment used for work is included.
The role allows for remote work, providing flexibility in the work environment.