COGNOS Developer

Brickendon Consulting Limited; Bristol; On-site; GBP 40,000 - 55,000; Full time

Job summary

A consulting firm in the UK is seeking a BI Developer to design and optimize IBM Cognos reports. You will work with various reporting systems and ensure compliance with security standards. Ideal candidates should have 3+ years of experience in IBM Cognos Analytics, strong SQL skills, and the ability to communicate effectively with stakeholders.

Qualifications

• 3+ years of experience in IBM Cognos Analytics (v11 or v12).
• Proven experience in Framework Manager, Report Studio, Query Studio, and Transformer.
• Understanding of data warehousing, ETL processes, and relational modelling.
• Experience delivering secure reporting solutions within government or regulated sectors.

Responsibilities

• Design and build IBM Cognos Framework Manager models.
• Develop and maintain reports and dashboards using Cognos Analytics.
• Ensure data accuracy and consistency across frameworks.
• Implement security and access controls.

Skills

IBM Cognos Analytics

SQL proficiency

Report optimisation

Strong communication skills

Tools

Oracle

SQL Server

JIRA

Confluence

Job description

Responsibilities

• Design and build IBM Cognos Framework Manager models for each system (BIWMS, BODMS, VITAL, BOB).
• Develop, optimise, and maintain approximately 200300 reports and dashboards using Cognos Analytics 12.
• Collaborate with Authoritys testing team to perform functional and user acceptance testing before deployment to live environments.
• Ensure data accuracy and consistency across multiple frameworks and reporting layers.
• Apply performance optimisation techniques such as query tuning, model restructuring, and indexing for faster report generation.
• Implement security and access controls aligned with MoDs OFFICIALSENSITIVE classification standards.
• Support root cause analysis, issue resolution, and report corrections in coordination with DE&S business teams.
• Provide technical documentation including model design, data lineage, and deployment guides.
• Comply with DEFCON 658, 659A, and 660 security requirements and the Official Secrets Act 1989.
• Attend progress reviews and submit milestone updates as per the project delivery plan.

Qualifications

• 3+ years of experience in IBM Cognos Analytics (v11 or v12).
• Proven experience in Framework Manager, Report Studio, Query Studio, and Transformer.
• Strong SQL proficiency (Oracle or SQL Server).
• Understanding of data warehousing, ETL processes, and relational modelling.
• Demonstrated experience in report optimisation and performance tuning.
• Experience delivering secure reporting solutions within government or regulated sectors.
• Strong communication skills with the ability to liaise with both technical and non-technical stakeholders.
• Familiarity with Agile working practices and collaboration tools such as JIRA, Confluence, or equivalent.