Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Transform data into strategic assets and collaborate on innovative designs.
- Company: Join The AA, a forward-thinking company with a focus on data and analytics.
- Benefits: Enjoy 25 days leave, annual bonus, and discounts on AA products.
- Why this job: Be part of a team modernising data infrastructure with cutting-edge cloud technology.
- Qualifications: Experience in data modelling, SQL/Python skills, and knowledge of cloud solutions required.
- Other info: Diverse learning opportunities and a supportive, inclusive work environment await you.
The predicted salary is between 36000 - 60000 £ per year.
Overview
Role: Data Modeller at The AA. Location: Basingstoke, United Kingdom. Hybrid working: 3 office days per week. This is a permanent, full-time role within The AA\’s Data & Analytics team, focused on turning data into a strategic asset. The team is modernising our data infrastructure to a cutting-edge cloud platform, enabling machine learning and GenAI.
Job details
- Location: Basingstoke (hybrid working 3 office days per week)
- Employment type: Permanent, full time
- Company: The AA
- Benefits: Annual Bonus
Responsibilities
- Collaborate with Analysts and Architects to deliver low-level designs based on business requirements and high-level designs.
- Ensure alignment of low-level designs with application architecture, high-level designs, and AA Standards, Frameworks, and Policies.
- Analyse data sets to identify modelling logic and key attributes required for low-level design, and create and maintain appropriate documentation.
- Develop and update Physical Data Models and participate in design reviews.
- Lead handover sessions to developers and testers, and estimate effort required for low-level design documentation.
- Provide technical and business knowledge support to Business Analysts, and engage with the full end-to-end data development process within an Agile scrum framework.
Requirements
- Experienced with data warehouse and business intelligence, including delivering low-level ETL design and physical data models.
- Proficient in Data Warehousing Design Methodologies (Kimball dimensional models) and Data Modelling tools (ER Studio).
- Strong Data Analysis skills and hands-on experience with SQL/Python for data interrogation.
- Working knowledge of Cloud-based data and analytics solutions (Microsoft Azure, Databricks, Informatica, PowerBI) and ETL/ELT technology (Informatica DEI).
- Proven ability to understand business processes, facilitate meetings with senior stakeholders, and translate business requirements into technical designs.
- Excellent communication and presentation skills, with the ability to work independently under pressure and collaboratively within a cross-functional delivery team.
Benefits
- 25 days annual leave plus bank holidays + holiday buying scheme
- Worksave pension scheme with up to 7% employer contribution
- Free AA breakdown membership from Day 1 plus 50% discount for family and friends
- Discounts on AA products including car and home insurance
- Employee discount scheme that gives you access to a car salary sacrifice scheme plus great discounts on healthcare, shopping, holidays and more
- Company funded life assurance
- Diverse learning and development opportunities to support you to progress in your career
- Dedicated Employee Assistance Programme and a 24/7 remote GP service for you and your family
We’re an equal opportunities employer and welcome applications from everyone. The AA values diversity and the difference this brings to our culture and our customers. We actively seek people from diverse backgrounds to join us and become part of an inclusive company where you can be yourself, be empowered to be your best and feel like you truly belong. We have five communities to bring together people with shared characteristics and backgrounds and drive positive change.
#J-18808-Ljbffr
Data Modeller employer: The AA
Contact Detail:
The AA Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeller
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works at The AA. Building relationships can open doors that a CV just can't.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share your experiences with data modelling and how you've tackled challenges in the past. Let them see the real you and what you can bring to the table.
✨Tailor Your Approach
Before any interview, do your homework on The AA and their data initiatives. Tailor your examples to show how your skills align with their goals, especially around cloud platforms and data analytics. It’ll make you stand out!
✨Apply Through Our Website
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you're genuinely interested in joining The AA family.
We think you need these skills to ace Data Modeller
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Modeller role. Highlight your experience with data warehousing, ETL design, and any relevant tools like SQL or Python. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data modelling and how your background makes you a great fit for our team. Don’t forget to mention your experience with cloud-based solutions and Agile methodologies.
Showcase Your Projects: If you've worked on any relevant projects, make sure to include them in your application. We love seeing real-world examples of your work, especially if they demonstrate your ability to analyse data sets and create physical data models.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands. Plus, it shows us that you're genuinely interested in joining our team at The AA!
How to prepare for a job interview at The AA
✨Know Your Data Modelling Basics
Make sure you brush up on your data modelling fundamentals, especially around Kimball dimensional models and ETL design. Be ready to discuss how you've applied these methodologies in past projects, as this will show your practical experience.
✨Showcase Your Technical Skills
Prepare to demonstrate your proficiency in SQL and Python during the interview. You might be asked to solve a problem or analyse a dataset on the spot, so practice some common data interrogation techniques beforehand.
✨Understand The AA's Business Needs
Research The AA and its data strategy. Understand their current challenges and how your role as a Data Modeller can help them modernise their data infrastructure. This will allow you to tailor your answers to align with their goals.
✨Communicate Effectively
Since you'll be collaborating with various teams, practice explaining complex technical concepts in simple terms. Prepare examples of how you've successfully communicated with stakeholders in the past, as strong communication skills are key for this role.
