Data Modeller
hackajob
Date: 2 days ago
City: Basingstoke
Contract type: Full time
hackajob is collaborating with The AA to connect them with exceptional tech professionals for this role.
Location: Basingstoke (hybrid working 3 office days per week)
Employment Type: Permanent, full time
Additional Benefits: Annual Bonus
Join Our Data & Analytics Team: Transforming Data into Our Superpower! Are you passionate about data and eager to make a significant impact? At The AA, a trusted and household name, our Data & Analytics function is at the forefront of innovation. We manage 1 petabyte of data, 500 million annual interactions, and 375 million quotes, making data our superpower. Our team is modernising our data infrastructure to a cutting-edge cloud platform, enhancing performance and enabling machine learning and GenAI.
Join us and be part of a team that turns insights into action, driving meaningful change for our customers, colleagues, and shareholders. Together, we can make Data a lifeline of our organisation and a powerful force for the future.
As a Data Designer/Modeller, you will be an integral member of the Data Change delivery team, working closely with various business units and IT departments. You will create data solution designs that can be iteratively developed within an Agile framework. Your designs will represent business and data requirements for both small and large changes related to AA data platforms, ensuring alignment with architecture and design principles.
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 (PDMS) 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.
Experienced with data warehouse and business intelligence, including delivering low-level ETL design and physical data models.
Proficient in Data Warehousing Design Methodologies (e.g., Kimball dimensional models) and Data Modelling tools (e.g., 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 (e.g., Microsoft Azure, Databricks, Informatica, PowerBI) and ETL/ELT technology (e.g., 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
We’re always looking to recognise and reward our employees for the work they do. As a valued member of The AA team, you’ll have access to a range of benefits including:
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
Plus, so much more!
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.
Location: Basingstoke (hybrid working 3 office days per week)
Employment Type: Permanent, full time
Additional Benefits: Annual Bonus
Join Our Data & Analytics Team: Transforming Data into Our Superpower! Are you passionate about data and eager to make a significant impact? At The AA, a trusted and household name, our Data & Analytics function is at the forefront of innovation. We manage 1 petabyte of data, 500 million annual interactions, and 375 million quotes, making data our superpower. Our team is modernising our data infrastructure to a cutting-edge cloud platform, enhancing performance and enabling machine learning and GenAI.
Join us and be part of a team that turns insights into action, driving meaningful change for our customers, colleagues, and shareholders. Together, we can make Data a lifeline of our organisation and a powerful force for the future.
As a Data Designer/Modeller, you will be an integral member of the Data Change delivery team, working closely with various business units and IT departments. You will create data solution designs that can be iteratively developed within an Agile framework. Your designs will represent business and data requirements for both small and large changes related to AA data platforms, ensuring alignment with architecture and design principles.
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 (PDMS) 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.
Experienced with data warehouse and business intelligence, including delivering low-level ETL design and physical data models.
Proficient in Data Warehousing Design Methodologies (e.g., Kimball dimensional models) and Data Modelling tools (e.g., 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 (e.g., Microsoft Azure, Databricks, Informatica, PowerBI) and ETL/ELT technology (e.g., 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
We’re always looking to recognise and reward our employees for the work they do. As a valued member of The AA team, you’ll have access to a range of benefits including:
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
Plus, so much more!
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.
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Backend Developer (Basingstoke, UK)
Parking Network B.V.,
Basingstoke
1 week ago
At EasyPark, we love cities. We love them for work, for play, and everything in between. That’s why our vision is to make cities more livable! EasyPark Group is a global company and a true leader in its domain. There is a clear ambition to quickly grow in coverage and offer our services to more customers and partners.About The RoleAs...
Frontend Developer- 6 months contract
Once For All,
Basingstoke
£450
-
£500
per day
2 weeks ago
Once For All is a high-growth, cloud-based, SaaS subscription business. Our technology helps our customers to manage their supply chain governance, risk management and compliance. We work across public and private sector and have over 250k customers across the UK across 20 different sectors including construction, transport, retail, hospitality education, facility and property management, manufacturing, local and central government.Role Summary:We...
Fleet Sales Manager
R Developer,
Basingstoke
£50,000
-
£50,001
per year
4 weeks ago
My clients are a forward and well respected dealer group in the Basingstoke area who have a requirement for an experienced CORPORATE SALES MANAGER.£50,000 OTE PLUS CAR AND EXPENSES, MONDAY TO FRIDAYYou will be responsible for the management of the corporate sales team and maintaining a detailed schedule of sales activity.Do you have the skills to fill this role Read...
