There is an exciting opportunity to join a growing and fast paced delivery team within HMRC's Data Platform Service Delivery Group as a Data Solution Architect. This role exists to analyse IT requirements and produce data solutions through the high level design documentation that is in place. In this role you will be expected to represent your designs by partnering across the organisation and work with IT developers in a fast paced environment using Agile methodology within a scrum team. Our team prides itself on operating with an open, forward-thinking and hard-working environment in which your ideas will be encouraged and you will get to work with passionate, knowledgeable individuals and teams alongside being enabled to learn new skills, gain valuable experience and grow along with our current digital transformation. Responsibilities Create designs for data centric solutions producing relevant documentation, ensuring they are aligned with Departmental data and security standards. Apply data modelling techniques against a range of database technologies to establish, modify or maintain a data structure and its associated components based on the IT requirements presented. Produce data mapping documents, showing traceability across data environments. Knowledge of a range of applications to support the team's Architecture development. Mentoring of a Junior Data Solution Architect may be required. Essential criteria Experience of working successfully in either Data Analysis or Solution Design roles with specific data focus on Data Warehousing. Experience of successfully creating and implementing designs for data centric solutions. Data Modelling. Database schema definition. RDBMS. Broad IT experience with in-depth understanding of data strategies, data models, ETL design & development. Data Security. Data Virtualization concepts and metadata management tooling Cloud hosting and developing solutions in a cloud environment, including on prem to cloud, and cloud to cloud Has a background in a data analyst / developer / designer role with a range of experience. Developing large scale IT Data Architectures and in entity relationship, dimensional modelling and semantic models in a complex, multi supplier environment. Big Data solutions in a data analytics technology landscape. NO SQL technology. Data management technologies and approaches. Data exploitation tools such as Log Analytics or Reporting. Desirable criteria: Technical Experience and or training in several of the following is highly desirable: Data modelling - experience with entity, logical and physical models Data-focused technologies and their practical implementation and operation, including the Hadoop ecosystem. Data technologies and approaches, including some or all of the following: Hadoop, NoSQL databases, relational databases, data warehousing, Data Marts. Database Technologies (NoSql, PostgreSQL, Hbase, Oracle, DB2, MS SQL Server). Data exploitation tools, including some or all of the following: Pentaho Business Analytics, SAS Enterprise Guide / Enterprise Miner, SAP Business Objects. Data quality tools such as SAS Data Management Studio. Transformation tools, including some or all of the following: Informatica Powercenter, Pentaho Data Integrator, SAP Data Services, Talend. AI and Cognitive services Design of Risking systems implemented in BRMS, SAS RTDM. Data transfer methodology including the likes of sFTP and FTPs, JDBC, Flume, Kafka. Different languages, data formats and APIs, SOAP / Restful services including JSON, XML, Security approaches and tools, e.g. encryption, tokenisation. Use of various collaboration tools including JIRA, Confluence etc. Experience using an Architecture Repository and adhering to its use and policy. Cloud environments such as AWS, Azure. Desirable qualifications: A qualification in an IT based subject would be advantageous Behaviours We'll assess you against these behaviours during the selection process: Developing Self and Others Making Effective Decisions Benefits Learning and development tailored to your role An environment with flexible working options A culture encouraging inclusion and diversity A Civil Service pension If you are applying for a role in an office within a regional center location or a transitional or specialist site, then the following may apply: Daily Travel Assistance will be available for this role, provided the successful applicant is a current HMRC employee and meets the eligibility requirements outlined in the department's Daily Travel Assistance guidance. Things you need to know Security Successful candidates must pass a disclosure and barring security check. Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check . Selection process details This vacancy is using Success Profiles , and will assess your Behaviours, Strengths and Experience. During the selection process you will be sifted on your CV and statement of suitability. You will be expected to demonstrate how you meet the essential criteria detailed in the statement of suitability guidance. Applications will be sifted on the CV, statement of suitability and behaviours. If you are successful at the sift stage you will be invited to attend an interview. Interviews will cover past experience and skills and Strengths. Feedback will only be provided if you attend an Interview. Sift and interview dates as well as the interview location to be confirmed. Further Information: Customer facing roles in HMRC require the ability to converse at ease with members of the public and provide advice in accurate spoken English and/or Welsh where required. Where this is an essential requirement this will be tested as part of the selection process. Security Update: If you are successful and transferring from another Government Department, we will carry out a check of your identity, nationality, and immigration status (including the right to work in the UK) and a criminal record check before confirming your appointment. Successful candidates must pass a Disclosure and Barring Security Check. Please note that HMRC have an exemption under the Rehabilitation of Offenders Act 1974, which enables us to make enquiries about both unspent and spent convictions. In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service /Disclosure Scotland/Access NI (delete as appropriate: If location is in England will be DBS, Scotland will be Disclosure Scotland & Northern Ireland will be Access NI) on your behalf. However, we recognise in exceptional circumstance some candidates will want to send their completed forms direct. If you will be doing this, please advise Government Recruitment Service of your intention by emailing Pre-EmploymentChecks.grscabinetoffice.gov.uk stating the job reference number in the subject heading. Applicants who are successful at interview will be, as part of pre-employment screening subject to a check on the Internal Fraud Database (IFD). This check will provide information about employees who have been dismissed for fraud or dishonesty offences. This check also applies to employees who resign or otherwise leave before being dismissed for fraud or dishonesty had their employment continued. Any applicant's details held on the IFD will be refused employment. A candidate is not eligible to apply for a role within the Civil Service if the application is made within a 5 year period following a dismissal for carrying out internal fraud against government. HMRC transformation: In November 2015, HMRC announced the next step in our ten-year modernisation programme to create a tax authority fit for the future, committing to high-quality jobs and the creation of new regional centres serving every region and nation in the UK. We set out our plans to consolidate into 13 large, modern offices, equipped with the digital infrastructure and training facilities needed to build a more highly-skilled workforce. These offices will be located in Glasgow, Edinburgh, Belfast, Newcastle, Leeds, Liverpool, Manchester, Nottingham, Birmingham, Bristol, Cardiff, Croydon and Stratford. There will also be a small number of specialist sites, where the work cannot be done anywhere else, in Gartcosh (near Glasgow), Telford, Ipswich, Worthing and Dover, as well as our headquarters in central London. In addition, our Welsh language service has people in specialist roles located in Porthmadog, as well as Cardiff. If you are recruited into an office that is not one of these locations, you will be expected, subject to HMRC's applicable policies, to move to one of these locations in the future. In some cases this will be via a transitional site. If you are not a current civil servant, you will not be eligible for financial assistance for your move to the regional centre or a transitional or specialist site. If you are a current HMRC employee and you joined HMRC through an advert that was advertised on or after 11/01/2017, you will not be eligible for financial assistance for your move to the regional centre or a transitional or specialist site. This is in line with the terms of your original appointment to HMRC. For more information please contact the vacancy holder. Terms and Conditions: Some of HMRC Terms and Conditions of employment changed on 1st May 2013, these will apply to people who are new recruits to HMRC or who take a new job in HMRC on promotion. The document attached to this advertisement provides more information on the changes we made, please note this is not a full list of HMRC's terms and conditions. If you need to discuss how these changes might affect you, please contact the vacancy holder. For further information on terms and conditions please visit https://www.gov.uk/government/organisations/hm-revenue-customs/about/recruitmentannual-leave Pay: If you are currently working for an OGD and would like to consider the impact on your pay when joining HMRC, please see the attached document "Pay on Transfer from OGD" for further information. Any move to HMRC will mean you will no longer be able to carry on claiming childcare vouchers. New entrants are expected to join on the minimum of the pay band. Reasonable adjustment: If a person with disabilities is put at a substantial disadvantage compared to a non-disabled person, we have a duty to make reasonable changes to our processes. If you need a change to be made so that you can make your application, you should: Contact Government Recruitment Service via HMRCRecruitment.grscabinetoffice.gov.uk as soon as possible before the closing date to discuss your needs. Complete the "Assistance required" section in the "Additional requirements" page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at interview, or if you're deaf, a Language Service Professional. Feedback will only be provided if you attend an interview or assessment. Nationality requirements Open to UK, Commonwealth and European Economic Area (EEA) and certain non EEA nationals. Further information on whether you are able to apply is available here . Working for the Civil Service The Civil Service Code sets out the standards of behaviour expected of civil servants. We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles . The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.