401 Reporting Developer jobs in the United Kingdom

Job Title: Cognos Reporting Developer
Location: Cardiff - hybrid 2-3 days onsite p/week ideally
Contract Type:  Permanent

£30-35k + benefits
 

Overview:
We’re looking for an experienced Cognos Reporting Developer to join our client’s team. You’ll be responsible for designing, building, and maintaining reports and dashboards using IBM Cognos Analytics. The role is hands-on, working closely with business users to turn requirements into clear, accurate, and insightful reporting solutions.

Key Responsibilities:

• p>Develop and maintain reports and dashboards in IBM Cognos Analytics (Report Studio, Query Studio, etc.)

• Work with stakeholders to gather requirements and translate them into reporting solutions

• Optimise report performance and troubleshoot issues

• Build reusable templates and standard reports for different business areas

• Ensure data accuracy and consistency across all reporting outputs

Skills & Experience:

• Strong experience with IBM Cognos (Report Studio, Query Studio, Cognos Analytics)

• Background in BI / reporting development, not just end-user reporting

• Good SQL skills and understanding of relational databases

• Experience building dashboards, prompts, and drill-down functionality

• Strong communication skills to work with both technical and non-technical stakeholders

Nice to Have:

• Experience with data modelling or ETL tools

• Knowledge of other BI tools (e.g. Power BI, Tableau, Qlik)

Join our journey to create a new experience for the National Lottery and help us to power change for the greater good.

We are Allwyn UK, part of the Allwyn Entertainment Group – a multi-national lottery operator with a market-leading presence in Austria, the Czech Republic, Greece, Cyprus and Italy.  We have been officially awarded the Fourth Licence (10 year licence) to operate the National Lottery starting February 2024.

We’ve developed ground-breaking technologies, built player protection frameworks, and have a proven track record of making lotteries better.  Our aim is to create one of the UK’s most inclusive organisations – where people can bring the best of themselves, to do their best work, every day, for the benefit of good causes.

Allwyn is an Equal Opportunity Employer which prides itself in being diverse and inclusive. We do not tolerate discrimination, harassment, or victimisation in the workplace.  All employment decisions at Allwyn are based on the business needs, the job requirements, and the individual qualifications.  Allwyn encourages applications from individuals regardless of age, disability (visible or hidden), sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships.

While the main contribution of the National Lottery to society is through the funds to good causes, at Allwyn we put our purpose and values at the heart of everything we do.  Join us as we embark on a once-in-a-lifetime, largescale transformation journey to build a bigger, better, and safer National Lottery that delivers more money to good causes.  

Role Purpose:

The Senior Reporting Developer (Power BI) is responsible for designing, building, and maintaining high-quality, scalable, and user-friendly analytics solutions using Power BI. This role focuses on tabular model design, data visualization best practices, and end-to-end report lifecycle management—ensuring that business stakeholders receive accurate, insightful, and timely data.

A strong candidate will have deep hands-on experience with Power BI, including Power Query, DAX, tabular modelling, and efficient data transformations. They will be experienced at Power BI capacity planning, optimizing performance, and integrating Power BI solutions with broader data platforms. The Senior Reporting Developer will be creating reports which would reflect the business needs and will encourage data driven decision making across the business. Proactive proposals of report improvements based on the PowerBI feasibilities and efficient communication with the business stakeholders is also expected from this role.

Power BI Architecture & Development

• Design, develop, and optimize Power BI dashboards, reports, and data models.
• Implement best practices for data transformations (Power Query), DAX calculations, and tabular model design, including unit testing of tabular models to ensure accuracy and reliability.
• Create intuitive layouts and visual designs that drive business adoption, focusing on great user experiences (UX) in reports and dashboards.
• Maintain consistency in visual standards, data definitions, and nomenclature across all reports.

Data Modelling & Integration

• Build and maintain robust, scalable tabular models that support self-service analytics and enterprise reporting.
• Collaborate with data engineering/platform teams to align on data warehouse design, create and maintain aggregate tables, and ensure reliable data pipelines feeding into Power BI from multiple data sources.
• Implement data integration best practices to ensure consistent, accurate, and secure data across the reporting ecosystem.

Infrastructure, Automation & Capacity Planning

• Implement and manage Power BI Workspaces, gateways, and deployment pipelines.
• Apply CI/CD practices for reporting artifacts (e.g., version control, automated testing, and release management).
• Identify and implement automation opportunities for processes such as refresh schedules, performance monitoring, and usage analytics.
• Contribute to capacity planning and management, ensuring optimal resource utilization and ability to handle growth in data volume and user concurrency.

