Python BI Engineer (dbt/SQL)

We are looking for a BI Engineer / Analytics Engineer to join a data-driven project and help build reliable, well-documented analytics datasets for reporting, business intelligence, and decision-making. The role is a good fit for someone with strong SQL skills, hands-on dbt experience, and the ability to work with data pipelines, semi-structured data, and BI stakeholders.

Responsibilities

• Design, build, and maintain ELT/ETL pipelines and curated datasets for analytics and reporting.
• Develop and maintain dbt projects, including models, sources, tests, documentation, snapshots, and exposures where applicable.
• Write efficient and maintainable SQL transformations.
• Optimize data warehouse performance and cost.
• Use Python for data processing, automation, API integrations, file handling, and orchestration tasks when needed.
• Work with JSON and semi-structured data, including parsing, flattening, and modeling for analytics use cases.
• Implement data quality practices using dbt tests, audits, monitoring, and alerting.
• Collaborate with analysts, BI developers, and business stakeholders to define canonical metrics, data contracts, and reporting logic.
• Create clear technical documentation and support smooth handoffs.

Requirements

• Strong experience with SQL: joins, CTEs, window functions, performance tuning, and incremental data patterns.
• Previous experience with dbt.
• Understanding of dbt project structure, models, sources, tests, macros, documentation, and environments.
• Experience with Python for writing maintainable scripts or modules.
• Experience working with APIs, files, and data processing tasks.
• Practical experience with JSON / semi-structured data.
• Familiarity with Git and pull request-based workflows.
• Understanding of data quality, testing, monitoring, and incident response practices.
• Ability to communicate clearly with technical and non-technical stakeholders.
• Strong ownership mindset and attention to detail.

• Spoken English: Upper-Intermediate or higher, comfortable participating in meetings, clarifying requirements, discussing technical solutions, and presenting progress to the client.

   

Nice to Have

• Experience with Snowflake.
• Understanding of Snowflake warehouses, roles and permissions, clustering/partitioning concepts, tasks, streams, or Snowpark.
• Experience with orchestration tools such as Airflow, Dagster, Prefect, dbt Cloud jobs, or similar.
• Experience with data observability and monitoring tools.
• Knowledge of dimensional modeling and analytics engineering best practices.
• Experience supporting BI tools, especially Power BI datasets, semantic models, or reporting layers.
• Experience working directly with international clients.

What You’ll Do

• You will work on building and improving the analytics engineering layer for a data platform. The main focus will be transforming raw data into clean, reliable, tested, and documented datasets used by analysts, dashboards, and business stakeholders.

We Offer

• Competitive compensation, aligned with candidate's skills and experience.
• Remote-first environment with flexible hours, with core collaboration in European time zones.
• Corporate equipment: MacBook Pro for candidates based in Ukraine.
• Established development practices, cutting-edge technology stack with complex tasks and global impact.
• Friendly, supportive team and a value-driven culture.
• Paid vacation and sick leave.