Analytics Engineer (AWS)

TL;DR

Analytics Engineer (AWS/SQL): Designing, building, and maintaining ETL/ELT pipelines and data models to transform raw data into analysis-ready tables with an accent on query optimization and pipeline orchestration. Focus on optimizing Redshift and Athena performance, scaling data workflows via Airflow, and developing robust Tableau dashboards for business stakeholders.

Location: Remote (Kyiv, Ukraine)

Company

hirify.global is a product company specializing in the development of mobile applications.

What you will do

• Design, build, and maintain ETL/ELT pipelines using SQL, Apache Spark (AWS Glue), and Airflow.
• Model and optimize data in Amazon Redshift and query large datasets via Amazon Athena.
• Write advanced SQL to transform raw data into clean, joinable, and analysis-ready tables.
• Build and maintain Tableau dashboards and data sources, ensuring accuracy and performance for business users.
• Partner with marketing, product, and BI stakeholders to translate business questions into robust data models.
• Ensure data quality by implementing monitoring checks and documenting the data warehouse.

Requirements

• Advanced SQL proficiency including window functions, complex joins, and performance tuning.
• Hands-on experience with the AWS data ecosystem (Redshift, Athena).
• Python scripting skills for data processing and automation.
• Experience with Apache Airflow for pipeline orchestration.
• Proven experience building dashboards and data sources in Tableau.
• Solid understanding of data warehousing concepts, such as dimensional modeling and star/snowflake schemas.

Nice to have

• Familiarity with Data Lakehouse concepts and open table formats like Apache Iceberg.
• Experience with dbt for transformation and modeling.
• Experience with mobile app analytics or marketing/attribution data (Meta, Google Ads, TikTok, AppsFlyer).
• Familiarity with CI/CD practices for data pipelines.