SQL Developer

Job Description

About the opportunity Poundland are recruiting for a Data Governance Developer (SQL Developer) . You will be reporting directly to the Data Governance Manager; the primary purpose of this position is to assist the Data Governance Manager in the formationand execution of the data governance framework, policy and standards.The role will work within a team of data analysts and developers to optimise the businesss data management, governance, accuracy, and availability.Acting across functions, you will guide & work within projects to implement and improve all aspects of data quality, systems, business processes, analysis tools and techniques.The key objectives are to support data activities to maintain accuracy, quality and best practices whilst maximising business benefits through improved data usage, control, governance, and risk management of these activities.You will also liaise directly with stakeholders across the business to support and provide functional knowledge to appropriately embed the improved data process and quality.The role is based at our Customer Support Centre (CSC) in Walsall, with the ability to work agile between home and the CSC.We reserve the right to close this vacancy early if we receive a high volume of applications for the role. Therefore, if you are interested, please submit your application as early as possible. What youll be doing... Develop and implement a data governancestrategy:Support the Data Governance Manager in implementing and maintaining a strategy and road map for data governance and compliance to include systems and processesImplement and manage our records of processing activities, Data Mapping via the information Records Management Strategy. Ensure controls are in place for internal and external stakeholders/suppliers in all processing activitiesTo define solutions, innovations, systems, processes and plans for continual step-change and improvementDevelop data extraction and reporting to support the delivery of the data governance strategy:Understand, integrate, transform and consolidate data from various data systems into structures for building analytics and reportsBuild data lifecycles and document where and how data is mastered within the core E2E systemsBe able to build SQL batches to refresh data governance data and dashboardsDevelop data management principles that lead to enhanced data integrity:Develop control structures within the Poundland business environment to ensure the accuracy and quality of data through all upstream and downstream data channelsCoordinate the resolution of data integrity gaps by working with the business owners and ITEnsure controls are in place over applications to ensure data integrity by performing data integrity gap analysisProvide expert support to project activity:Participate in projects that involve any of the upstream or downstream data flows and processes.Ensure data projects are designed and executed to align with other systems and initiatives to deliver maximum value.Providing data, information, evidence and analysis to inform decision-making, including but not limited to all stakeholders of company-wide data projectsWhat youll need... A passion for working with dataStrong understanding of databases and data structuresExperience in extracting legacy data on large system transformationsSQL Server Integration ServicesSQL Server Reporting ServicesMS SQL*Server, ideally 2017 or aboveStored proceduresFunctionsT-SQLVisual Studio/SSDTSSRSSSISSSASGood knowledge of Microsoft ExcelExcellent written and verbal communication skills.Self-sufficient and able to prioritise work with a high level of autonomyAbility to compare technologies and make recommendations to senior members of the team.What we can offer... Competitive salaryPotential to earn bonusFree on-site car parkOnsite coffee loungeDiscount Card – 10% discount on most purchases in store including PEP&COFamily Friendly BenefitsLoyal Service AwardsMy Staff Shop – exclusive discount portalApprenticeships & Career Development Life Assurance CoverHealth & Wellbeing – employee assistance programme to support youHoliday Allowance – increasing by one day per year (up to 33 days), along with the option to purchase additional holiday (annually)PensionBirthdays are important, so each year, you can take the day off as an extra day’s holidayAbout us... From one store in Burton-upon-Trent in 1990 to more than 850 across the UK and the Republic of Ireland today, Poundland & Dealz has developed a reputation for offering top brands and quality own-brand products at an amazing value. We sell everythingfrom food and drink to DIY, pet products to stationery, not forgetting our very own fashion brand, PEP&CO. We have recently invested £45 million in the business, opened new stores and revamped existing ones. We’re on an exciting journey, and you can be a partof it.We’re part of a much larger group in Europe called Pepco which has 3,000 stores in 17 territories serving 50 million shoppers, and the size of our business means there are so many opportunities for you to come and join us. From our retail stores to our supportand distribution centres, everywhere you see Poundland and Dealz, you’ll find passionate and knowledgeable colleagues delivering amazing service to our customers. Once you’re part of our family, we’ll give you everything you need to be the best you can be,from training to coaching and mentoring. Our seven core values and seven leadership principles steer how we do business. They give us the building blocks to create a culture where everybody thrives, and sustainability is at the top of our agenda.