Application Engineer - BI

We are looking for a talented and adaptable Application Engineer to join our Business Systems team. You will bring expertise for the firm’s BI Reporting and data platform, which includes the Enterprise Data Warehouse, Microsoft Power BI/Fabric and Microsoft Azure Data Factory.

You will be comfortable talking to a range of people and translating technical ideas for non-technical audiences. You will work closely with business users, technology colleagues and third-party vendors to ensure your portfolio of applications remains reliable, scalable, secure and aligned to the firm's evolving needs. This will require strong troubleshooting skills and a solid understanding of system integrations, data structures and flows, application architecture and governance.

This is an excellent opportunity to help shape and improve our technology landscape, enhance operational efficiency, and drive data insights.

We are a close-knit and supportive team of 15 people, dedicated to sharing knowledge and cross-skilling to support and improve the diverse set of business-critical applications we look after. We are looking for someone with the flexibility and appetite to learn and pick up new skills and technologies as well as the enthusiasm to utilise their skill set to aid delivery across the entire Application Engineering team.

The key responsibilities of this role are set out below and there may be others which are not listed. You may be required on occasion to work outside our normal working hours of 9:30am to 5:30pm.

• Serve as the technical product owner for assigned business applications, managing their technical direction and ensuring alignment with the Technology department’s roadmap, business strategy and user needs.
• Stay informed of product updates, upgrades and roadmap developments and manage their implementation.
• Maintain and prioritise the product backlog, including new features, upgrades, maintenance tasks, defect resolution and security updates.
• Serve as a subject matter expert (SME) for your portfolio, promoting optimal use of the applications and proactively identifying opportunities for business improvement.
• Engage regularly with application stakeholders and users to ensure they are informed of progress and change, and to monitor and improve user experience.

• Collaborate with stakeholders to gather requirements and translate them into practical application changes or enhancements.
• Work with internal and external teams to securely design, develop, test and optimise enhancements to your assigned applications.
• Participate in or lead agile ceremonies such as sprint planning, backlog refinement and retrospectives.

• Manage the configuration, deployment and ongoing support of your portfolio of applications.
• Troubleshoot and resolve complex technical issues, escalating to vendors where necessary.
• Act as the primary liaison between internal users, procurement, support teams and vendors for your portfolio.
• Manage vendor relationships, including coordinating support cases, overseeing service levels, and negotiating enhancements or customisations.
• Monitor usage and performance, proactively addressing issues and identifying opportunities for improvement.
• Maintain thorough documentation relating to change control, configuration, processes and procedures.

• Maintain best practice security policies and procedures for the applications, any data they handle or store and their integrations, complying with internal and external security standards.
• Identify and manage risks and vulnerabilities in your portfolio and in its roadmap and proactively support their mitigation.
• Participate in audits, risk assessments and business continuity planning as it relates to your application portfolio.

• Expert SQL skills with an excellent knowledge of SQL objects, including stored procedures, functions, XML and JSON data types.
• Strong knowledge of Data Warehouse methodologies including Kimball and Inmon.
• Strong DAX skills with knowledge of semantic modelling.
• Strong knowledge of Power BI and paginated report writing.
• Experience of building integrations using Azure Data Factory including REST and OData connections.
• Excellent stakeholder engagement, communication and documentation skills, with the ability to convey technical concepts clearly to non-technical audiences.
• A collaborative approach and a genuine…