> Markdown version of [/jobs/ext/1411592-strong-middle-data-engineer](https://www.wearedevelopers.com/jobs/ext/1411592-strong-middle-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Strong Middle Data Engineer - **Company:** MAC PAWS FOUNDATION OF JUPITER INC. - **Location:** United States (Remote available) - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Airflow, Data Analysis, BASIC (Programming Language), Big Data, BigQuery, Cloud Database, Cloud Storage, Extract Transform Load (ETL), Dimensional Modeling, Python (Programming Language), Message Broker, Query Optimization, RabbitMQ, SQL Databases, Sql Optimization, Large Language Models, Snowflake, Change Data Capture, Containerization, Pyspark, Git Flow, Debezium, Apache Flink, Apache Kafka, Data Lakehouse, Stream Processing, Code Restructuring, Docker - **Published:** July 23, 2026 - **Apply:** https://macpaw.com/careers/middle_data_engineer ## About the Role * 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). ## Description 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. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Docker Compose: Rediscovered](https://www.wearedevelopers.com/videos/1978-docker-compose-rediscovered) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)