Data & Business Intelligence Developer

Picture More; Greater London; Hybrid; GBP 75,000 - 88,000; Full time

Job summary

Company name withheld at this stage in London is seeking an Application Engineer to own a portfolio of business intelligence applications, spanning SQL engineering, data warehouse design, Power BI development, and Azure Data Factory integrations.

The role sits in a small Business Systems team with ownership of the full pipeline, from data engineering to reporting, in a professional services environment that values cross-skilling and practical ownership.

Qualifications

• Hands-on SQL database engineering within a data warehousing context.
• Power BI development experience with DAX and paginated reporting.
• Azure Data Factory integrations (REST / OData) in production environments.
• Experience in a legal or regulated professional services environment.

Responsibilities

• Write and maintain stored procedures, functions and complex SQL within a data warehousing context.
• Build DAX-driven Power BI semantic models and paginated/SSRS-style reports.
• Deliver Azure Data Factory integrations (REST and/or OData) in a live production environment.
• Work closely with vendors and stakeholders as the technical owner of your application portfolio.

Skills

SQL

Power BI

Azure Data Factory

Data warehousing

DAX

Paginated reports

Tools

Tabular Editor

DAX Studio

ALM Toolkit

DevOps / CI-CD

Job description

Application Engineer - Business Intelligence

£75,000 - £88,000 London - 3 days per week in office Permanent

About the role

We're looking for a hands-on Application Engineer to take ownership of a portfolio of business applications within a small, close-knit Business Systems team of 15. This isn't a seat at the end of a reporting queue - you'll own the full pipeline, from SQL engineering and data warehouse design through to Power BI development and Azure Data Factory integrations, working as a technical product owner for the applications in your care.

The role sits within a stable, prestigious, international professional services environment that's actively evolving its technology stack - modern tools, real ownership, and a team culture built around cross-skilling and knowledge sharing rather than siloed specialisms.

What you'll be doing

• Writing and maintaining stored procedures, functions and complex SQL within a data warehousing context (Kimball or Inmon), not just ad hoc querying
• Building DAX-driven Power BI semantic models and producing paginated/SSRS-style reports - not solely dashboard design
• Delivering Azure Data Factory integrations (REST and/or OData) in a live production environment
• Working closely with vendors and stakeholders as the technical owner of your application portfolio

What we're looking for

• Hands-on SQL database engineering experience within a data warehousing context - not limited to reporting-only SQL use
• Practical Power BI development experience: DAX-driven semantic models and paginated/SSRS-style reporting
• Delivered Azure Data Factory integrations (REST and/or OData) in a production environment, not proof-of-concept only
• Experience within a legal or wider regulated professional services environment

Nice to have

• Tabular Editor, DAX Studio or ALM Toolkit
• DevOps, CI/CD and deployment pipeline experience
• Familiarity with legal sector compliance and IT security standards (e.g. GDPR, ISO 27001, Cyber Essentials Plus)
• Exposure to agile or iterative delivery methodologies

The process

A structured two-stage interview process: an initial conversation with two Application Leads, followed by a second stage with the Business Systems Manager and Head of Business Systems.

Company name withheld at this stage - full details shared with shortlisted candidates.