Senior Reporting Developer

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: 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 Power BI 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.

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.

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.