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, optimising performance, and integrating Power BI solutions with broader data platforms. The Senior Reporting Developer will be creating reports which reflect the business needs and will encourage data-driven decision making across the business. Proactive proposals of report improvements based on Power BI feasibilities and effective communication with the business stakeholders are expected.
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
* Create intuitive layouts and visual designs that drive business adoption, focusing on great user experiences 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 (version control, automated testing, 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, addressing bottlenecks in DAX queries, refresh times, and 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 optimise refresh performance and usage analytics, identifying opportunities for parallelisation, 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 (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
* 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
* Bachelors or masters 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: well 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
#J-18808-Ljbffr