Business Intelligence Developer / Consultant

NECSWS

United Kingdom

Hybrid

GBP 55,000 - 90,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Private Medical Cover funded by NEC
25 days paid holiday
4 x basic salary life assurance
Pension plan with employer contrib.
Flexible benefits
LinkedIn Learning access

Job summary

NEC Software Solutions is seeking a Business Intelligence Developer/Consultant to join the Business Insights team. The role supports NEC Housing BI solutions, delivering Power BI reports, data models and analytics across the product lifecycle.

You will work on data preparation, semantic modelling, security, and deployment across development, test and production environments.

Qualifications

  • Experience delivering Power BI and data solutions in a commercial environment.
  • Strong Power Query and M for complex data preparation and transformation.
  • Extensive SQL skills and relational database experience.
  • Solid understanding of dimensional modelling and star schemas.

Responsibilities

  • Develop end-to-end Power BI solutions from source data to reports and dashboards.
  • Prepare, cleanse and transform data using Power Query and M.
  • Design robust semantic models using dimensional modelling and star schemas.
  • Manage complex relationships including cardinality and bridge tables.
  • Develop advanced DAX measures and business logic for reports.
  • Ensure performance and maintainability of models and reports.

Skills

Power BI
DAX
SQL
Power Query
M language
Dimensional modelling
Star schema
Data warehousing
Data analysis

Education

Bachelor's degree in Computer Science, Data Science, Information Systems or equivalent

Tools

Power BI Service
SQL databases

Job description

Business Intelligence Developer / Consultant
  • Full-time

Come join us and make a difference in the world!

Please note - this role will be remote or hybrid working, subject to the successful applicant's location in line with company policy

Our Business Intelligence Developer/Consultants work as part of the Business Insights team, providing specialist knowledge and expertise in Business Intelligence solutions for the NEC Housing product.

The team is involved throughout the full product lifecycle, including pre-sales activities, customer consultancy and support, product development, implementation and the ongoing development of our Business Intelligence solutions. The role provides an opportunity to work across the full end-to-end lifecycle of Business Intelligence projects, from understanding business and data requirements through to solution design, development, implementation and support.

The Housing Business Intelligence Roadmap covers a broad range of reporting and analytics capabilities. The BI team is responsible for supporting and developing this roadmap, including:

  • Power BI reporting, dashboards and analytics
  • Machine Learning and Data Science
  • Operational and strategic reporting
  • Data Warehouse ETL design and development

A key focus of this role will be the design and development of Power BI solutions. We are looking for someone who can work beyond report visualisation and has strong experience in the more complex technical aspects of Power BI development.

Key responsibilities will include:

  • Developing end-to-end Power BI solutions, from source data through to published reports and dashboards.
  • Preparing, cleansing and transforming data using Power Query and M.
  • Designing robust and reusable semantic models using dimensional modelling and star-schema principles.
  • Designing fact and dimension structures and managing complex data relationships, cardinality and filter behaviour.
  • Developing advanced DAX measures and business logic.
  • Working with complex modelling scenarios, including multiple fact tables, many-to-many relationships and bridge tables.
  • Developing professional, intuitive and accessible Power BI reports and dashboards.
  • Optimising data transformations, semantic models, DAX and reports for performance and maintainability.
  • Working with Import, DirectQuery and composite model approaches where appropriate.
  • Implementing appropriate data and report security, including Row-Level Security.
  • Configuring and supporting Power BI Service, including workspaces, Apps, gateways, data connections and scheduled refresh.
  • Supporting controlled deployment of Power BI solutions across development, test and production environments.
  • Troubleshooting data, modelling, refresh, security and performance issues within production solutions.
  • Producing and maintaining appropriate technical documentation.
  • Working with technical and non-technical stakeholders to understand requirements and translate these into effective Business Intelligence solutions.
  • Supporting customers and internal teams with Business Intelligence consultancy, technical advice and problem resolution.

Qualifications

We are looking for an experienced Business Intelligence professional with a strong technical background and demonstrable experience delivering Power BI and data solutions within a commercial environment.

