SQL Developer

Christopher Ali; United Kingdom; Remote; GBP 50,000; Full time

Job summary

An innovative firm is seeking a skilled SQL Developer/Data Engineer to join their team remotely. In this role, you will be responsible for designing and maintaining robust database infrastructures, optimizing performance, and developing insightful reports using Power BI. You will work closely with development and DevOps teams to ensure seamless database operations and mentor junior developers in best practices. This is an exciting opportunity to contribute to impactful projects in the financial services sector while working within a collaborative and forward-thinking environment.

Qualifications

• 3-5 years of experience with MS SQL Server and T-SQL.
• Proficient in database schema design and performance tuning.

Responsibilities

• Design and maintain MS SQL Server databases and Data Warehouse.
• Develop Power BI and SSRS reports for data visualization.

Skills

MS SQL Server

T-SQL

SSIS

Azure Data Factory

Power BI

Database schema design

Performance tuning

Problem-solving skills

Documentation skills

Job description

This job description provides comprehensive information about the SQL Developer/Data Engineer role, including responsibilities, skills required, and job details. However, its formatting can be improved for better readability and engagement by properly structuring the sections and removing irrelevant content. Below is a refined version with improved formatting:

Base pay range

Direct message the job poster from Christopher Ali

*SQL Developer/Data Engineer - Remote - £50,000 p/a - MS SQL Server - Azure Data Factory - Power BI*

Christopher Ali is 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 developing and maintaining database infrastructure, reporting, and information systems.

What You'll Do :

• Design, develop, and maintain MS SQL Server databases and Data Warehouse, ensuring 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 systems.
• Develop and maintain Power BI and SSRS reports for data visualization and BI needs.
• Work with Azure SQL and managed instances, optimizing for scalability and performance.
• Assist developers in implementing CI/CD pipelines for SQL using Azure DevOps.
• Collaborate with development and DevOps teams to ensure smooth database operations and optimize complex T-SQL queries, stored procedures, and functions.
• Maintain documentation for database structures, procedures, and best practices.
• Mentor junior developers in SQL best practices and troubleshooting techniques.

Skills :

• 3-5 years of experience with MS SQL Server, SSMS, and T-SQL, with proven ability to write and optimize complex queries.
• Database schema design and performance tuning.
• Experience with Power BI and SSRS reporting tools.
• Proficiency with SSIS for ETL processing.
• Experience with Azure Data Factory and cloud-based data solutions.
• Knowledge of SQL replication strategies and data synchronization.
• Experience with Azure SQL and managed instances.
• Strong problem-solving skills and proactive issue resolution.
• Effective documentation skills for processes and schemas.

Additional Details :

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services, IT Consulting, Financial Services