Data Design Analyst

Job Description

As our next Data Design Analyst, you’ll analyse data requirements, design database structures and profile data to support our portfolio for change. You’ll utilise database design and data governance tools to document and design data solutions in our enterpriserepositories, supporting business ownership of data. You’ll join a likeminded team in our Leeds-based Enterprise Data Technical Solutions function.If you’ve got a solid background in database design and you want to develop a career in an empowering, respectful and supportive business then why not join us.About the roleYou’ll oversee database design and data analysis work across a number of projects and contribute to our standards. With a proactive approach to work, you will have experience of normalised and dimensional database design, as well as writing SQL to identifysource data and data transformations. Your typical activities will include:

• Identifying and documenting data requirements
• Carrying out entity-relationship modelling in line with best practices (fully normalised, conceptual, logical and physical design)
• Designing dimensional or denormalised tables for our data warehouse
• Creating data mappings for data integration components
• Being responsible for delivering designs in-line with data architecture standards, patterns, principles and challenging where necessary.

About you

• You have experience working in a similar role - Data Analyst, Data Modeller or similar, working with Business Stewards and Data Architects to understand enterprise requirements
• You have a proven track record of using data modelling and data governance tools such as Erwin or similar
• You have knowledge of data management and database design
• You have demonstrable experience of profiling data and writing SQL.

About usAt YBS we don’t have shareholders, we have members. We care about people and that includes you. So here, you’ll be respected for who you are, you’ll be able to bring your whole self to work, and you’ll have everything you need to build a long and rewardingcareer.

• Flexibility. We offer a range of flexible working options without unsocial hours, which can help you find a healthy work-life balance. Whether it’s finishing early for an appointment or fitting your studies and hobbies in around your workinghours, we can help make it work for you.
• Development. We want you to feel challenged here. Whatever your ambitions, we’re committed to helping you develop your skills and move ahead in your career journey. From day one, we’ll set you up for success with a brilliant induction andfull training plan, all designed to get you up to speed quickly.
• Inclusivity. We’re passionate about creating an inclusive environment where everyone is welcome and able to be themselves. If you’ll go the extra mile to help our members, you’ll fit right in and feel you belong here.

About our BenefitsWe offer lots of fantastic rewards that you can make the most of in and out of work, including:

• Holiday. You’ll get 25 days plus Bank Holidays, as well as the option to buy up to a further 5 days.
• Bonus. We work together to reach for better at YBS, so when we reach our goals we’re all rewarded, with up to a 10% annual bonus.
• Pension. We know how important it is to save towards the future, that’s why we’ll contribute up 11% into your YBS pension.
• Healthcare. Health and wellbeing are an important part of life at YBS, when you join us you’ll have access to a range of health benefits to suit your life including private medical insurance, dental and healthcare plans.
• My Benefits. When you join YBS you’ll have access to our self-service benefits portal, where you can access a range of retail, hospitality and health discounts,

Ready to applyIf you’re excited about this role and want to be part of the YBS team, apply now to send us your application.Please note applications are reviewed frequently therefore this role may close prior to the advertised closing date.