Data Engineer

Isio; Birmingham; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A consulting firm is seeking a Data Engineer in Birmingham. You will be responsible for managing the Azure data warehouse and implementing data engineering best practices. The ideal candidate should have extensive experience with Azure Data Factory, strong SQL skills, and a collaborative mindset to work with various stakeholders. This role offers significant opportunities for professional growth in an inclusive work environment.

Benefits

Significant development opportunities

Flexible work approach

Inclusive workplace environment

Qualifications

• Demonstrable experience as a senior or lead data engineer.
• Strong experience managing ETL processes.
• Experience working with Microsoft Azure products.

Responsibilities

• Build and maintain connections to systems for the data warehouse.
• Own, monitor, and evolve the current Azure Data warehouse.
• Create and maintain ETL processes for data integrations.

Skills

Azure Data Factory

Strong SQL experience

Data modelling experience

Analytical and problem-solving skills

APIs for data integration

Tools

Microsoft Fabric Products

Power BI

CI/CD pipelines

Job description

Overview

We're growing and want you to be a part of our journey. 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.

Role & Responsibilities

• 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.), working closely with the external party who setup the environment
• 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
• Be accountable for ensuring ongoing documentation in held within Confluence and updated and maintained on a regular basis

Key Skills & Experience

Essential

• 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 managing and developing CI/CD pipelines
• Experience working with Microsoft Azure products
• Experience of working 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 practise security standards
• Strong written and verbal communication skills, with the ability to establish credibility and develop effective business relationships with colleagues
• The ability to quickly understand information, business models and business requirements

Desirable

• Modern development language coding experience
• Awareness of working in a regulated environment, with experience of data legislation and cyber security accreditations e.g., 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
• Microsoft Azure Fundamentals Certification

What we offer you

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 that'll be 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 .

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

If you think you may require a reasonable adjustment to be made for any reason at any stage of your recruitment process, please email [e-mail]

Department IT Locations Birmingham Remote status Hybrid Employment type Full-time