Strong Middle Data Engineer

In this role, you will build reliable data pipelines, design clear domain models, and optimize our data warehouse. We value a practical, problem-solving mindset - someone who easily navigates ambiguous requirements, brings structure to complex tasks, and takes ownership of their solutions.

In this role, you will:

• Build and support Airflow pipelines to ingest data from third-party sources (APIs, payment providers, ad networks) with retries, backfills, and quality checks.
• Work directly with Analytics Engineers and product teams to translate ambiguous business requests into reliable data models.
• Design and implement fact and dimension tables in dbt using dimensional modeling principles.
• Migrate existing SQL transformations into dbt models, adding tests and documentation.
• Refactor the current dbt project: improve layer structure, standardize naming conventions, and set up CI checks.
• Optimize slow or costly warehouse queries and materializations.
• Evaluate table formats and set up initial ingestion flows for our Data Lakehouse prototype., * We are a Ukrainian company, and we stand with Ukraine against the russian aggression

• We maintain workplaces for the mobilized Macpawians and provide financial support to colleagues or their families affected by the war. Here, you can also read about the MacPaw Foundation, which intends to help save the lives of Ukrainian defenders and provide relief to as many civilians as possible.

• We are committed to our veterans

• Our Veteran Career and Empowerment Program is designed to ensure our veterans and active military personnel receive the recognition, support, and opportunities they deserve.

• Hybrid work model

• Whether to work remotely or at the hub is entirely up to you. If you decide to mix it, our Kyiv office, which works as a coworking space, is open around the clock. The office is supplied with UPS and Starlink for an uninterrupted work process.

• Your health always comes first

• We guarantee medical insurance starting on your first working month. For those abroad, you can receive a yearly Medical insurance allowance as compensation for managing your medical expenses.

• Flexible working hours

• You can choose a schedule that is comfortable for you. No one here tracks your clock in/out because MacPaw is built on trust and cooperation.

• Space to grow both professionally and personally

• Education opportunities to grow both hard and soft skills, annual development reviews, and internal community.

• Teams we are proud of

• We build honest, transparent, and reliable relationships within teams. Every Macpawian can improve processes and implement their ideas. We encourage open and constructive feedback and provide training for Macpawians on giving and receiving feedback.

• Office designed for people (and pets)

• Our office has it all: a spacious workplace with enough room for sitting up, lying down, and running around; a gym for recreation; cozy kitchens; a sleeping/meditation room; and a terrace with a view where we throw summer parties. Also, we have two cats living in the office.

• Time-off policy that covers life's needs

• Convenient personal time-off policy to help you take care of essential matters in your personal life, and parental leaves. On top of all that, sabbaticals are open after 5 years of being with MacPaw.

• Join social initiatives with MacPawCares

• MacPaw participates in numerous humanitarian aid and charity projects across many fields, and you are welcome to jump in to make the world a better place.

• We're an equal-opportunity employer. Here is a safe place for applicants of all backgrounds

• We are hiring talented humans. Meaning with all our variety of backgrounds and identities, including service members and veterans, women, members of the LGBTQIA+ community, individuals with disabilities, and other often underrepresented groups. MacPaw does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
• Some benefits are under development, and new adjustments are possible.

• Strong proficiency in Python and advanced SQL, including complex transformations, window functions, and query optimization.
• Proven experience building and orchestrating ELT/ETL pipelines using Airflow.
• Solid experience with dbt for data modeling, testing, documentation, and managing project structure.
• Good understanding of dimensional modeling concepts, Kimball methodology, star/snowflake schemas, and SCDs.
• Practical experience working with cloud data warehouses (preferably BigQuery, Redshift, or Snowflake) and Cloud Storage.
• Hands-on experience with Docker, Git workflows, and basic cloud/containerized environments.
• A problem-solving mindset with the ability to handle ambiguous requirements, communicate effectively with stakeholders, and use AI/LLM tools (like Claude) to speed up delivery.
• At least an Intermediate level of English and fluent Ukrainian., * Experience with Change Data Capture (CDC) tools and patterns (e.g., Debezium).
• Background in building and optimizing large-scale data processing jobs with PySpark.
• Experience with real-time data processing using message brokers like Kafka or RabbitMQ.
• Experience with stream processing frameworks (Flink, Kafka Streams).

This step may include additional interviews and/or test tasks to figure out whether your skills match the requirements for the role.

• 03

MacPaw is a software company that develops and distributes software for macOS and iOS. Today, we have 20 million active users across all our products, and every 5th Mac on Earth has our product installed. At MacPaw, we believe humans and technology can reach their greatest potential together. We gather open-minded people who support each other and aspire to change the world around us, making millions of people's lives easier with technology.