Data Analyst Programmer

Seven Resourcing are currently recruiting for an experienced Analyst Programmer to join a dedicated Data Engineering team on an interim contract in Stafford. This is an excellent opportunity for a skilled data professional to support the delivery of critical data projects, working across SQL Server, ETL development and data warehouse solutions.

The successful candidate will be responsible for taking development tasks from a DevOps board, understanding customer requirements and delivering robust, well-tested data solutions from initial development through to troubleshooting and implementation.

The Role

As an Analyst Programmer, you will work exclusively within the Data Engineering function, supporting the delivery of key projects and helping to increase development capacity.

You will be expected to work independently on assigned tasks while collaborating closely with customers and other members of the technical team to ensure requirements are fully understood and solutions are delivered effectively.

Key Responsibilities

• Take development tasks from a DevOps board and assess the required technical work.
• Review and interpret customer requirements to determine appropriate solutions.
• Communicate with customers to clarify requirements and resolve queries where necessary.
• Work collaboratively with other members of the Data Engineering team.
• Design and develop effective ETL processes using Microsoft SQL Server and SSIS.
• Build and maintain data integration and transformation workflows.
• Develop complex T-SQL queries and stored procedures.
• Optimise SQL queries to improve performance and efficiency.
• Analyse query execution plans and identify opportunities for optimisation.
• Test ETL processes thoroughly before deployment.
• Investigate and troubleshoot issues identified during internal or customer testing.
• Make appropriate amendments to data processes based on testing and feedback.
• Ensure data solutions follow established development and data engineering best practices.
• Contribute to the development and maintenance of robust data warehouse solutions.

Essential Skills and Experience

The successful Analyst Programmer / Data Engineer will have proven experience in:

• Microsoft SQL Server
• Advanced T-SQL
• Complex SQL queries
• Stored procedures
• SQL query optimisation
• Understanding and interpreting query execution plans
• SQL Server Integration Services (SSIS)
• ETL development and data transformation
• Data warehouse principles and practices
• Data modelling and database design
• Troubleshooting and testing data solutions
• Working from development tasks or tickets through to completion
• Understanding and translating customer requirements into technical solutions

• Data Analyst Programmer or similar: 2 years (required)

Join Seven Resourcing and benefit from over a decade of expertise connecting talented professionals with rewarding opportunities across the UK. With more than 3,000 five-star reviews, an Excellent Trustpilot rating, multiple industry awards and established relationships with leading public and private sector employers, we’re committed to helping you secure your next role while providing ongoing support throughout your assignment.