At a Glance
- Tasks: Build high-quality analytics solutions using Microsoft Fabric and Power BI to solve client problems.
- Company: Join Capgemini's innovative AI and Analytics team in a collaborative environment.
- Benefits: Enjoy hybrid working, learning opportunities, and a supportive work-life balance.
- Other info: Great career progression opportunities with access to coaching and certifications.
- Why this job: Make a real impact by turning data into actionable insights for clients.
- Qualifications: Hands-on experience with Power BI and a passion for analytics.
The predicted salary is between 40500 - 49500 £ per year.
Who You'll Be Working With
You will join Capgemini's AI and Analytics team within the Insights and Data Global Business Unit.
You will work with visualisation specialists, data engineers, data scientists, business analysts and solution architects to solve client problems using modern data and analytics services.
Role purpose
Build high-quality analytics solutions using Microsoft Fabric and Power BI, translating business needs into trusted data models, reports and insights.
Work as part of a client delivery team, with support from senior consultants and architects.
Who You'll Be Working With
You will join Capgemini's AI and Analytics team within the Insights and Data Global Business Unit.
You will work with visualisation specialists, data engineers, data scientists, business analysts and solution architects to solve client problems using modern data and analytics services.
Role purpose
Build high-quality analytics solutions using Microsoft Fabric and Power BI, translating business needs into trusted data models, reports and insights.
Work as part of a client delivery team, with support from senior consultants and architects.
Please Note
Security clearance: To be successfully appointed, you must be eligible to obtain Security Check (SC) clearance.
This normally requires continuous UK residency for the previous five years, alongside other criteria.
Some assignments may be restricted to sole UK nationals for security reasons.
The Focus Of Your Role
This is a hands-on consulting role for someone developing their career across Microsoft Fabric and Power BI.
You will help clients turn data into clear, accessible and actionable insight.
You will contribute to the design, build, test and deployment of analytics solutions, while learning how enterprise security, governance and delivery standards are applied in practice.
The role is broader than report development alone. Depending on the engagement, you may work across:
- Microsoft Power BI reports, dashboards, semantic models and apps
- Microsoft Fabric lakehouses, warehouses, data pipelines and dataflows
- DAX, Power Query and dimensional data modelling
- Data quality, security, governance and deployment controls
- Requirements discovery, prototyping, testing and user adoption
- Monitoring, support, troubleshooting and continuous improvement
Key Responsibilities
- Work with client stakeholders and delivery colleagues to understand business questions, user needs, data sources and acceptance criteria.
- Build and enhance Power BI reports, dashboards, semantic models and KPI scorecards using appropriate visualisation and accessibility practices.
- Develop data preparation and transformation logic using Power Query, Dataflows Gen2, SQL and, where appropriate, Fabric pipelines or notebooks.
- Create clear, maintainable DAX measures and dimensional models that support accurate and performant analysis.
- Contribute to the configuration and use of Fabric workspaces, deployment pipelines, source control and release processes.
- Apply agreed security controls, including workspace and app access, row-level security and sensitivity or endorsement settings.
- Test solutions, investigate defects and performance issues, and produce concise technical and user documentation.
- Participate in agile ceremonies, estimation, peer reviews, demonstrations and knowledge sharing.
- Support proposals, demonstrations, accelerators and reusable assets for the wider AI & Analytics practice.
- Develop your consulting capability by communicating clearly, managing commitments and seeking feedback from clients and colleagues.
- What You'll Bring
You will combine practical analytics skills with curiosity, structured problem-solving and an interest in helping clients make better decisions.
You do not need to be an solutions architect, but you should understand how your work fits within a governed data and analytics solution.
Essential Skills And Experience
- Hands-on experience building Power BI reports and dashboards for business users.
- Working knowledge of DAX, Power Query and data modelling, including facts, dimensions and relationships.
- Experience connecting to, preparing and validating data from common sources such as SQL databases, files, APIs or cloud platforms.
- Understanding of Power BI Service concepts, including workspaces, apps, refresh, gateways, permissions and deployment.
- Awareness and experience of Microsoft Fabric capabilities such as One Lake, Lakehouse, Warehouse, Data Factory and semantic models, with practical exposure to at least one area.
- Ability to translate requirements into user stories, prototypes or working analytics outputs.
- Good analytical, written and verbal communication skills, with the confidence to work collaboratively in a client-facing team.
- Commitment to inclusive design, accessibility, data quality and secure handling of client information.
Desirable Skills And Experience
- Experience with SQL, Azure data services, Databricks, Microsoft Purview, Power Platform or other cloud data platforms.
- Exposure to version control and CI/CD using Git, Azure Dev Ops or Fabric deployment pipelines.
- Awareness of capacity, licensing, performance optimisation and governance considerations in Power BI or Fabric.
- Experience working in agile delivery and producing documentation, test evidence or training materials.
- A relevant Microsoft certification, or willingness to work towards one, such as PL-300 or DP-600.
- Development and progression
This Grade B role is expected to deliver defined work packages with appropriate guidance, progressively taking greater ownership as experience grows.
You will have access to learning, certification and coaching, with opportunities to develop towards senior consultant, analytics lead or solution architecture pathways.
Additional Info
Hybrid working: Your working location will vary according to the role, client needs and business requirements, with a blend of Capgemini offices, client sites and home working.
The role is not expected to be home-based 100% of the time.
Pre-employment checks: Checks may include identity, nationality or immigration status, three years of employment history and an unspent criminal record check through the Disclosure and Barring Service.
What We'll Offer You
You will be supported to maintain a positive work-life balance and to build your career through Capgemini's learning-for-life culture.
This includes practical delivery experience, coaching, professional communities, internal learning and access to external certification pathways.
Why we're different
At Capgemini, we help organisations become more agile, competitive and successful through tailored technology and data solutions.
Our work combines technical quality with collaboration, inclusion and a close understanding of client goals.
We value diversity of thought and the different experiences people bring to our teams.
Fabric / Power BI Analytics Consultant in Manchester employer: Capgemini
Capgemini is an excellent employer, offering a dynamic work culture that fosters collaboration and innovation in the heart of London. With a hybrid working model, employees enjoy the flexibility of blending office, client site, and home working, while also benefiting from extensive growth opportunities and professional development within the Capital Markets sector. Join us to be part of a team that values governance excellence and empowers you to make a meaningful impact in complex programme environments.
StudySmarter Expert Advice🤫
We think this is how you could land Fabric / Power BI Analytics Consultant in Manchester
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Capgemini!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Fabric / Power BI Analytics Consultant at Capgemini.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Capgemini.
✨Apply Directly through Our Website
When you find a suitable opening like Fabric / Power BI Analytics Consultant at Capgemini, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Fabric / Power BI Analytics Consultant in Manchester
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Capgemini, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Capgemini. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Capgemini
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Capgemini!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.