Senior Data & Analytics Consultant (Power BI)

About Us

Formula5 is a Microsoft consulting partner that takes on the hardest data and technology challenges in regulated industries - healthcare, life sciences, financial services, and energy. We hire selectively, deliver excellence, and give our people real ownership over the work they do. Our Data & AI practice is growing fast, and we need people who can lead from every seat.

The Opportunity

This is first and foremost a Power BI delivery role. You'll spend the majority of your time - 60 to 70% - hands-on building dashboards, reports, and semantic models for clients. The difference is that we also need you to think like an architect. You'll set the analytical direction for engagements, make design decisions that shape how data flows from Snowflake into Power BI, and ensure what you build is scalable, performant, and right - not just pretty.

We're hiring across multiple levels for this position. At the senior end, you lead architecture and delivery simultaneously. At the mid-level, you're a strong builder who's growing into that architectural mindset. Read on - if you see yourself in either profile, we want to talk.

What You'll Do

• Build Power BI reports and dashboards - this is the core of the role. You'll deliver polished, interactive analytics solutions that stakeholders actually use to make decisions

• Design and maintain performant semantic models that serve as the analytical backbone for client organizations

• Write and optimize SQL as a core part of your daily work - querying Snowflake, shaping data, and troubleshooting performance issues

• Collaborate directly with business stakeholders to translate ambiguous requirements into concrete, scalable reporting solutions

• Own data quality from source to visualization - you don't just consume data, you make sure it's right

• Set the architecture for the reporting layer - data modeling patterns, security design, deployment strategy, and version control - so the solutions you deliver hold up over time

• Work closely with data engineers on pipeline and warehouse design, ensuring that what's built upstream serves the reporting layer effectively

• Stay sharp on Power BI releases and bring new capabilities into client work before they become mainstream

Requirements

Essential

• 5+ years of hands-on experience in Power BI development, business intelligence, or data analytics

• Strong proficiency in DAX and semantic data modeling

• Strong SQL skills - you write, optimize, and troubleshoot queries daily. This is a SQL-heavy role

• Familiarity with data warehousing concepts, medallion architecture, star/snowflake schemas, and ETL/ELT patterns

• Experience working directly with business stakeholders to gather requirements, challenge assumptions, and deliver solutions

• Strong communication skills in English - you'll work with US-based clients daily

• Polish language proficiency and residence in Poland - you'll collaborate with a Polish-speaking team and need to communicate fluently in both Polish and English

• Comfortable working afternoon/evening hours to overlap with US time zones

Strongly Preferred

• Experience with Snowflake as a data source or core component of the data platform (yet it is not a must)

• Working knowledge of PBIP/PBIR and Git-based version control for BI assets

• Python skills - at least at an intuitive, working level for data transformation or automation tasks

• Understanding of DevOps practices applied to BI development

• Experience with deployment pipelines and workspace management in Power BI

• Familiarity with query performance analysis and optimization techniques 

Nice to Have

• Experience with Microsoft Fabric (Lakehouses, Data Pipelines, Semantic Models, Notebooks)

• Hands-on work with Azure cloud services and data integration tools

• Knowledge of data mesh principles or modern data architecture patterns

• Background in business analysis (BPMN, process modeling, requirements engineering)

• Experience designing data platform architectures (not just consuming them)

Why Join Formula5

We’re not just another Microsoft Partner.We build relationships based on trust, expertise, and growth - both for our clients and our people.If you want to join a global, collaborative team and make a real impact in the identity space - we’d love to meet you.