SQL Developer

LevyAssociates; United Kingdom; Remote; GBP 40,000 - 80,000

Job description

Company Overview:

Join a forward-thinking organisation dedicated to leveraging data to drive business success. We are seeking a SQL Developer with deep expertise in Data Warehouse development (ETL using SSIS and SSAS Multidimensional for advanced analytics). This role is critical in optimising our data architecture, ensuring high performance, and delivering scalable analytics solutions.

Job Summary:

As a SQL Developer, you will design, build, and optimise data warehouse solutions, ensuring efficient ETL processes and high-performing SQL Server databases. You will leverage SSAS Multidimensional to enable advanced analytics and work on query optimisation, performance tuning, and troubleshooting to maintain system efficiency. Collaborating with analysts, BI developers, and key stakeholders, you will play a pivotal role in delivering robust and scalable data solutions that support business intelligence and reporting needs.

Key Responsibilities:

1. Data Warehouse Development & ETL
   
   • Design, develop, and maintain scalable Data Warehouse solutions using SQL Server.
   • Implement SSIS ETL processes to ensure efficient data extraction, transformation, and loading.
   • Ensure data integrity, security, and consistency across multiple environments.
2. SSAS Multidimensional & Advanced Analytics
   
   • Design and implement SSAS Multidimensional models for analytical reporting.
   • Write and optimise MDX queries for advanced data retrieval and performance.
   • Ensure the scalability and efficiency of OLAP cubes and analytical models.
3. Performance Optimisation & Troubleshooting
   
   • Optimise SQL queries, stored procedures, and indexing strategies to enhance performance.
   • Diagnose and resolve performance bottlenecks in data processing and analytics workloads.
   • Continuously monitor and fine-tune database performance for optimal efficiency.
4. Collaboration & Best Practices
   
   • Work closely with BI developers, analysts, and business stakeholders to align data solutions with business needs.
   • Establish and enforce best practices for query optimisation, ETL processes, and data modelling.
   • Stay updated on emerging technologies and methodologies to improve data architecture.

Required Skills and Experience:

1. SQL Server & Data Warehouse Expertise
   
   • Extensive experience in SQL Server development, including stored procedures, indexing, and database optimisation.
   • Proven expertise in Data Warehouse design, ETL, SSIS, and performance tuning.
   • Strong understanding of star and snowflake schemas for data modelling.
2. SSAS Multidimensional & Query Performance
   
   • Hands-on experience with SSAS Multidimensional, including MDX query development and cube optimisation.
   • Ability to design OLAP cubes for efficient data retrieval and reporting.
3. Performance Tuning & Troubleshooting
   
   • Ability to implement best practices for scalability and high-performance data processing.
4. Additional Skills (Desirable)
   
   • Experience with SSRS for reporting and SSIS for ETL.
   • Familiarity with cloud-based SQL solutions (Azure SQL, AWS Redshift, etc.).
   • Knowledge of Big Data technologies or Power BI is a plus.
   • Expertise in query performance tuning, execution plans, and indexing strategies.
   • Experience identifying and resolving database performance issues and bottlenecks.