Our department :
HMRC is one of the UK’s largest government departments and one of the country’s biggest organisations. Almost every individual and business in the country is a direct customer of HMRC. We collect more than £500 billion a year in revenue from over 50 million customers across the UK. We are on a journey to become one of the most digitally advanced tax authorities in the world. To achieve our ambition, we are investing in ground-breaking initiatives and programmes to transform our tax systems, building a dynamic organisation with a culture that focuses on, and significantly invests in, the continual development of our people.

Our team :

Data Engineering and Analytics (DEA) is made up of 20 people, who are primarily SAS, SQL or Oracle programmers working in system development roles. We form part of HMRC's wider Debt Management (DM) team.
DM focuses on helping customers comply fully with their tax obligations, and on making timely and targeted contact with customers who do not comply.

DEA maintains and improves DM's large-scale data warehouse, which is a ‘big data’ analytics and debt management system, complete with a decision engine, using SAS on an Oracle platform. This system combines data from a range of sources, captures changes, and builds a single source of business intelligence for DM.

This is used to place customers on the most appropriate debt-recovery journey in terms of effectiveness, efficiency, and customer experience. Using SAS, we evaluate customer responses to HMRC interventions and create behaviour models and risk profiles. We continually enrich the data to meet the requirements of current and future campaigns, and work to identify and resolve system issues and inefficiencies to improve campaign deployment.

We are in the process of transitioning our systems to the Cloud and transforming how we work. This will see DM’s large-scale data warehouse replaced by an evolving new capability from 2025-2026. We are working to understand and exploit the powerful and dynamic analytical environment it brings and to transition all our current processes and services across to the new technology.

Person Specification

• Commercial experience of coding in SAS programming language and software products, including SAS Enterprise Guide, SAS Data Integration Studio and SAS Viya.
• Experience of undertaking development and testing work on multi-terabyte relational databases.
• Experience of developing data to create reports, dashboards and visualisations using SAS Visual Analytics.
• Experience of using Git.
• SAS Certified Specialist: Base Programming
• SC Cleared

Statement of Work

• Working with a geographically dispersed team to design and build a new data warehouse which structures raw business data into a relational set of tables which can deliver business value.
• Working with a diverse set of business stakeholders to turn requirements into effective technical solutions.
• Developing and testing robust, efficient, and accurate code to populate tables of business data.
• Working efficiently to support a fast-moving programme by integrating a pipeline of changes.
• Ensuring all code meets business requirements, is quality-assured, and meets internal standards before deployment in live.
• Producing clear documentation which reflects code deployed, purpose and related dependencies.
• Developing management information, dashboards, and evaluation to support understanding of business performance.
• Using the Git repository to store code, collaborate on development and create effective version control.
• Providing advice and expertise on design, development, testing and deployment practices to improve robustness, scalability, and supportability of data warehouse solution.
• Ensuring solutions are future-proofed as much as possible to minimise rework.