Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailJob Description:
The dentsu group is a global marketing communication network that responds to the needs of the digital age with its offer. It includes the following brands: Carat Isobar iProspect Red8 Advertisement Amplifi DDS dentsu and dentsu X. The dentsu group operates in 110 countries around the world employing over 45000 experts. In Poland it has been operating in its current form since 2005 and employs about 700 people serving over 200 clients.
dentsu strives to be the network of choice worldwide for customers looking for expertise and the greatest capacity in brand media and digital communications services.
Due to dynamic development we are looking for a person for the position of Data Engineer.
We are seeking a passionate and skilled Data Engineer to join our data engineering team. The primary responsibilities of this role will focus on ETL processes cloud administration and data warehouse maintenance within our Google Cloud ecosystem.
Key Responsibilities:
Architect build and sustain scalable ETL workflows utilizing Apache Airflow within the Google Cloud Composer environment.
Write highquality readable and maintainable code following best practices and PEP8 guidelines.
Create modify and maintain DAGs.
Develop custom hooks and connectors for interacting with various services such as APIs databases and FTP servers.
Work with CI/CD pipelines and containerization technologies like Docker.
Contribute to the upkeep and advancement of our BigQuery data warehouse infrastructure.
Handle data modeling schema creation and maintenance of datasets.
Optimize and operationalize queries.
Oversee administer and finetune Google Cloud Platform resources.
Provision assets and maintain current architecture.
Manage access control (IAM).
Assist in the creation and enhancement of internal applications aimed at automating key business processes.
Assist with the development of FastAPIbased APIs.
Implement and maintain Cloud Run and Cloud Functions backend microservices.
Assist in deploying ML solutions in collaboration with the Data Science Team
Provide and optimize large datasets tailored for Data Science initiatives
Optimize data transformations by finetuning SQL queries and data pipelines to enhance performance and reduce computational costs.
Manage the deployment of ML models into production environments.
Skills and Qualifications:
MustHave:
Python:
Proficiency in Python programming with experience in libraries commonly used in data engineering.
ObjectOriented Programming (OOP): Experience with OOP principles and design patterns.
Coding Best Practices: Experience with writing idiomatic and maintainable code adhering to PEP8 guidelines.
SQL:
Skilled in SQL including both Data Definition Language (DDL) and Data Manipulation Language (DML).
Version Control:
Familiarity with version control systems preferably Git.
Linux Environment:
Comfortable working in Linuxbased systems utilizing the Windows Subsystem for Linux (WSL) where necessary.
Console: Competency in using commandline interfaces.
NicetoHave:
Apache Airflow:
Experience with orchestration using Apache Airflow.
Cloud Platforms:
Familiarity with Google Cloud Platform or other cloud service providers.
BigQuery:
Handson experience with BigQuery for data warehousing solutions.
Docker:
Basic knowledge of containerization technologies primarily Docker.
DBT (Data Build Tool):
Experience with DBT for analytics engineering and transformation.
Bonus Points:
Industry Experience:
Past experience in the marketing industry is highly desirable.
Marketing Tools:
Familiarity with online marketing tools such as Google Marketing Platform Google Analytics.
We offer:
Work in a global dynamically developing group in the field of marketing communications;
Possibility of development within the dentsu group in Poland and worldwide;
Onboarding training and development programs;
3 additional paid days off Wellness days;
2 additional days for employee volunteering;
Summer Fridays during the holiday season (from June to September on Fridays we finish work 2 hours earlier);
Hybrid work mode depending on the arrangements within the team;
Internal training programs and dentsu University;
A modern and comfortable office in line with the idea of worklifebalance offering facilities such as a gym and fitness room a DAY CARE childrens day care point;
Medicover medical subscription financed by the employer with the possibility of extension with additional services;
Employerfinanced UNUM Life Insurance with the option of expanding with additional packages;
NAIS Cafeteria;
Access to the Mindgram platform;
Cofinancing for a Medicover sport or Multisport sports card (to choose) and many sports activities within interest groups.
Location:
WarsawBrand:
IprospectTime Type:
Full timeContract Type:
PermanentFull-Time