Senior BI Analyst

Lynas Foodservice
Coleraine, United Kingdom
19 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Microsoft Windows Artificial Intelligence Business Intelligence Development Code Generation Relational Databases Python (Programming Language) Microsoft Software Microsoft SQL Server Language Modeling Performance Tuning Power BI
+12 more
Standard Sql Microsoft SharePoint Systems Integration Microsoft Power Automate Delivery Pipeline Large Language Models Powerquery Microsoft Fabric Claude Api Design Restful APIs Data Pipelines

Job description

Lynas Foodservice processes thousands of orders every day, and each one creates data across our ordering, warehouse, distribution, pricing and finance systems. The Business Intelligence team turns that activity into reports and insight the business can act on.

The Senior BI Analyst is a hands-on, commercially minded technical role. The postholder owns key parts of the BI estate end to end, from source data and pipelines through semantic models to the reports and analysis that commercial, buying, pricing, finance and operations teams rely on every week. AI tooling, including large language models, is embedded in how the team works, and the postholder is expected both to use it and to extend it.

As well as building reports and models, the postholder works closely with colleagues to understand what they need, explains results in plain language, and covers for the BI Manager when required.

Key responsibilites:

Commercial insight

  • Provide analysis and insight that helps the business understand its performance and make better decisions, presenting findings clearly to stakeholders at all levels.
  • Identify trends, risks and opportunities in the data, explaining what is driving results and whether they matter.
  • Work with colleagues across the business to turn questions into clear analysis and practical recommendations, challenging the brief where a different approach would better answer the underlying question.

BI development

  • Design, build and maintain data models, reports and dashboards to a high technical standard across the Microsoft BI stack.
  • Develop and maintain the data pipelines, integrations and automation that bring data from operational and third-party systems into reporting.

Data quality, reliability and governance

  • Ensure BI outputs are accurate, reliable and performant, resolving issues at root cause.
  • Apply checks and controls proportionate to commercial exposure, and maintain team standards, governance and documentation.

Stakeholder engagement and leadership

  • Act as a trusted point of contact for senior stakeholders, and scope, prioritise and lead projects end to end.
  • Deputise for the BI Manager, support and coach other team members, and identify opportunities to improve and automate.

AI-assisted analysis and development

  • Use large language models such as Claude routinely across analysis, development and documentation, and build and improve AI-assisted workflows that connect these tools to business data.
  • Validate AI-generated output against source data before it is relied on, handle sensitive data in line with company policy, and identify where AI can add further value.

People and culture

  • Support the underlying principle of Creating a Great Place to Work.
  • Demonstrate self-awareness and discernment in all interpersonal interactions across the Lynas business, and act with respect and dignity in all dealings with colleagues.
  • Promote a positive working atmosphere in which recognition and teamwork are held in the highest regard.
  • Participate in regular two-way communication sessions, reinforcing the principle that every employee’s opinion counts.
  • Ensure timekeeping supports payroll processing and operational planning, and maintain awareness of all HR policies.

Planning Horizon

  • Daily. Ensure reporting is available and accurate, and respond to priority requests from the business.
  • Weekly. Deliver recurring commercial reporting and insight, using AI-assisted analysis and commentary where appropriate, and progress project work against agreed priorities.
  • Monthly. Meet recurring monthly commitments and period-end deadlines.
  • Annually and longer term. Contribute to the BI roadmap and lead improvements in data, reporting, automation and the use of AI.

Autonomy and Decision Making

  • Make design and technical decisions on data models, pipelines and reports within agreed team standards, without prior sign-off.
  • Run reporting projects independently once priorities are agreed, dealing directly with senior stakeholders on scope, design and sign-off.
  • Act on operational BI matters in the BI Manager’s absence, escalating anything with significant commercial exposure or cross-team impact.

Complexity of the role

  • Higher. Working across interconnected commercial, warehouse, distribution and finance systems, where the correct answer often requires reconciling several sources, and where an error can carry direct commercial cost.
  • Higher. Interpreting commercial performance for senior stakeholders: explaining what is driving a result and whether it matters, not just reporting the number.
  • Moderate. Balancing project delivery, fixed recurring commitments and ad hoc requests from multiple departments.

Requirements

  • At least three years of hands-on experience building Power BI solutions in a business setting, including semantic model design, DAX and Power Query.
  • Strong commercial awareness, with the ability to understand what drives business performance and explain it in plain language.
  • Experience of turning unclear business questions into well-structured analysis and clear, actionable recommendations.
  • High standards of accuracy, with the habit of reconciling figures to source before they are shared.
  • Confident written and verbal communication with senior, non-technical stakeholders, including the ability to challenge constructively.
  • Experience of owning business-critical recurring deliverables and meeting fixed deadlines without being chased.
  • Practical experience of using large language models productively in analytical or development work, with a critical approach to checking their output.
  • Able to work on site in Coleraine as part of a small, collaborative team.

Desirable

  • Experience in foodservice, wholesale, distribution or another high-volume, low-margin trading environment.
  • SQL skills, including writing and optimising queries against relational databases.
  • An accounting or finance background, or experience of working closely with finance on margin, cost or management reporting.
  • Experience of Microsoft Fabric, such as lakehouses, warehouses, notebooks or data pipelines.
  • Experience with Tabular Editor, DAX Studio, Power BI deployment pipelines, REST API integration or Python.
  • Experience of building AI-assisted workflows, such as prompt and instruction design, agentic tools, MCP connectors or API-based integration of language models.
  • Microsoft certification such as PL-300 or DP-600.

Technical Environment

Proficiency in Power BI is expected on appointment, and experience across the rest of the stack is an advantage. Lynas systems and data are covered through structured handover.

  • Core stack. Power BI Desktop and Service, including semantic modelling, DAX and Power Query; dataflows; SQL Server; Power BI Report Builder; Power Automate; Excel.
  • Specialist tools. Tabular Editor, DAX Studio and XMLA endpoints for model development and performance tuning.
  • Supporting tools. Microsoft 365, SharePoint, Microsoft Lists and JotForm.
  • AI tooling. Claude is used routinely across the team for analysis, commercial commentary, code generation, scoping and documentation, including agentic and connector-based workflows with business data. Competent, critical use is expected on appointment.

Benefits & conditions

  • Competitive salary
  • Enhanced annual leave entitlement
  • Enhanced Sick Pay
  • Employee Discount
  • Subsidised Canteen
  • On-site Parking
  • Local Business Discounts
  • Learning and Development Opportunities
  • Career Progression Opportunities

Benefits:

  • Additional leave
  • Free parking
  • Health & wellbeing programme
  • On-site parkinh

Work authorisation:

  • United Kingdom (required), * Company pension
  • Employee discount
  • Free parking
  • Health & wellbeing programme
  • On-site parking

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…