Technical Lead – Power BI & dbt | Hands-on BI Development

SQUARE ONE RESOURCES sp. z o.o.; Warszawa; On-site; PLN 180,000 - 280,000; Full time

Job summary

SQUARE ONE RESOURCES sp. z o.o. poszukuje Technical Leada – Power BI & dbt z praktycznym doświadczeniem, aby dołączyć do wysoko wyspecjalizowanego zespołu BI. Rola łączy rozwój BI z technicznym mentoringiem, przeglądami kodu i automatyzacją procesów.

Będziesz jednym z najbardziej doświadczonych programistów w zespole, aktywnie uczestnicząc w projektowaniu i implementacji rozwiązań BI oraz wspierając innych w trudnych wyzwaniach technicznych.

Qualifications

• Wymagane praktyczne doświadczenie z Power BI, Power BI Service i semantyczne modele danych.
• Dobrze zrozumienie DAX i optymalizacji modelu i raportów Power BI.
• Doświadczenie w dostarczaniu i utrzymaniu produkcyjnych rozwiązań BI.
• Znajomość bezpieczeństwa Power BI, zarządzania dostępem i praktyk wdrożeniowych.
• Umiejętność projektowania dobrze zorganizowanych semantycznych modeli i raportów.
• Silne umiejętności SQL i praktyczne doświadczenie z dbt.
• Doświadczenie z Snowflake lub podobną platformą chmury danych.
• Znajomość modelowania danych wymiarowych i KPI.
• Umiejętność decydowania, gdzie logika powinna być osadzona w dbt/Snowflake vs Power BI.
• Doświadczenie w samodzielnym projektowaniu i wdrażaniu rozwiązań BI.
• Doświadczenie z Git, przeglądem kodu, CI/CD i end-to-end lifecycle.

Responsibilities

• Projektowanie i rozwijanie semantycznych modeli Power BI, raportów i BI rozwiązań.
• Budowa modeli danych w dbt i Snowflake, implementacja logiki biznesowej w odpowiedniej warstwie danych.
• Projektowanie i dostarczanie end-to-end BI od warstwy danych po gotowy produkt BI.
• Optymalizacja modeli danych, zapytań SQL, semantycznych modeli i raportów Power BI.
• Diagnostyka i rozwiązywanie złożonych problemów technicznych i produkcyjnych.
• Zapewnienie, że rozwiązania są skalowalne, utrzymywalne i zgodne z architekturą.
• Wspieranie programistów w rozwiązywaniu problemów technicznych.
• Przegląd kodu, modeli danych i rozwiązań technicznych.
• Doradztwo w podejściach implementacyjnych i decyzjach technicznych.
• Mentoring deweloperów i dzielenie się wiedzą w zespole.
• Ustanawianie i ulepszanie standardów rozwoju i praktyk.
• Identyfikacja obszarów do uproszczeń i optymalizacji.

Skills

Power BI

DAX

SQL

dbt

Snowflake

Git

CI/CD

Python/PowerShell

Tools

Power BI Service

dbt

Snowflake

Git

CI/CD

APIs

Job description

Nasze wymagania:

• Strong hands-on experience with Power BI, Power BI Service, and semantic models.
• Strong understanding of DAX and Power BI model/report optimization.
• Experience delivering and maintaining production-grade Power BI solutions.
• Understanding of Power BI security, access management, and deployment practices.
• Ability to design well-structured semantic models and reporting solutions.
• Very good knowledge of SQL and practical experience with dbt.
• Hands-on experience with Snowflake or a similar cloud data platform.
• Strong understanding of dimensional data modeling, reusable data models, and shared KPI definitions.
• Understanding of how to design and centralize business logic in the data layer.
• Ability to make informed decisions about which logic should reside in dbt/Snowflake versus Power BI.
• Proven ability to independently design and implement BI solutions.
• Experience with Git, code review, CI/CD, and the complete development-to-production lifecycle.
• Practical experience working with APIs and scripting, e.g. Python or PowerShell.
• Strong software engineering mindset and ability to apply development best practices to BI solutions.
• Experience with automation of repetitive development or deployment activities.
• Power BI, dbt, SQL, Snowflake
• Microsoft Fabric, particularly:
• Power BI
• Semantic Models
• Lakehouse / Warehouse
• Direct Lake
• Data Pipelines
• Airflow or similar data orchestration tools
• Liquibase or similar database change-management and deployment tools
• Git and CI/CD
• APIs and scripting technologies
• Practical experience with AI-assisted development and tools supporting software/data developers.
• Understanding of Model Context Protocol (MCP) and its application to integrating AI tools with APIs, data sources, and development workflows.
• Ability to use AI agents in a secure, controlled, and practical way to automate development-related activities.
• Interest in applying AI to improve developer productivity and BI engineering processes
• Ability to create clear, intuitive, and business-oriented Power BI reports and dashboards.
• Good understanding of data visualization principles and dashboard design.
• Ability to translate business requirements into effective analytical products.

Mile widziane:

• Experience automating Power BI deployments and working with Power BI / Microsoft Fabric APIs.
• Experience implementing automated tests for data, models, or BI solutions.
• Experience in media, telecommunications, OTT, or subscription-based products.
• Experience working in large-scale BI environments.
• Experience with modernization or transformation of analytical platforms.
• Experience establishing reusable BI frameworks, standards, or development accelerators.

O projekcie:

We are looking for a Technical Lead – Power BI & dbt with strong hands-on development experience to join a highly technical Business Intelligence team.

The role combines hands-on BI development with technical leadership, code and solution reviews, mentoring, automation, and the continuous improvement of development practices. You will be one of the most experienced developers in the team, actively contributing to the design and implementation of BI solutions while supporting other developers with complex technical challenges.

This is not a traditional people management role. The position is strongly development-oriented and requires someone who enjoys writing code, designing data models, solving technical problems, and improving engineering practices.

The long-term direction of the platform is to centralize shared business logic and KPI definitions in Snowflake/dbt, while keeping Power BI as a well-structured semantic and reporting layer.

You will also collaborate closely with central Data and BI teams to implement shared solutions and standards across multiple markets.

Zakres obowiązków:

• Design and develop Power BI semantic models, reports, dashboards, and BI solutions.
• Build data models in dbt and Snowflake, implementing business logic in the appropriate data layer.
• Design and deliver end-to- end BI solutions, from the data layer through to the final BI product.
• Optimize data models, SQL queries, semantic models, and Power BI reports.
• Troubleshoot and resolve complex technical and production issues.
• Ensure solutions are scalable, maintainable, reusable, and aligned with established architectural standards.
• Support developers in solving complex technical problems.
• Review code, data models, semantic models, and technical solutions.
• Provide guidance on implementation approaches and technical decisions.
• Mentor developers and share knowledge across the team.
• Establish and improve practical development standards and best practices.
• Identify areas requiring simplification, optimization, refactoring, or architectural improvement.
• Act as a technical point of reference for the team without taking on formal people-management responsibilities.
• Automate repetitive activities related to development, testing, deployment, and monitoring.
• Use APIs, scripting, CI/CD, and AI-assisted development tools to improve developer productivity.
• Develop repeatable and controlled processes for delivering BI products.
• Contribute to improving the overall development test deployment production lifecycle.
• Look for opportunities to reduce manual work and improve the reliability of BI delivery processes.
• Implement shared data models, reusable components, and technical standards across multiple markets.
• Adapt centrally developed solutions to local business requirements without duplicating implementations.
• Represent the technical needs of the local team in collaboration with central Data and BI teams.
• Work jointly on resolving cross-team technical and architectural challenges.
• Promote reuse, standardization, and consistency across the BI landscape.