Business Intelligence Developer

Ultima; Reading; On-site; GBP 65,000 - 90,000; Full time

Job summary

Trustmarque Ultima is seeking a BI Developer to bridge data engineering and analytics, building robust data models and Power BI reports that empower informed decisions across the business. You will design pipelines in Microsoft Fabric, implement semantic models, optimise DAX and query performance, and collaborate with data analysts to translate requirements into reliable dashboards.

Join a leading UK technology solutions provider and help shape data-driven insights while advancing your career in

Qualifications

• Hands-on experience building in Microsoft Fabric Pipelines, Dataflows Gen2, Lakehouse and Onelake.
• Solid data modelling skills with star schema design for analytics and BI.
• Strong SQL skills for querying and transforming data across cloud data platforms.
• Expertise in ELT workflows and creating data pipelines for analysis.
• Knowledge of data warehousing concepts and technologies.
• Understanding of data governance, data quality, security and privacy.

Responsibilities

• Act as the bridge between Data Engineering and Data Analysts, ensuring data is ready for analysis and reporting.
• Design, build and maintain transformation pipelines in Microsoft Fabric to produce analytics-ready datasets.
• Develop semantic data models optimized for Power BI consumption and reporting.
• Create, publish and maintain Power BI reports and dashboards with advanced DAX and Power Query.
• Document source-to-target mappings and automate data flows in Fabric Pipelines and OneLake.
• Collaborate with Analysts to translate requirements into robust data models and reporting solutions.
• Implement data quality checks, validation rules and monitoring in the transformation layer.
• Apply data governance best practices across BI and transformation layers.
• Optimize performance of Power BI datasets and pipelines (incremental refresh, aggregations, query folding).
• Conduct data audits and advise on improvements for governance and security.

Skills

Microsoft Fabric

Power BI

Data Modelling

SQL

ETL/ELT

Data Governance

Data Warehousing

DAX

Star Schema

Tools

SQL Server

Azure SQL

OneLake

Job description

Trustmarque Ultima is the result of the merger between Trustmarque and Ultima, bringing together two leading technology businesses with a shared commitment to customer success, innovation, and excellence. Our combined organisation offers enhanced capabilities, broader career opportunities, and an exciting environment where talented people can thrive and help shape the future of technology services in the UK

KEY ACCOUNTABILITIES / ROLE PURPOSE

This role sits at the intersection of data engineering and business intelligence, serving as the critical bridge between the data engineering team and the data analysts. This role is responsible for aiding the data engineers by transforming raw data into clean, structured, and well-modelled datasets that power reliable reporting and analytics across the business. Working closely with the data engineers and analysts, the BI developer will build and maintain transformation pipelines, develop robust semantic data models, and deliver high-quality Power BI reports and dashboards that enable the business to make confident, data-driven decisions.

MAIN DUTIES AND RESPONSIBILITES

• Act as the primary connection point between the Data Engineering and Data Analyst teams, ensuring data delivered through pipelines is correctly structured, documented, and ready for analysis and reporting.
• Design, build, and maintain transformation pipelines within Microsoft Fabric, converting raw ingested data into clean, consistent, analytics-ready datasets.
• Develop and maintain reusable, well-documented semantic data models optimized for Power BI consumption and business reporting.
• Build, publish, and maintain dynamic, interactive Power BI reports and dashboards that meet business requirements, using advanced DAX measures, Power Query transformations, and row-level security where required.
• Support the Data Engineering team in documenting source-to-target mappings and re-engineering manual or fragmented data flows into scalable, automated, and repeatable processes within Microsoft Fabric Pipelines and OneLake.
• Collaborate closely with Data Analysts to understand reporting requirements and translate business questions into well-structured data models and reliable reporting solutions.
• Establish and maintain data quality checks, validation rules, and monitoring within the transformation layer to ensure data is accurate, consistent, and trustworthy.
• Implement and uphold data governance best practices within the BI and transformation layer.
• Optimize the performance of Power BI datasets and transformation pipelines, including incremental refresh, aggregation tables, query folding, and efficient DAX patterns to ensure fast and reliable report delivery.
• Conduct data audits and assessments to evaluate data quality, governance, and security practices, identifying areas for improvement and implementing corrective actions.
• Develop and maintain documentation for data pipelines, data sources, transformations, and data lineage to ensure transparency, traceability, and compliance with data governance standards.
• Work closely with stakeholders to manage relationships and oversee the full project lifecycle, providing technical leadership and project management for multiple reporting solutions.

ESSENTIAL KNOWLEDGE, SKILLS & EXPERIENCE

• Programming Proficiency: Hands-on experience building within Microsoft Fabric — including Pipelines, Dataflows Gen2, Lakehouse, and Onelake — combined with strong Power BI skills across report design, DAX, Power Query, dataset management, and workspace governance.
• Data Modelling and Architecture: Solid understanding of data transformation principles and hands-on experience building semantic data models, including star schema design (fact and dimension tables), for analytics and BI consumption.
• SQL Proficiency: Strong SQL skills for querying, transforming, and modelling data across cloud data platforms. Ability to write efficient, well-structured queries and understand query performance optimisation.
• ETL/ELT Processes: Expert in ELT/ELT processes, including creating scripts and workflows to extract and transform data for analysis.
• Data Warehousing: Knowledge of data warehousing concepts and technologies to store and manage large volumes of structured and unstructured data.
• Data Governance: Understanding of data governance principles and frameworks, including data quality, security, compliance, and privacy requirements.
• Problem-Solving Skills: Proven track record of tackling complex data-related problems, identifying patterns, trends, and outliers in data sets, and proposing data-driven solutions to business challenges.
• Attention to Detail: Meticulous approach to data analysis, ensuring data accuracy, consistency, and integrity throughout the analysis process, including data cleaning and validation.
• Collaborative Team Player: Strong interpersonal and communication skills to collaborate effectively with cross-functional teams, translate business requirements into data solutions and present findings to non-technical stakeholders in a clear and concise manner.
• Continuous Learning: A willingness to learn and adapt to new technologies and methodologies is highly valued in this role.

Joining Trustmarque Ultima means becoming part of a business where people genuinely make the difference. We're passionate about developing our people, celebrating success and creating an environment where everyone can thrive.

Our values underpin everything we do:

Team – We collaborate, support one another and achieve more together.

Excellence – We strive to deliver exceptional outcomes for our customers and each other.

Empowerment – We trust our people, encourage innovation and provide opportunities to grow.

Alongside a competitive salary and benefits package, you'll have the opportunity to work with some of the UK's most talented technology professionals while building a rewarding career in one of the country's leading technology solutions providers.