At a Glance
- Tasks: Design and deliver end-to-end Power BI solutions for impactful public services.
- Company: Join a forward-thinking team dedicated to data-driven decision making.
- Benefits: Enjoy private medical cover, 25 days holiday, and flexible benefits.
- Other info: Collaborative environment with opportunities for professional growth and development.
- Why this job: Shape BI solutions that make a real difference in customer outcomes.
- Qualifications: Strong Power BI, DAX, and SQL skills required; degree or equivalent experience preferred.
The predicted salary is between 49500 - 60500 £ per year.
Overview
In this role you will design and deliver end-to-end Power BI BI solutions for the NEC Housing product, spanning data preparation, semantic modeling, and reporting.
You will work within the Business Insights team across the full lifecycle from pre-sales to support, contributing to the BI roadmap and data-driven decision making.
You will tackle complex modeling, optimise performance, and ensure secure, scalable deployments.
This is a chance to shape BI solutions that support public services and customer outcomes at scale.
- Pay / Benefits
- Private Medical Cover
- 25 days paid holiday
- life assurance
- Group Pension Plan with employer contributions
- flexible benefits
- employee assistance programme
Responsibilities
- Develop end-to-end Power BI solutions from source data to published reports and dashboards
- Prepare, cleanse and transform data using Power Query and M
- Design robust semantic models using dimensional modelling and star schemas
- Model complex data relationships with fact/dimension structures, cardinality and filters
- Create advanced DAX measures and business logic
- Handle multi-fact, many-to-many, and bridge table scenarios in models
- Develop professional, accessible Power BI reports and dashboards
- Optimise transformations, models, DAX and reports for performance and maintainability
- Work with Import, Direct Query and composite models
- Implement data and report security including Row-Level Security
- Configure and support Power BI Service (workspaces, Apps, gateways, data connections, scheduled refresh)
- Support controlled deployment across development, test and production environments
- Troubleshoot data, modelling, refresh, security and performance issues
- Produce and maintain technical documentation
- Collaborate with technical and non-technical stakeholders to translate requirements into BI solutions
- Provide BI consultancy, technical advice and problem resolution to customers and internal teams
- Key requirements
- Extensive experience delivering Power BI and data solutions in a commercial setting
- Degree-level qualification or equivalent professional experience
- Strong Power BI experience with Power Query and M for data preparation
- Advanced DAX skills with understanding of filter/evaluation context and performance
- Strong SQL skills with relational databases
- Knowledge of dimensional data modelling (fact/dimensions, star schemas)
- Experience designing complex Power BI semantic models
- Experience managing complex relationships (cardinality, filter direction, bridge tables, many-to-many)
- Ability to create reusable semantic models supporting multiple reports
- Performance optimization across data prep, models, DAX and reports
- Practical Power BI Service experience (workspaces, Apps, gateways, data connections, refresh)
- Experience implementing Power BI security (workspace permissions, RLS)
- Experience deploying and supporting BI solutions in production
- Strong analytical and problem-solving skills
- Clear communication of technical concepts to diverse audiences
- strong communication
- problem-solving
- ability to translate technical concepts for non-technical stakeholders
- Power BI
- Power Query
- M
Business Intelligence Developer / Consultant employer: NEC Software Solutions
NEC Software Solutions is an exceptional employer that prioritises inclusivity and impact in its work culture. With a strong focus on employee growth, you will have the opportunity to mentor colleagues and shape practice standards while working remotely in a collaborative environment. The company fosters a balance of autonomy and leadership, making it an ideal place for those looking to make meaningful contributions to service design.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer / Consultant
✨Get to Grips with Data Visualisation Tools
If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.
✨Join Local Business Intelligence Meetups
Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like NEC Software Solutions!
✨Engage with Online BI Communities
Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.
✨Leverage Your University’s Career Support
If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!
We think you need these skills to ace Business Intelligence Developer / Consultant
Some tips for your application 🫡
Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.
Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.
Tailor Your Documents for Us:When applying for a full-time role at NEC Software Solutions, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!
Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.
How to prepare for a job interview at NEC Software Solutions
✨Show off your analytical skills
In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!
✨Practice your technical know-how
Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.
✨Portfolio of Projects
Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.
✨Know their business model
Get familiar with NEC Software Solutions’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.