Collaboration, Engagement & Design Alignment

• Work closely with business stakeholders, product managers, and data engineering/platform teams to gather reporting requirements and translate them into technical solutions.
• Support the development of a self-serve culture by assisting in training business users on Power BI tools and promoting the adoption of accessible and reliable BI artifacts.
• Participate in design reviews and regularly synchronize with the data engineering team to ensure data models align with reporting and analytics needs.

Governance & Compliance

• Implement reporting governance best practices, ensuring data quality, integrity, and security across Power BI solutions.
• Collaborate with the Data Governance team to maintain a report catalogue, data dictionary, and data lineage, leveraging tools like Ataccama (or similar) for metadata management.

• Implement role-based access controls, manage row-level security (RLS), and adhere to data privacy regulations and internal policies.

Performance Monitoring & Optimization

• Monitor and optimize Power BI report performance, proactively addressing bottlenecks (e.g., DAX queries, refresh times, model size).
• Continuously review and optimize tabular models, visualization layouts, and data transformations to improve user experience and reduce latency.
• Provide guidelines and support for business users who create their own reports and dashboards to manage performance in self-service scenarios.

Release Planning & Deployment of Reporting Solutions

• Contribute to the end-to-end release cycle for Power BI enhancements, including testing, documentation, and rollback strategies.
• Ensure thorough testing, documentation, and rollback strategies are in place prior to deploying new or updated reports.

Reporting Jobs Orchestration & Performance Optimization

• Coordinate report refresh schedules and data pipeline orchestrations (e.g., with Azure Data Factory, Power Automate) to ensure reliable data availability.
• Continuously analyse and optimize refresh performance and usage analytics, identifying opportunities for parallelization, resource tuning, and cost efficiency.

Code Review & Efficient Testing Practices

• Adhere to and contribute to best practices for code reviews, ensuring quality and security standards within Power BI development.
• Implement efficient testing frameworks and methodologies (e.g., data validation, unit testing of tabular models, performance testing, user acceptance testing) to reduce defects and enhance reliability.

Continuous Learning & Innovation

• Stay updated with the latest Power BI features, best practices, and industry trends.
• Proactively suggest and implement innovative solutions to improve reporting efficiency and effectiveness.

Mentoring & Knowledge Sharing

• Share expertise and best practices with junior team members and business users.
• Contribute to internal documentation and knowledge bases to support team growth and consistency in development practices.

Requirements

Technical Expertise

• Power BI: Deep hands-on experience with Power Query, DAX, tabular model design, visualization best practices. Proficiency in optimizing report performance and implementing advanced features.
• Data Modelling: Strong knowledge of star/snowflake schemas, dimension/fact design, and row-level security for enterprise-scale tabular models.
• Programming & Scripting: Proficiency in SQL; familiarity with Python or other scripting languages is a plus.
• Cloud Platforms: Experience with Azure services (e.g., Azure Data Factory, Azure Synapse) or other cloud-based data platforms is beneficial.

Collaboration & Communication

• Excellent communication skills to translate complex reporting requirements into actionable development plans and vice versa.

• Proven ability to collaborate effectively with cross-functional stakeholders (Analytics, Data Engineering/Platform, Data Governance, Product, Business Teams).

Problem-Solving & Innovation

• Strong analytical and problem-solving skills, with the ability to troubleshoot complex data and performance issues.
•  Demonstrated capacity for innovative thinking in BI solution design and implementation.

Performance Optimization

• Expertise in optimizing Power BI reports, dashboards, and data models for speed and efficiency.
• Experience in implementing best practices for large-scale data refresh and query performance.

Educational Background

• Bachelor’s or master’s degree in Computer Science, Information Systems, Business Analytics, or a related field (or equivalent work experience).

Additional Qualifications

• Microsoft Power BI certifications (e.g., DA-100 / PL-300: Analysing Data with Microsoft Power BI) are highly preferred.
• Lottery domain experience is preferred, given familiarity with unique data structures, compliance considerations, and reporting nuances within the lottery industry.
• Prior experience working with enterprise-level BI implementations in a fast-paced or startup-like setting is a plus.

Benefits

• 26 days paid leave (plus bank holidays) 

• Annual bonus scheme 

• 2 x Life Days 

• 4 x Salary of Life Insurance 

• Pension: we’ll match your contribution up to 8.5% 

• Single Private Health Cover 

• £500 Wellness Allowance 

• Income Protection 

• Enhanced parental leave (maternity and paternity) 

• Eye Care, Dental and Cycle To Work schemes 

