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 BI Cloud Integration & Release Specialist will report to the BI Technical Architect and is responsible for code promotions, deployment pipeline management, and data provisioning across the organization’s Business Intelligence (BI) function. This role focuses on both ETL code (e.g., ingestion, transformation, data processing) and Power BI code (e.g., dashboards, data models) to ensure seamless, reliable, and well-managed deployments. Given the organization’s Big Data landscape, the Specialist must be proficient in Redshift SQL, CI/CD tools (e.g., Jenkins, GitHub Actions), Terraform for infrastructure automation, containerization (e.g., Docker, Kubernetes), and Python for automation, logging, and observability. This role also covers managing non-production environment freshness, orchestrating Jira-to-code integrations, optimizing ETL/Power BI code, and creating Jira-to-data provisioning pipeline integrations—all while operating in an AWS environment. Strong problem-solving and troubleshooting capabilities, as well as cost monitoring and optimization, are critical to success. Key Responsibilities: BI Operations & System Monitoring: Ensure day-to-day smooth running of BI data pipelines, reporting systems, and cloud-based ETL/ELT workflows (AWS, Redshift, Glue, Airflow). Monitor system uptime and performance, proactively addressing issues to maintain SLA compliance. Setup monitoring dashboards and look after systems availability and operations. Strong observability setup skills to constantly look for thresholds and alerting mechanisms. Automation skills to be able to identify automations which would reduce manual efforts. Incident, Release/Change & Problem Management (L2 Support): Investigate, triage, and resolve L2 incidents, escalating L3 issues when necessary. Perform root cause analysis and implement fixes to improve system stability. Perform deployments on production environments and ensuring change management process is followed. Approve or review changes published by Dev/Test teams on Production environments. SLA & Performance Compliance: Maintain SLAs for uptime, latency, and data freshness, using monitoring tools like AWS CloudWatch. Track and optimise system performance, reducing recurring issues. Data Governance & Quality: Oversee data validation, ensuring compliance with governance frameworks (Ataccama or similar). Reduce flagged data anomalies and drive improvements in data quality KPIs. Automation & Continuous Improvement: Automate manual support processes (alerting, monitoring) to improve efficiency and reliability. Identify and implement workflow optimisations to reduce operational bottlenecks. Stakeholder & Team Collaboration: Work closely with cross-functional teams (DevOps, Data Engineering, AI) to align on fixes and enhancements. Provide regular updates on incident resolution progress to key stakeholders and leadership. Experience: 5 years of experience (minimum 3 years in Production Support for AWS BI/Data Engineering) Hands-on experience with AWS BI stack (Redshift, Glue, Airflow, S3, Step Functions). Data Engineering & ETL: Redshift, Glue, Airflow, S3 Step Functions, Spark. Reporting & Visualisation: Power BI (preferred), Business Objects, Qlik. Data Warehousing: Data modeling, ETL processes, and reverse engineering. Database Expertise: Strong SQL scripting, database optimisation, and troubleshooting Incident & Problem Management: Identify root causes, troubleshoot, and implement fixes for data pipeline and platform issues. Manage L2 escalations effectively, ensuring timely resolution and minimizing business impact. Monitoring & Automation for Stability: Track data pipeline health, dependencies, and performance metrics using monitoring tools. Implement automated alerting and self-healing mechanisms to reduce manual intervention Team Management: Hiring, retention, and mentoring of a motivated team, providing regular feedback and career growth opportunities Our goal 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. 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