Senior Reporting Developer

Allwyn UK; Watford; On-site; GBP 45,000 - 70,000; Full time

Job summary

A leading company in the lottery sector is seeking a Senior Reporting Developer to enhance their analytics capabilities using Power BI. The ideal candidate will design intuitive dashboards and ensure data integrity while collaborating with various teams for insightful reporting solutions. With a focus on user experience and involvement in data governance, this position offers a blend of technical innovation and stakeholder engagement.

Benefits

26 days paid leave plus bank holidays

Annual bonus scheme

Pension matching up to 8.5%

Single Private Health Cover

£500 Wellness Allowance

Enhanced parental leave

Eye Care and Dental cover

Cycle To Work schemes

Qualifications

• Strong experience in using Power BI for analytics solutions.
• Knowledge of data integration best practices and governance.
• Experience with SQL and familiarity with Azure services.

Responsibilities

• Design, develop, and optimize Power BI dashboards and reports.
• Collaborate with stakeholders to gather reporting requirements.
• Monitor and optimize Power BI report performance.

Skills

Power BI

Data Modeling

DAX

Power Query

Data Visualization

Education

Bachelor’s or master’s degree in Computer Science or related field

Microsoft Power BI certifications preferred

Job description

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

About us:

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:

TheSenior Reporting Developer (Power BI)is responsible for designing, building, and maintaining high-quality, scalable, and user-friendly analytics solutions usingPower BI. This role focuses ontabular 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 withPower BI, includingPower Query,DAX,tabular modelling, and efficient data transformations. They will be experienced atPower 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 governancebest practices, ensuring data quality, integrity, and security across Power BI solutions.
• Collaborate with theData Governance teamto maintain areport catalogue, data dictionary,and data lineage, leveraging tools likeAtaccama(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.
• Ensurethorough testing, documentation, and rollback strategiesare in place prior to deploying new or updated reports.

Reporting Jobs Orchestration & Performance Optimization

• Coordinatereport refresh schedulesand data pipeline orchestrations (e.g., with Azure Data Factory, Power Automate) to ensure reliable data availability.
• Continuouslyanalyse and optimizerefresh 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.

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 totranslate complex reporting requirementsinto actionable development plans and vice versa.

• Proven ability tocollaborate effectivelywith 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 (orequivalent work experience).

Additional Qualifications

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

• 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