Consulting Senior Manager - PowerBI Solutions Architect

Cognizant; Greater London; On-site; GBP 90,000 - 120,000; Full time

Benefits offered by this job

Wellbeing programmes

Job summary

Cognizant Consulting in London is seeking a Power BI Solution Architect to define the end-to-end architecture for enterprise BI and management information applications. You will collaborate with the BI team and clients to translate reporting needs into scalable technical solutions.

In this role you will design semantic and data models, architect Power BI integrations with Azure or AWS, establish governance and security controls, and mentor report developers and BI engineers, while enabling CI/CD

Qualifications

• At least five years of BI or data architecture experience with enterprise-scale Power BI.
• Expert knowledge of Power BI, DAX, Power Query and semantic/ dimensional modelling.
• Hands-on experience with Power BI Service, Premium or Fabric capacity and cloud integration (Azure/AWS).
• Strong understanding of row-level security, governance, data protection and BI release practices.

Responsibilities

• Own end-to-end architecture for Power BI-based BI/MI applications.
• Design governed semantic and data models and standards for datasets, dataflows and reports.
• Architect integrations between Power BI and Azure or AWS data platforms and define deployment pipelines.
• Establish secure platform controls and monitor usage analytics and cost.

Skills

Power BI

DAX

Power Query

Semantic modelling

Dimensional modelling

SQL

Stakeholder communication

Education

PL-300 certification

Tools

Power BI Service

Microsoft Fabric

Azure

AWS

Gateways

Deployment pipelines

Job description

About Cognizant Consulting

Cognizant Consulting is more than Cognizant’s consulting practice. We’re a global community of 5,000+ experts dedicated to helping clients reimagine their business. Blending our deep industry and technology advisory capability, we create innovative business solutions for Fortune 500 clients. And now, we’re looking for our next colleague who’ll join us in shaping the future of business. Could it be you?

About the role

As a Power BI Solution Architect, you will make an impact by defining the end-to-end architecture for enterprise business intelligence and management information applications. You will be a valued member of the BI / MI team and work collaboratively with the Cognizant Engagement Lead, report developers, BI engineers, business stakeholders and clients.

In this role, you will:

• Own the end-to-end architecture for Power BI-based BI and management information applications, translating reporting needs into scalable technical solutions.
• Design governed semantic and data models using star-schema principles, DAX and Power Query, and define standards for datasets, dataflows, workspaces and report design.
• Architect integrations between Power BI and Azure or AWS data platforms, including capacity, gateway and deployment pipeline strategies.
• Establish secure, compliant platform controls covering row-level security, workspace access, sensitivity labels, monitoring, usage analytics and cost optimisation.
• Improve platform performance and delivery quality by optimising refreshes, dataset size and query efficiency, enabling CI/CD, and mentoring report developers and BI engineers.

Work model

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position based in London, with work undertaken from a client or Cognizant office and remotely. Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programmes.

What you must have to be considered

• At least five years of business intelligence or data architecture experience, including at least three years delivering Power BI at enterprise scale.
• Expert knowledge of Power BI, DAX, Power Query (M), semantic modelling and dimensional modelling, supported by strong SQL capability.
• Hands‑on experience with Power BI Service, Premium or Microsoft Fabric capacity, gateways, deployment pipelines and cloud data‑platform integration across Azure or AWS.
• Strong understanding of row‑level security, tenant governance, access controls, data protection and enterprise BI release practices.
• Excellent stakeholder communication skills, with the ability to explain complex architecture clearly, influence technical decisions and support delivery teams.

These will help you succeed

• Experience with Microsoft Fabric or Azure Synapse.
• Microsoft Power BI Data Analyst certification (PL-300) or an equivalent credential.
• Experience delivering solutions in regulated or public‑sector environments.
• A background in enterprise management information, reporting modernization or migration programmes.
• A strategic, forward‑looking and proactive approach to identifying data‑quality, performance and governance risks.

Security Clearance:

SC Clearance required or eligibility to obtain clearance.