Logo of Huzzle

Home

Matches

Explore

Manage

Data Designer

image

The AA

6d ago

  • Job
    Full-time
    Mid & Senior Level
  • Data
    IT & Cybersecurity
  • Birmingham

AI generated summary

  • You need expertise in data warehousing, ETL design, data modeling (Kimball), SQL/Python, cloud solutions (Azure, PowerBI), and skills to liaise with stakeholders and translate business needs into technical designs.
  • You will collaborate on designs, analyze data for modeling, create documentation, develop Physical Data Models, lead handovers, estimate design efforts, and support Business Analysts in an Agile environment.

Requirements

  • 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.

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 (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.

FAQs

What is the location of the Data Designer position?

The position is located in Oldbury, with hybrid working options requiring 2-3 office days per week.

What type of employment is being offered for the Data Designer role?

The position is a permanent, full-time employment opportunity.

Are there any additional benefits associated with this job?

Yes, the job offers an annual bonus as well as various other employee benefits.

What team will the Data Designer be a part of?

The Data Designer will be an integral member of the Data & Analytics Team.

What are the main responsibilities of the Data Designer?

The Data Designer will create data solution designs, collaborate with Analysts and Architects, analyze data sets, develop and update Physical Data Models, conduct handover sessions, and support the full end-to-end data development process within an Agile framework.

What skills are required for the Data Designer position?

Candidates should have experience with data warehouses, proficiency in Data Warehousing Design Methodologies and Modeling tools, strong data analysis skills, working knowledge of cloud-based data solutions, and excellent communication abilities.

Is experience with SQL or Python required for this role?

Yes, strong hands-on experience with SQL or Python for data interrogation is required.

What types of cloud-based solutions should candidates be familiar with?

Candidates should have a working knowledge of Microsoft Azure, Databricks, Informatica, PowerBI, and related ETL/ELT technologies.

What kind of support does the company provide for employee development?

The company offers diverse learning and development opportunities to support career progression.

What benefits are included in the employee package?

Benefits include 25 days annual leave plus bank holidays, a pension scheme with employer contributions, free AA breakdown membership, discounts on AA products, an employee discount scheme, company-funded life assurance, and access to a 24/7 remote GP service.

Does the AA promote diversity and inclusion in the workplace?

Yes, the AA is committed to being an equal opportunities employer and actively seeks to create an inclusive environment for individuals from diverse backgrounds.

image

The AA

It's OK, when you're with the AA​

Manufacturing & Electronics
Industry
5001-10,000
Employees
1905
Founded Year

Mission & Purpose

Since 1905, we have been committed to putting drivers first with innovative thinking and award-winning services. And today we offer even more than ever. ​ We have a driving service for pretty much anything you’ll ever need. Insurance, servicing and repair, driving lessons, buying and financing cars, roadside assistance and much more. ​ Our members have an unshakeable confidence because they have a multi-service driving partner for life. So, no matter what’s around the corner, it really is OK when you’re with the AA.​