Senior Data Engineer / Analyst

About us:

Planner 5D is a global hub for home design, uniting over 90+ million users in 230 territories around our planet (yes, we have 2 users connecting from Antarctica each month!). Our platform simplifies the home renovation process from concept to execution, and this process has never been more straightforward with our cutting-edge software. You don't need to be a professional designer to enhance your home or workspace. We are dedicated to streamlining the design experience, making the customization of dream homes accessible to everyone.

Our cross-platform presence spans Web, iOS, Android, Windows, and MacOS, ensuring seamless synchronization for our users. Planner 5D is more than just software; it's a vibrant community of enthusiastic and product-oriented professionals. From diverse backgrounds, our team collaborates across time zones, fueled by a shared passion to revolutionize the home design market.

We are constantly looking for like-minded talent eager to take ownership and drive innovation within our expanding suite of tools. Join us in shaping the future of home design.

We are seeking a highly skilled and experienced Data Engineer / Analyst to join our growing team. You will play a crucial role in building and maintaining our data infrastructure, performing in-depth analysis of marketing and product performance, and providing actionable insights to drive business decisions. This role requires a strong understanding of data warehousing, ETL processes, and a passion for leveraging data to improve business outcomes.  

Note that this role includes both Data Engineering and Analytics responsibilities.

You will (responsibilities):

•  Design, develop, and maintain robust and scalable data pipelines using Apache Airflow;
• Develop and optimize ETL processes for ingesting data from various sources, including Google Analytics, AppsFlyer, Stripe, Apple Connect, and Google Play;
• Build, maintain and optimize our data warehouse in Google BigQuery;
• Implement data quality checks and monitoring procedures;
• Collaborate with engineering and product teams to integrate data sources and improve data accessibility;
• Integrate AI services (OpenAI, Claude, Gemini) into the data engineering and analysis pipelines;
• Develop and maintain data models using dbt-like tools;
• Participate in data analysis tasks to identify areas for improvement and growth opportunities;
• Develop interactive parametric dashboards using Google Data Studio and Metabase to visualize key performance indicators(KPIs) and insights;
• Identify trends and patterns in data to support strategic decision-making.

Background Requirements:

• Strong proficiency in SQL and experience with BigQuery;
• Experience with Apache Airflow for workflow orchestration;
• Experience with DBT/Google Dataform for model processing;
• Experience with dbt (data build tool) for data modeling and transformation;
• Experience with data visualization tools such as Google Data Studio;
• Strong understanding of web and mobile app marketing analytics, including attribution modeling;
• Experience with Google Analytics and AppsFlyer;
• Excellent communication, presentation, and collaboration skills;
• Experience with Stripe, Apple Connect, and Google Play integrations is a significant plus;
• Experience with cloud platforms (preferably Google Cloud Platform) is a plus.

We do not provide visa sponsorship in EU.

What we offer:

- Great work environment that balances freedom and responsibility

- Our team is made up of friendly and passionate enthusiasts who are eager to help and share their knowledge

- We believe in work-life balance, so you'll receive around 30+ days of paid holidays per year

- Company computer equipment by request

- Education courses for our team members, and we're willing to allocate funds toward your training expenses

- English classes on our corporate platform

- Offline company events in Lithuania and online team-building

- Unlimited free Planner5D subscriptions