The Reporting & Insight Analyst Developer role involves creating data-driven insights and reports to support decision-making within the financial services industry. This position is based in Glasgow and requires strong analytical skills, along with experience in SQL / Power BI data visualisation and reporting tools.

Client Details

The employer is a well-established organisation within the financial services industry. They are committed to delivering high-quality analytics solutions to support their business operations and provide valuable insights to their stakeholders

Description

• Develop and maintain reporting dashboards and data visualisation tools to support business decisions (via SQL / PowerBI).
• Collaborate with internal teams to identify reporting requirements and deliver actionable insights.
• Analyse large datasets to identify trends, patterns, and opportunities for improvement.
• Ensure the accuracy and reliability of all reporting outputs.
• Support the automation of reporting processes to improve efficiency.
• Provide technical expertise in data extraction, transformation, and loading (ETL) processes.
• Maintain documentation of reporting processes and methodologies.
• Work closely with stakeholders to ensure reports meet business needs.

Profile

A successful Reporting & Insight Analyst Developer should have:

• Proficiency in data visualisation tools such as Power BI or Tableau.
• Strong SQL skills for querying and manipulating data.
• Experience in creating and maintaining reporting dashboards.
• Ability to analyse complex datasets and communicate findings effectively.
• Knowledge of ETL processes and data management best practices.
• Knowledge of Teradata and Alteryx is highly desirable
• A degree in a relevant field such as Data Analytics, Computer Science, or a similar discipline.

Job Offer

• Competitive salary in the range of 40,000 to 50,000 per annum.
• Generous pension scheme to support your future.
• Performance-based bonus of up to 10% of your annual salary.
• Permanent position offering job security in the financial services industry.
• Hybrid working with 3 days per week in the office

If you are passionate about analytics and enjoy working with data in the financial services industry, we encourage you to apply for the Reporting & Insight Analyst Developer role today!

The Reporting & Insight Analyst Developer role involves creating data-driven insights and reports to support decision-making within the financial services industry. This position is based in Glasgow and requires strong analytical skills, along with experience in SQL / Power BI data visualisation and reporting tools.

Client Details

The employer is a well-established organisation within the financial services industry. They are committed to delivering high-quality analytics solutions to support their business operations and provide valuable insights to their stakeholders

Description

• Develop and maintain reporting dashboards and data visualisation tools to support business decisions (via SQL / PowerBI).
• Collaborate with internal teams to identify reporting requirements and deliver actionable insights.
• Analyse large datasets to identify trends, patterns, and opportunities for improvement.
• Ensure the accuracy and reliability of all reporting outputs.
• Support the automation of reporting processes to improve efficiency.
• Provide technical expertise in data extraction, transformation, and loading (ETL) processes.
• Maintain documentation of reporting processes and methodologies.
• Work closely with stakeholders to ensure reports meet business needs.

Profile

A successful Reporting & Insight Analyst Developer should have:

• Proficiency in data visualisation tools such as Power BI or Tableau.
• Strong SQL skills for querying and manipulating data.
• Experience in creating and maintaining reporting dashboards.
• Ability to analyse complex datasets and communicate findings effectively.
• Knowledge of ETL processes and data management best practices.
• Knowledge of Teradata and Alteryx is highly desirable
• A degree in a relevant field such as Data Analytics, Computer Science, or a similar discipline.

Job Offer

• Competitive salary in the range of 40,000 to 50,000 per annum.
• Generous pension scheme to support your future.
• Performance-based bonus of up to 10% of your annual salary.
• Permanent position offering job security in the financial services industry.
• Hybrid working with 3 days per week in the office

If you are passionate about analytics and enjoy working with data in the financial services industry, we encourage you to apply for the Reporting & Insight Analyst Developer role today!

The Reporting & Insight Analyst Developer role involves creating data-driven insights and reports to support decision-making within the financial services industry. This position is based in Glasgow and requires strong analytical skills, along with experience in SQL / Power BI data visualisation and reporting tools.

Client Details

The employer is a well-established organisation within the financial services industry. They are committed to delivering high-quality analytics solutions to support their business operations and provide valuable insights to their stakeholders

Description

• Develop and maintain reporting dashboards and data visualisation tools to support business decisions (via SQL / PowerBI).
• Collaborate with internal teams to identify reporting requirements and deliver actionable insights.
• Analyse large datasets to identify trends, patterns, and opportunities for improvement.
• Ensure the accuracy and reliability of all reporting outputs.
• Support the automation of reporting processes to improve efficiency.
• Provide technical expertise in data extraction, transformation, and loading (ETL) processes.
• Maintain documentation of reporting processes and methodologies.
• Work closely with stakeholders to ensure reports meet business needs.

