Business Intelligence Engineer

NEC Software Solutions; Greater London; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Private Medical Healthcare

Pension Scheme

Life Assurance

25 Days Holiday

Wellness

Discounts (Retail & Lifestyle)

Flexible Working

Continued Learning

CycleScheme

Job summary

NEC Software Solutions seeks an experienced Data Analyst to design, build and maintain enterprise Power BI reports and datasets. You will translate stakeholder requirements into scalable, governance-forward reporting solutions, leveraging SQL, DAX, and Power Query within secure data environments.

Collaboration with product and engineering teams is essential. Strong data modelling, QA discipline, and experience with row-level security are required.

Qualifications

• Strong hands-on Power BI expertise with end-to-end reporting delivery.
• Advanced DAX capabilities for KPI, time intelligence and complex measures.
• Proficient in SQL for data interrogation of relational sources.
• Experience building governed, reusable datasets for self-service analytics.
• Ability to implement Row-Level Security and manage secure access.

Responsibilities

• Translate requirements into robust Power BI reports and dashboards.
• Design and maintain Power BI datasets and semantic models.
• Collaborate with stakeholders across business units and product teams.
• QA, reconcile data to source, and validate visuals and metrics.
• Document data transformations, access controls, and governance practices.

Skills

Power BI

DAX

SQL

Data Modelling

RLS (Row-Level Security)

Data Governance

QA & Validation

Tools

Power Query

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
• 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

Benefits

• Private Medical Healthcare
• Pension Scheme
• Life Assurance
• 25 Days Holiday
• Wellness
• Retail & Lifestyle Discounts
• Flexible Working
• Continued Learning
• CycleScheme

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 useThis 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 detailAccuracy, consistency, data quality, and strong QA discipline are essential, as reports and datasets will support business-critical decision-making and user-facing product functionalityStrong understanding of data governance, data quality, lineage, and access control principlesExcellent attention to detail and commitment to report QA, documentation, and data accuracyStrong understanding of dimensional data modelling, relationships, data grain, and scalable semantic model designCurrent SC clearance, or eligibility to obtain SC clearanceAbility to translate business requirements into effective reporting and analytical solutionsStrong SQL skills, with experience querying and analysing data from relational databasesAbility to work independently and collaboratively within cross-functional teamsAdvanced DAX capability, including complex measures, KPI development, and calculation validationStrong hands-on Power BI experience, including report development, data modelling, DAX, Power Query, and performance optimisationExperience creating governed, reusable datasets that support reporting and self-service analyticsExperience implementing Row-Level Security (RLS) and managing secure access and permissions within Power BIExperience validating and reconciling data to ensure accurate and reliable reportingProven experience building enterprise Power BI datasets and semantic modelsStrong stakeholder engagement skills, with the ability to gather requirements, challenge assumptions, and influence outcomesThis role requires Security Check (SC) clearance. Candidates must either hold current SC clearance, or be eligible to obtain SC clearanceAll offers are subject to satisfactory vetting, references and occupational health checksExperience configuring and governing Power BI workspaces, sharing models, and enterprise reporting environmentsExperience collaborating with product, engineering, and data teams in agile delivery environmentsExperience working with data warehouses, lakehouses, or curated reporting layers (e.g. Silver layer architecture)Experience working within secure, regulated, or highly governed data environmentsKnowledge of Power BI governance, best practice standards, and enterprise reporting frameworks