Senior Data Engineer – Contract (€500-€550 a day)

Senior Data Engineer - Contract (SQL Server, SSIS & BIML)We have an excellent opportunity for an experienced Contract Data Engineer to support a number of business-critical data integration and automation initiatives.

This role is ideally suited to a contractor with extensive experience across the Microsoft data stack, particularly SQL Server, SSIS, and BIML, who can quickly integrate into the team and deliver high-quality solutions from day one.

The successful contractor will be responsible for designing, developing, and optimising ETL processes, automating SSIS package generation through BIML, and supporting the ongoing enhancement of the organisation's data platform. This is a hands-on delivery role requiring strong technical expertise and the ability to work independently in a fast-paced environment.

Key Responsibilities

• Design, develop, and maintain complex ETL solutions using SQL Server and SSIS.Develop and optimise SQL queries, stored procedures, views, and database objects.
• Utilise BIML extensively to automate the development and maintenance of SSIS packages.
• Design, build, and support scalable data integration pipelines.
• Optimise ETL performance and troubleshoot existing data solutions.
• Work closely with technical and business stakeholders to understand requirements and deliver robust data engineering solutions.
• Develop automation scripts using Python and PowerShell where appropriate.
• Support workflow automation using Microsoft Power
• Apps and Power Automate.
• Contribute to Azure-based data initiatives and deployment activities where required.
• Participate in source control and deployment processes using Azure DevOps.
• Ensure all solutions adhere to development standards, governance, and best practices.
• Experience6+ years' commercial experience in Data Engineering, ETL Development, or Business Intelligence.
• Extensive hands-on experience with Microsoft SQL Server.
• Strong commercial experience developing and supporting SSIS solutions.
• Proven commercial experience with BIML (Business Intelligence Markup Language) is essential.
• Demonstrable experience using BIML to automate the creation and maintenance of SSIS packages in enterprise environments.
• Strong understanding of ETL design, data integration, and data warehousing principles.
• Advanced SQL development skills, including stored procedures, performance tuning, query optimisation, and database design.
• Strong analytical and problem-solving abilities.
• Excellent communication skills and the ability to engage with both technical and business stakeholders.
• Desirable

Skills

• Experience with Microsoft Power
• Apps and Power Automate.
• Exposure to Microsoft Azure technologies, including Azure SQL, Azure Data Factory, and Azure Storage.
• Experience using Azure DevOps for source control and CI/CD pipelines.
• Python and/or PowerShell scripting experience.
• Experience working within Agile delivery environments.