Here at AIS, we have an exciting opportunity available for a Data Engineer to join our IT team based in Solihull. You will join us on a full-time, permanent basis, and in return you will receive a competitive salary, depending on experience. AIS is the UK's and Ireland's leading fashion, home and leisure buying group with a membership of 280 independent department stores and specialist retailers. We're a membership of buying power, creativity an expertise! As our Data Engineer you will be responsible to provide project and business-as-usual support for all data related systems within the business to deliver the requirement through the development configuration and implementation of appropriate solutions. Main Duties and Responsibilities Data Engineering & Architecture Develop deep expertise in the organisation’s data landscape, ensuring strong understanding of all core data sources and analytics assets. Design, build and maintain data warehouses, data models and storage solutions that support scalable analytics. Create, optimise and maintain ETL/ELT pipelines to ensure reliable, high‑quality data flows across systems. Build and manage semantic models, datasets and reporting cubes to support consistent business reporting. Ensure all data solutions follow best practice for security, governance, performance and maintainability. Business Support & Collaboration Act as a key point of contact for incoming reporting, analytics and data‑related requests. Work closely with internal teams to gather requirements and support the design and delivery of new or enhanced data solutions. Liaise with third‑party software and service providers to support integrations, troubleshooting and system improvements. Provide clear communication to non‑technical stakeholders, translating technical concepts into accessible language. Operational Excellence Perform root‑cause analysis for recurring or business‑critical data incidents, implementing long‑term fixes. Support testing, validation and release of application updates and enhancements. Prioritise and manage workload effectively, balancing BAU tasks, support tickets and project work. Conduct routine system and performance monitoring, escalating issues where appropriate. Maintain high‑quality documentation for data processes, systems and departmental standards. General Undertake any additional duties required to support the Data & Insights function and wider business objectives. Skills & Experience Required Strong technical understanding of data systems and IT applications. Proficiency with SQL Server, including advanced query writing and optimisation. Recent hands‑on experience with Microsoft Fabric and Power BI. Experience working with third‑party suppliers or software vendors. Excellent troubleshooting and analytical skills. Professional approach to customer service and stakeholder engagement. Desired Experience working with EDI formats. Knowledge of Jet Reports. Experience or understanding of Microsoft PowerApps. User Acceptance Testing (UAT) experience. Personal Attributes Professional, reliable and able to represent the IT and Data function confidently. Strong communication skills, with the ability to explain technical concepts clearly to non‑technical audiences. Effective time‑management skills, able to meet deadlines and manage competing priorities. Self‑motivated, enthusiastic and proactive in identifying improvements. Curious and solution‑oriented, with a willingness to explore new technologies and approaches. Detail‑focused, structured and consistent in applying requirements and standards. Capable of producing high‑quality documentation and management information. Positive, “can‑do” attitude with a focus on delivering outcomes. Able to embody and promote the company’s values and brand attributes. Benefits| Rewards| Wellbeing: 25 days holiday bank holidays (in a full leave year, pro rata for part time employees) Opportunity to buy additional annual leave (up to 10 days per leave year) Birthday leave - no one should work on their birthday so have the day off on us! Company pension scheme Employee Wellbeing Scheme & Employee Assistance Programme (EAP) Cycle to work scheme Charity / volunteering Leave Free employee parking Onsite catering service (subsidised rate for employees) Access to discounts and staff sales Employee engagement calendar and activities throughout the year If you feel you have the skills and experience needed to become the Data Engineer at AIS then please click 'apply' today! We'd love to hear from you.