Essential qualifications and experience

  • Degree-level qualification in Computer Science, Data Science, Information Systems, Software Engineering or another relevant technical or analytical subject, or equivalent relevant professional experience.
  • Previous relevant commercial experience working within Business Intelligence, data, analytics or a closely related technical discipline.
  • Advanced experience with Power Query and M for complex data preparation and transformation.
  • Strong DAX skills, including a good understanding of filter context, evaluation context and DAX performance.
  • Strong SQL skills and experience working with relational databases.
  • Strong understanding of dimensional data modelling, including fact tables, dimensions and star schemas.
  • Experience designing and developing complex Power BI semantic models.
  • Experience managing complex relationships, including cardinality, filter direction, bridge tables and many-to-many scenarios.
  • Experience designing reusable semantic models capable of supporting multiple reports and analytical requirements.
  • Good understanding of Power BI performance optimisation across data preparation, semantic models, DAX and report design.
  • Practical experience with Power BI Service, including workspaces, Apps, gateways, data connections and scheduled refresh.
  • Experience implementing Power BI security, including workspace permissions and Row-Level Security.
  • Experience deploying and supporting Power BI solutions within a production environment.
  • Strong analytical and problem-solving skills, with the ability to diagnose complex data and reporting issues.
  • Ability to communicate technical concepts clearly to both technical and non-technical audiences.

Useful skills and knowledge

Experience or knowledge in any of the following areas would be advantageous:

  • Hands on experience using NEC Housing
  • WhereScape RED Data Warehouse ETL development
  • Oracle SQL and PL/SQL
  • Data Warehouse design and dimensional modelling
  • Jaspersoft Server configuration
  • Microsoft Fabric and related Microsoft data technologies
  • Microsoft Entra ID, service principals and application registrations
  • Power BI REST APIs and automation
  • DAX Studio and Tabular Editor
  • Git, Azure DevOps, deployment pipelines and CI/CD approaches
  • Experience migrating or modernising solutions from established Business Intelligence platforms

We are proud of the benefits we offeremployees of NEC Software Solutions

  • Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost)
  • 25 days paid holiday with the option to buy/ sell
  • 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost)
  • A Group Pension Plan with fantastic employer contributions up to a maximum of 8.5%
  • Afantasticselection offlexible benefits to suit your individual needs
  • We are an employer who cares, we have ainvaluableemployee assistance programme which can help in every area of your life
  • All colleagues get free access to LinkedIn Learning. Over 15000 courses covering a huge breadth of subjects. Learn about what you like, when you like, how you like.

Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required.

All offers are subject to satisfactory vetting and reference checks.

NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities.

Who we are?

We’re NEC Software Solutions (part of global tech giant NEC Corporation). While you read this ad, our software is helping to dispatch ambulances, support families, keep trains on the move, locate missing people and even test the hearing of newborn babies.

Working with us, you’ll be helping our 3,000+ employees push the boundaries of what’s possible and support amazing public services.

We work with governments, hospitals, police forces, housing providers, local authorities and more. We help them pay financial support faster, speed up treatments for patients and respond to emergencies in the right way. The more we do, the more our customers can do for others. And together, we make a world of difference.

We’d love your help. And we’ll support you all the way.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Consultant - Benefits Specialist
Business Consultant - Benefits Specialist

Nec Software Solutions • United Kingdom

Hybrid
GBP 40,000 - 60,000
Private Medical Cover
25 days holiday
Life assurance 4x salary
Customer Success Manager - Housing
Customer Success Manager - Housing

NECSWS • United Kingdom

Hybrid
GBP 55,000 - 90,000
Private medical cover
Holiday entitlement 25 days
Life assurance 4x salary
+2
Customer Success Manager - Housing
Customer Success Manager - Housing

Nec Software Solutions • United Kingdom

Hybrid
GBP 60,000 - 90,000
Private medical cover
Pension plan
Life assurance
+3
Data Analyst
Data Analyst

NEC Software Solutions • City Of London

On-site
GBP 45,000 - 65,000
Private Medical Cover
25 days holiday
Life assurance
+3
Technical Architect
Technical Architect

NECSWS • United Kingdom

Remote
GBP 70,000 - 100,000
Private medical
25 days holiday
Life assurance (4x)
+2
Business Consultant - Council Tax / Business Rates Specialist
Business Consultant - Council Tax / Business Rates Specialist

NEC Corporation • United Kingdom

Hybrid
GBP 45,000 - 65,000
25 days paid holiday
Life assurance 4x basic salary
Flexible benefits
Technical Architect
Technical Architect

NEC Corporation • United Kingdom

Remote
GBP 85,000 - 120,000
Private Medical
Holiday 25 days
Life Assurance
+3
Product Manager - NEC Housing
Product Manager - NEC Housing

NEC Software Solutions • United Kingdom

Hybrid
GBP 60,000 - 90,000
Private Medical Cover
25 days holiday
Life assurance 4x basic salary
+2
Product Proposition Lead
Product Proposition Lead

NECSWS • England

Hybrid
GBP 65,000 - 95,000
Private Medical Cover
25 days paid holiday
Life assurance 4x base salary
+1
Product Proposition Lead
Product Proposition Lead

Nec Software Solutions • United Kingdom

Hybrid
GBP 60,000 - 85,000
Private Medical Cover
25 days paid holiday
Life assurance 4x basic salary
+2