Data Engineer

Isio has commenced 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 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., * Work 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 and 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).
• Create and maintain ETL processes, data mappings and 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 (technical design, review, unit testing, monitoring & alerting, source code management 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.
• Be accountable for ensuring ongoing documentation is held within Confluence and updated regularly.

• 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 queries, stored procedures and formal database design methodologies.
• Experience setting up monitoring and data quality exception handling.
• Experience managing and developing CI/CD pipelines.
• Experience working with Microsoft Azure products.
• Experience with APIs to integrate data flows between disparate cloud systems.
• Strong analytical and problem-solving skills, with the ability to work independently and collaboratively.
• Knowledge and understanding of best-practice security standards.
• Strong written and verbal communication skills, with the ability to establish credibility and develop effective business relationships.
• Ability to quickly understand information, business models and requirements.
• Awareness of regulated environments and experience of data legislation and cyber security accreditations such as GDPR, ISO27001, Cyber Essentials.
• 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.

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. The variety of work available to you will enable you to do this.

You can find out more about Isio and the benefits we offer here Isio - Careers & Benefits.

We are committed to fostering an inclusive, equitable and diverse workplace, in which our colleagues feel they belong, regardless of background or difference. We uphold the values of respect, fairness, and inclusion in our actions and decisions.

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. Isio Group is an equal opportunities employer and we welcome applications from all suitably qualified candidates.