Job description

Data Engineer Isio has commenced the journey towards a data warehouse approach to creating repeatable MI/BI and we are looking for someone to work with this solution to maintain and enhance it as business needs evolve. This will involve building and maintaining connections to Isio’s systems, ensuring the solution is designed and implemented efficiently and that reporting can be easily accessed by stakeholders. The role will report into the System Operations Manager and will work closely with IT and Business stakeholders from across Isio. This is a fantastic opportunity to help shape and influence how data is used across Isio and you'll play a central role in extending our Azure data warehouse through new system integrations, enabling deeper insights that support smarter, faster decision-making at every level of the firm. Working closely with colleagues in IT and other internal teams, notably Finance to build a roadmap of business use cases to ingest into the data warehouse to fuel reporting & dashboards. Own, monitor, and evolve the current Azure Data warehouse, developing and implementing data engineering best-practice (e.g., source-to-target mappings, coding standards, data quality, etc.), Create and maintain ETL processes, data mappings & transformations to orchestrate data integrations. Ensure data integrity, quality, privacy, and security across systems, in line with client and regulatory requirements Optimise data solutions for performance and scalability. Explore new data management and processing techniques, making recommendations where appropriate. Adhere to Isio’s software engineering best practices (e.g. technical design, review, unit testing, monitoring & alerting, source code management and review, and documentation) Become a subject matter expert and point of contact on available data within the business. Collaborate with stakeholders to understand their data needs and create data models accordingly Demonstrable experience in all aspects of the data engineering role, ideally as a senior or lead engineer. Strong, hands-on experience of Azure Data Factory for managing and orchestrating ETL processes Experience with Microsoft Fabric Products Strong SQL experience, including SQL queries and stored procedures, and formal database design methodologies Experience in setting up monitoring and data quality exception handling Strong data modelling experience Experience working with Microsoft Azure products Experience of working with APIs to integrate data flows between disparate cloud systems Modern development language coding experience Awareness of working in a regulated environment, with experience of data legislation and cyber security accreditations e.g., Expertise in Business Intelligence, ideally via Power BI for data visualization and reporting Experience of working in a financial services firm Experience of working in both Waterfall and Agile environments Microsoft Fabric Data Engineer Associate Certification Microsoft Azure Fundamentals Certification Isio is a people business, and we’re committed to helping our great colleagues gain a wide variety of experience, significant development opportunities and progression through the business . We uphold the values of respect, fairness, and inclusion in our actions and decisions. We believe that by adhering to these principles, we will create a stronger, more innovative, and supportive environment for all, as well as ensuring that the advice and support we provide to our clients is more creative, more insightful and leaves a lasting impact. We have offices across the UK and many of our roles offer a hybrid, flexible approach to work to help create a work-life balance that works for you.

Requirements