Profile

A successful Reporting & Insight Analyst Developer should have:

• Proficiency in data visualisation tools such as Power BI or Tableau.
• Strong SQL skills for querying and manipulating data.
• Experience in creating and maintaining reporting dashboards.
• Ability to analyse complex datasets and communicate findings effectively.
• Knowledge of ETL processes and data management best practices.
• Knowledge of Teradata and Alteryx is highly desirable
• A degree in a relevant field such as Data Analytics, Computer Science, or a similar discipline.

Job Offer

• Competitive salary in the range of 40,000 to 50,000 per annum.
• Generous pension scheme to support your future.
• Performance-based bonus of up to 10% of your annual salary.
• Permanent position offering job security in the financial services industry.
• Hybrid working with 3 days per week in the office

If you are passionate about analytics and enjoy working with data in the financial services industry, we encourage you to apply for the Reporting & Insight Analyst Developer role today!

The Reporting & Insight Analyst Developer role involves creating data-driven insights and reports to support decision-making within the financial services industry. This position is based in Glasgow and requires strong analytical skills, along with experience in SQL / Power BI data visualisation and reporting tools.

Client Details

The employer is a well-established organisation within the financial services industry. They are committed to delivering high-quality analytics solutions to support their business operations and provide valuable insights to their stakeholders

Description

• Develop and maintain reporting dashboards and data visualisation tools to support business decisions (via SQL / PowerBI).
• Collaborate with internal teams to identify reporting requirements and deliver actionable insights.
• Analyse large datasets to identify trends, patterns, and opportunities for improvement.
• Ensure the accuracy and reliability of all reporting outputs.
• Support the automation of reporting processes to improve efficiency.
• Provide technical expertise in data extraction, transformation, and loading (ETL) processes.
• Maintain documentation of reporting processes and methodologies.
• Work closely with stakeholders to ensure reports meet business needs.

Profile

A successful Reporting & Insight Analyst Developer should have:

• Proficiency in data visualisation tools such as Power BI or Tableau.
• Strong SQL skills for querying and manipulating data.
• Experience in creating and maintaining reporting dashboards.
• Ability to analyse complex datasets and communicate findings effectively.
• Knowledge of ETL processes and data management best practices.
• Knowledge of Teradata and Alteryx is highly desirable
• A degree in a relevant field such as Data Analytics, Computer Science, or a similar discipline.

Job Offer

• Competitive salary in the range of 40,000 to 50,000 per annum.
• Generous pension scheme to support your future.
• Performance-based bonus of up to 10% of your annual salary.
• Permanent position offering job security in the financial services industry.
• Hybrid working with 3 days per week in the office

If you are passionate about analytics and enjoy working with data in the financial services industry, we encourage you to apply for the Reporting & Insight Analyst Developer role today!

• Responsible for data analysis, entry and Validation related activities across the Pirbright manufacturing facility, to enable the large scale production of FMD and BTV antigen and finished product in a timely and cost effective manner.
• Analyse production data to identify trends, deviations, and performance metrics.
• Assist in the execution of cleaning validation protocols in line with GMP requirements.
• Bring in SQL / Power BI approaches to improve the site approach to data.
• Support sampling, documentation, and coordination of validation activities.

• GMP experience is essential
• Have a scientific or engineering discipline degree (e.g., Biochemistry, Biotechnology, Chemical Engineering, Pharmaceutical Sciences).
• Understanding of cleaning validation principles and documentation practices.
• Experience with data handling and analytics
• Knowledge of HSE, bio-safety standards, GMP regulations as well as main tools and principles of operational excellence

• Responsible for data analysis, entry and Validation related activities across the Pirbright manufacturing facility, to enable the large scale production of FMD and BTV antigen and finished product in a timely and cost effective manner.
• Analyse production data to identify trends, deviations, and performance metrics.
• Assist in the execution of cleaning validation protocols in line with GMP requirements.
• Bring in SQL / Power BI approaches to improve the site approach to data.
• Support sampling, documentation, and coordination of validation activities.

• GMP experience is essential
• Have a scientific or engineering discipline degree (e.g., Biochemistry, Biotechnology, Chemical Engineering, Pharmaceutical Sciences).
• Understanding of cleaning validation principles and documentation practices.
• Experience with data handling and analytics
• Knowledge of HSE, bio-safety standards, GMP regulations as well as main tools and principles of operational excellence