Senior Database Engineer

Our client is a US-based company that provides In-flight Internet and entertainment services to aircraft across the globe, serving commercial aircrafts. At this moment we cooperate on Business Intelligence, Data Analysis, Data Science  and BigData directions and look for talents who can contribute to the complex data management and analysis projects.

About the Role:
We are looking for a skilled Database Engineer with a strong background in Python, dbt, PostgreSQL, and ETL processes. In this role, you will be responsible for designing, developing, and optimizing data pipelines, ensuring data integrity, and supporting our data infrastructure. Experience with AWS, Airflow, and Snowflake is a plus.

Key Responsibilities:

• Design, develop, and maintain efficient ETL pipelines.
• Work with PostgreSQL to ensure optimal database performance and scalability.
• Utilize dbt for data modeling, transformations, and documentation.
• Optimize queries and data processing workflows to enhance system efficiency.
• Collaborate with cross-functional teams to understand data needs and implement solutions.
• Ensure data quality, integrity, and compliance with best practices.
• Work with cloud-based data solutions, primarily AWS (or learn on the job).
• Manage and schedule workflows using Apache Airflow (or be willing to gain expertise).
• Support and troubleshoot database and ETL-related issues.

Requirements:

• Proficiency in Python for data engineering tasks.
• Strong experience with dbt 
• Expertise in PostgreSQL database management, performance tuning, and query optimization.
• Experience with ETL/ELT processes, data ingestion, and transformation best practices.
• Familiarity with cloud-based solutions like AWS is a plus.
• Knowledge of Apache Airflow and Snowflake is advantageous, but willingness to learn is sufficient.
• Strong problem-solving skills and ability to work independently and in a team.
• Excellent communication and documentation skills.