BI Engineer at Northgate Information Solutions in Hybrid, London, gb

Company Description

Come join us and make a difference in the world!

Discover more at www.necsws.com

Job Description

We’re looking for an experienced Data Analyst with strong Power BI development capability to join our team and help deliver high-quality reporting and analytics within our software products.

You’ll work closely with stakeholders across the business to translate requirements into robust reporting solutions, assess available datasets, and build accurate, scalable, and visually effective reports in Power BI. The role requires someone who can work across the full reporting lifecycle: understanding business requirements, shaping and validating data, developing semantic models, implementing complex calculations, and ensuring outputs are accurate, secure, and fit for use.

This role is well suited to someone with strong hands-on Power BI expertise who can combine analytical thinking, data modelling, SQL, governance awareness, and excellent attention to detail.

Accuracy, consistency, data quality, and strong QA discipline are essential, as reports and datasets will support business-critical decision-making and user-facing product functionality.

Key responsibilities

• Build and enhance Power BI reports and dashboards in line with agreed business requirements, wireframes, reporting definitions, and user needs.
• Design, build, and maintain Power BI datasets / semantic models for enterprise reporting and analytics use cases.
• Translate business requirements into clear reporting logic, clarifying metric definitions, filters, calculations, data assumptions, and access requirements with stakeholders.
• Review available datasets and determine the best approach to support reporting needs, including:
  • Creating new datasets or semantic models where required
  • Transforming and cleansing data using Power Query (M)
  • Working with curated, warehouse, lakehouse, or reporting-ready data layers, such as a Silver layer or equivalent
  • Building clean, reusable, and scalable data models suitable for both governed reporting and self-service analytics
• Develop and maintain complex DAX measures, including KPI calculations, time intelligence, segmentation, exception logic, and multi-table calculations.
• Use SQL to interrogate structured data sources, including relational databases, and amend queries to ensure datasets are fit for reporting purposes.
• Ensure datasets are fully consumable by report builders and users, with well-structured schemas, clear relationships, intuitive measures, and a strong usability focus.
• Implement and maintain Row-Level Security (RLS) to support role-based data access.
• Configure and manage secure access to datasets and reports, including workspace roles, permissions, sharing models, and governance controls.
• Apply strong data governance principles, including data classification, lineage, access control, and appropriate handling of sensitive data.
• Perform robust QA and validation of reports and datasets, including reconciliation to source data, metric checks, edge-case testing, and consistency checks across visuals, pages, and semantic models.
• Collaborate with product, engineering, data, and business stakeholders to ensure reports work effectively within a Power BI Embedded or product-based reporting environment.
• Document assumptions, measure logic, dataset structures, data transformations, access controls, and QA outcomes to support maintainability and future development.
• Contribute to ongoing improvements in reporting standards, data quality, semantic model design, governance, and analytical best practice.

Qualifications

Required skills and experience

• Current SC clearance, or eligibility to obtain SC clearance.
• Strong hands-on Power BI experience, including report development, data modelling, DAX, Power Query, and performance optimisation.
• Proven experience building enterprise Power BI datasets and semantic models.
• Advanced DAX capability, including complex measures, KPI development, and calculation validation.
• Strong understanding of dimensional data modelling, relationships, data grain, and scalable semantic model design.
• Experience creating governed, reusable datasets that support reporting and self-service analytics.
• Strong SQL skills, with experience querying and analysing data from relational databases.
• Experience implementing Row-Level Security (RLS) and managing secure access and permissions within Power BI.
• Strong understanding of data governance, data quality, lineage, and access control principles.
• Experience validating and reconciling data to ensure accurate and reliable reporting.
• Ability to translate business requirements into effective reporting and analytical solutions.
• Strong stakeholder engagement skills, with the ability to gather requirements, challenge assumptions, and influence outcomes.
• Excellent attention to detail and commitment to report QA, documentation, and data accuracy.
• Ability to work independently and collaboratively within cross-functional teams.

Nice to have

• Experience working with data warehouses, lakehouses, or curated reporting layers (e.g. Silver layer architecture).
• Experience configuring and governing Power BI workspaces, sharing models, and enterprise reporting environments.
• Experience working within secure, regulated, or highly governed data environments.
• Knowledge of Power BI governance, best practice standards, and enterprise reporting frameworks.
• Experience collaborating with product, engineering, and data teams in agile delivery environments.

Additional Information

We pride ourselves in offering an excellent benefits package, including an above average pension scheme. When you join the team at NEC Software Solutions, you are provided with the following:

• 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 (FTE)
• 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%
• A selection of flexible benefits to suit your individual needs
• 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.

OTHER INFORMATION

• 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, references and occupational health checks.
• This role requires Security Check (SC) clearance. Candidates must either hold current SC clearance, or be eligible to obtain SC clearance.

NEC Software Solutions is an equal opportunities employer, welcoming applications from all communities. If you require any reasonable adjustments or have specific accessibility needs during the recruitment or interview process, please feel free to share these with us. We are committed to ensuring an inclusive and accommodating experience for all candidates.

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.

At NEC Digital Studio, we believe in design practices that make the world more human.

NEC Digital Studio was created to put people at the centre of services, positively changing how they experience the world. Everything we design, build and maintain is made for life. Our mission is to empower organisations to be more effective, inclusive and sustainable, through tools, systems and experiences that are intelligent, integrated and intuitive for all.​

As a people-first digital studio, we are designing and developing evidence-led solutions at scale to transform the services used by everyone, every day.​

We specialise in working with seldom heard voices and diverse user groups. We practice participatory co-design and ethical research. Our teams are experts in accessibility and digital inclusion

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

Discover more at NEC Digital Studio | Made for Life (necsws.com)