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

Our requirements

• 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.

Optional

• 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.

Your responsibilities

• 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.

About the project

This is how we organize our work

This is how we work on a project

• Continuous Deployment
• Continuous Integration

SQUARE ONE RESOURCES sp. z o.o.