*SQL Developer/Data Engineer - Remote - £50,000 p/a - MS SQL Server - Azure Data Factory - Power BI*
Christopher are recruiting a Data Engineer/SQL Developer on behalf of a client in the financial services industry.
The successful candidate will work under the supervision of the Engineering Manager and will be involved in the development and maintenance of our database infrastructure, reporting, and information systems.
What You'll Do :
Beyond the ongoing development and maintenance of the data systems, duties will also include -
* Design, develop, and maintain MS SQL Server databases and our Data Warehouse, ensuring optimal performance and reliability.
* Maintain SQL Server Integration Services (SSIS) packages for ETL processes.
* Work with Azure Data Factory (ADF) for cloud-based data processing and transformation.
* Implement SQL replication strategies and maintain data consistency across distributed systems.
* Develop and maintain Power BI and SSRS reports for data visualisation and business intelligence needs.
* Work with Azure SQL and managed instances, optimising for scalability and performance.
* Help Developers implement CI/CD pipelines for SQL development using Azure DevOps to automate database deployments.
* Collaborate with development and DevOps teams to ensure smooth database operations and with optimising complex T-SQL queries, stored procedures, and functions.
* Maintain clear and comprehensive documentation for database structures, procedures, and best practices.
* Assist in training and mentoring junior developers in SQL best practices and troubleshooting techniques.
Skills :
* 3- 5 years of experience with MS SQL Server, SSMS, and T-SQL, with a proven ability to write and optimise complex queries.
* Database schema design and performance tuning.
* Power BI and SSRS reporting tools for business intelligence solutions.
* SSIS for ETL processing and automation.
* Azure Data Factory (ADF) and cloud-based data solutions.
* SQL replication strategies and data synchronisation techniques.
* Azure SQL and managed instances for cloud database management.
* Strong problem-solving skills with a proactive approach to identifying and resolving issues.
* Ability to document processes, schemas, and best practices effectively.