BI and Reporting Analyst (Cognos / Power BI)

Job Title: BI & Reporting Analyst (Cognos / Power BI)

Location: UK – Fully Remote

Salary: £60,000 - £65,000 per annum

About the Role

The role has two clear strands of work: maintaining and supporting the Cognos and Power BI reports that the business currently relies on, and helping test that those same reports continue to function correctly as the underlying data warehouse migrates to the cloud. You will report into a hands-on team lead and work alongside a senior Power BI specialist and a SQL engineer.

This is a hire into a small, established BI/reporting team of around six people, sitting inside a large, established business that is in the process of moving its data infrastructure from on-premise SQL systems to a new AWS/Redshift environment.

Key Responsibilities

• Own and administer the Cognos BI platform, including security management, framework maintenance, data source configuration, user access control, and reporting governance.
• Monitor, troubleshoot, and optimise Cognos reporting performance, manage system upgrades and scheduled jobs, and work closely with Data Engineers to ensure the reliable delivery of business-critical reporting solutions.
• Design, develop and support end-to-end Power BI solutions, including stakeholder requirements gathering, data modelling (star/snowflake schemas), data mart creation, DAX development, row-level security and delivery of engaging, user-focused dashboards and reports.
• Drive data quality and business intelligence excellence by troubleshooting data issues, optimising reporting solutions, working with data engineering teams, and translating complex business requirements into scalable, high-quality BI outputs.
• Test reports and front-end applications to confirm they continue to function correctly as data moves from on-premise SQL to AWS Redshift.
• Handle day-to-day support tickets from business users alongside longer-term modernisation project work.
• Meet with senior stakeholders, including directors, to gather reporting requirements and translate them into working solutions.
• Identify opportunities to improve reporting processes, including where AI tools could be applied.

Experience Required

• Building and maintaining Power BI reports, including use of DAX and M/Power Query.
• Hands-on experience with IBM Cognos Analytics and Cognos Framework Manager.
• Experience working with SQL-based data sources.
• Experience handling BAU report changes and support tickets from business users.
• AWS/Redshift experience is not essential, training will be provided.

Skills and Attributes

• Able to manage multiple concurrent pieces of work without losing track of detail.
• Able to adapt to changing priorities at short notice, such as urgent issues.
• Able to explain technical reporting concepts to non-technical stakeholders in plain language.
• Proactive in identifying improvements to reports and processes rather than only following instructions.
• Interested in developing skills in cloud data warehousing and AI-driven analytics.

Desirable

• Exposure to AWS, Redshift, or other cloud data warehouse technologies.
• Experience with forecasting, predictive modelling, or AI-assisted analytics.
• Experience working in a small, distributed tech or data team.

What's on Offer

• Fully remote role within the UK.
• Direct exposure to a live migration project, moving reporting from on-premise SQL to AWS/Redshift, with structured training provided.
• Regular contact with stakeholders up to director and business unit leader level.
• A mix of stable BAU reporting work and larger modernisation project work, rather than repetitive small changes only.