Job title ::Senior SQL Developer
Glasgow(preferable). Other Client locations are also fine. Hybrid - 2 days in office
6 month contract
Please provide a detailed
Job Spec
It is for an experienced SQL Developer, who has had hands experience of Performance tuning, writing and maintaining complex stored procedures, data warehousing etc.
It is not for a report writer (SSRS) or SSIS developer.
Looking for a SQL server development that has a deep understanding of building solutions that are performant and is able to debug complex issues.
About Wealth Data & Analytics Team
Data & Analytics provide a sustainable data platform infrastructure for Wealth and the Private Bank to support the multiple channels of their business areas. This includes data warehousing as well as provisioning services to regulatory, colleague, digital, client reporting and analytics channels that are compliant with GDMS data controls and technology governance controls of the bank. The application domain includes and integrates a number of Barclay’s internally developed applications covering Client Data Integration, Client Channel services, Asset & Reference Data, Data Warehousing and API integration services.
Our analytics team and wider group of data enthusiasts aim to leverage our critical data assets to provide insights to business and operations areas as well as respond to their static reporting requirements.
Overall purpose of role
• Developer with experience in programming, design and integration of data warehouse and data distribution platforms. Needs to have a solid grasp of the key concepts in a data warehouse.
• Strong experience in writing queries and stored procedures in SQL Server.
• Strong in developing and supporting batch based systems. Candidate should have hands on experience in data profiling and debugging.
• Should be familiar with high standard of TSQL coding for the stored procedures, functions etc
• Experience on performance tuning techniques and tools
• Working with the development team to create physical database schemas. Optimising database design for optimal performance. Advising on best practice for developers interacting with the database. Developing and testing SQL and stored procedures
• Manage development issues, attend project meeting, undertake Peer reviews.
Key Accountabilities
• Taking business and functional requirements and translating them into technical and functional designs. Producing and maintaining application code.
• Unit and integration testing of code, and providing support to testing cycles ensuring that defects are resolved. All project deliverables must be produced in accordance with governance practices and utilizing QA procedures.
• Candidate will have an in-depth knowledge of the core database development platform with a particular focus on performance tuning.
• The right candidate will have the ability to translate data requirements into high quality database schemas.
• Strong team player
Stakeholder Management and Leadership
• Key stakeholders within the team are the Lead Product Owner, Data Analysts, PM/scrum masters and Technical Leads.
• Key stakeholders external to the team are the Wealth Enterprise Architects and Client and architects on other platform or project teams that interface to PBTV.
Risk and Control Objective
Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Client Policies and Policy Standards.
Person Specification
• The role holder must be a strong computer scientist with a good appreciation of the fundamental principles of relational database technology other fundamentals.
• The role holder must have strong time management skills and be able to juggle and complex and demanding workload.
• The candidate will be educated to degree level or above, preferably in computer science or a closely related discipline.
• The role holder will have an excellent command of English language with strong written and verbal communications to deliver against our commitment to providing a world class service and drive our dedication to the client experience.
Essential Skills/Basic Qualifications:
• Very strong TSQL Development skills.
• Very strong, proven SQL Server 2016 performance tuning skills.
• Good working knowledge of TSQLT unit testing.
• Proven ability to work under own initiative.
Desirable skills/Preferred Qualifications
• Good working knowledge of Bit bucket and Git flow methodologies.
• Good working knowledge of Jenkins
• Good working knowledge of Nexus
• AWS Glue – to create Data Creation and Data Provisioning workflows for loading data into AWS
• AWS S3
• AWS Data Lake
• AWS Lambda
• SPARK / PySpark
• Deep understanding of data pipelines, data governance and ETL processes in a Data Warehouse type environment
Environment is a very complex Data Warehouse environment.