Data Modeller

**Company description**:
**Role: Data Designer/Modeller**
**Term: Permanent**
**Location: London and/or remote working considered**
**Salary**:£50-55K dep on exp + annual bonus + excellent benefits**

Here at the AA, the largest breakdown provider in the UK; we are looking to recruit an experienced **Data Designer/Architect** to join our Data team.

Breakdown cover has always been our number one priority but we’ve since branched out into Finance, Insurance, Leisure and Lifestyle services and have a unique history of embracing new technology and innovations to better serve our 14 million members.

The team are going through a period of transformation of digital and analytical capability and you will have the opportunity to be part of the action and to help shape and drive digital solutions that will allow our vision to be achieved

**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 business and 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 the architecture 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?**:

- Previous experience as Data Designer working independently within a data and analytics solution to deliver low level ETL design and physical data models
- Working knowledge of Cloud based data and analytics solutions potentially using Microsoft Azure, Databricks, Informatica and PowerBI
- Solid experience with data warehouse and business intelligence
- 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**:
**What’s in it for you**:
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.

**#LI-THEAA