Data Modeller

**Company description** Role: Data Modeller
Term: Permanent
Location: Basingstoke and remote working considered

**Salary**: £50-55K dep on exp + annual bonus + excellent benefits

Solution bringers. Day makers. Extra milers. We are the AA. And we keep everyone’s show on the road. There for our members wherever and whenever they need us, we’re always ready for anything. That’s why, for over 100 years, we’ve continued to evolve andadapt. Today, as the nation’s number one motoring organisation, we offer a range of excellent products and services to millions of customers. As a Data Designer, you’ll join our exciting journey to fulfil our future vision. We aim to support the UK’s 17m driversand to facilitate their driving lives through data and innovation; to succeed with this, we require a step-change in pace and thinking. Join us as we transform and deliver on this ambitious vision.

**This is the job** You will be an integral member of the Data Change delivery team, working closely with the business and other areas of IT. You will create data solution designs which can be iteratively developed in an Agile framework. The designs will represent businessand data requirements for small and large change relating to AA data platforms. The designs will represent business and data requirements for small & large change relating to AA data platforms. The work you do will ensure solutions are in accordance to thearchitecture and design principles and guidelines, delivered and tested generating positive business value.

**What will I be doing?**:

- Work closely with Analysts and Architects to deliver low and high level designs based upon business requirements
- Analyse data sets to identify modelling logic and key attributes required for low-level designs
- Create and maintain appropriate low-level designs along with Source-to-target mapping (STTM) ensuring appropriate documentation is created and updated
- Develop and update Physical Data Models (PDMS)
- Perform Data Analyst’s responsibilities when required
- Lead handover sessions to developers and testers
- Participate in estimation of effort required to create low-level design documentation for each discrete piece of work
- Provide technical and business knowledge support to Business Analysts to elaborate user stories and acceptance criteria where required
- Provide input into Data Tower Design Authority as requested
- Engage with the business and the Product Owner(s) to understand business requirements and develop low-level design documentation for all impacted components in a solution

**What do I need?**:

- Working knowledge of Cloud based data and analytics solutions potentially using Microsoft Azure, Databricks, Informatica and PowerBI
- Hands-on SQL/Python experience for the purposes of interrogating data
- Solid experience with data warehouse and business intelligence
- Previous experience as Data Designer working independently within a data and analytics solution to deliver low level ETL design and physical data models
- Excellent knowledge of Data Warehousing Design Methodologies must have Kimball dimensional models
- Experience in bringing critical insights and suggestions for continual improvement into process and solution design
- Ability to understand and relay complex data-related issues
- Proven experience in Data Modelling tools such as ER Studio
- Working knowledge of ETL technology and tools, such as Databricks
- Working knowledge of data quality, cleanse and standardisation methods, techniques and tools
- Experience in working as part of data delivery teams using multiple delivery methodologies, incl. Agile, Hybrid Agile, Waterfall
- Proven problem-solving skills to identify the root cause of defects/issues and translate business requirements into technical designs

**Additional Information** As a valued member of our team, you’ll have access to a range of fully supported development programmes, designed to help you progress in your career with us. Whether you’re looking to grow in your current role, or learn new skills and take on greater responsibilities,we can help you build the career you’re looking for here.

We’re always looking to recognise and reward our employees for the work they do. Here are just a few of the benefits you’ll have access to, as part of our team..
- Annual discretionary performance related bonus scheme
- 25 days holiday (excl. bank holidays)
- Contributory pension scheme
- Discounted home and motor insurance
- ?Half price AA breakdown membership in your first year and free after 12 months, along with a 50% introductory discount off breakdown cover for 12 months for up to 5 friends/family members.
- Flexible benefits
- Plus, so much more

Good conduct matters to us. Our teams are motivated by doing the right thing for both customers and colleagues, and in line with our values, we ask all our employees to act with honesty & integrity and respect for others at all times.