Senior Data Engineer

Aiimi has been on a journey over the past 12-18 month period to transform and implement a new data architecture, alongside optimising data capture, mastering and management processes for the organisation, in light of rapid growth, to support operational scalability, and the generation of business critical reports and analytics to drive insight and inform business decisions.  

As a Senior Data Engineer, we are looking for someone to own, manage, maintain and continuously improve this data architecture, alongside the data housed within the central data warehouse, making sure this remains secure and we are leveraging the latest technologies and tools. You will have a deep understanding of designing and implementing both analytical and transactional data models, developing robust data pipelines and ETL processes, and integrating APIs across multiple systems.

This role also involves evolving and driving best practice in the processes and standards we use to capture, master, manage, store and govern our data, so we can assure data quality (making sure insights are always reliable and valid), and also meet information security and privacy compliance requirements,

You will also be expected to lead and maintain close engagement with the Aiimi Leadership Team, and other key stakeholders across the business for the purposes of ensuring the data management, curation and transformation processes continue to meet the requirements and needs of the business, with a view in time, to transitioning this to a self-serve model whereby the business can create its own bespoke reports and analytics.

Alongside the delivery of the above, a key discipline will also be to develop the artefacts required to document Aiimi’s design and implementation approaches, from both data architecture and management perspectives (e.g. data domain model, data dictionary).

Integral to this role will also be the ongoing mentoring and management of apprentices and junior staff members, who will work alongside you to deliver to the needs of the business, and so experience in managing people is desired.

Overall you will be:

• Accountable for the conceptual and logical design, implementation, continuous improvement and ongoing operational support (and resilience / continuity) of Aiimi's enterprise data architecture
• Accountable for evolving Aiimi's best practices in master data management, developing relevant artefacts alongside this such as Aiimi's data domain and subject area model, and data dictionary, and preventing data loss as part of this
• Accountable for apprentice mentoring and support, and leading the engagement with the business around their data needs / requirements, for the purposes of delivering greater levels of value from Aiimi's data

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 5+ years of experience in data architecture, data engineering, or similar roles.
• Proven experience in designing data models (both transactional and analytical) for enterprise systems.
• Expertise in ETL/ELT pipelines and data engineering tools (e.g., Azure Data Factory, Talend, AWS Glue, etc.).
• Strong experience with API integration and managing data flows between multiple systems.
• Proficient in SQL, Python, or similar programming languages.
• Hands-on experience with cloud platforms (e.g., AWS, Azure, GCP) and data warehousing technologies (e.g., Snowflake, Redshift, BigQuery).
• Experience working with business stakeholders to gather requirements and translate them into technical solutions.
• Strong understanding of data governance, data security, and best practices for data quality.

Benefits

• 25 Days holiday (excluding bank holidays) – increasing by a day every 2 years
• Hybrid working
• Mentorship, Career Development & Training
• Benefits Package
• Wellbeing Allowance