Datawarehouse Developer / ETL Developer (SSIS / SSAS / SQL)

Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers.We empower car dealers and manufacturers to fully embrace digital transformation. How? By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs. We use cutting-edge technology to link our clients’ systems, departments and sites. We provide an open technology platform that’s shaping the industry for the future. We use data to help clients become more efficient, increase profitability and give more customers an amazing experience. Want to be part of it? 

Role Overview:
As an ETL/Datawarehouse Developer, you will design, build, and optimize 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 optimization, 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:

• 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.
• 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.
• 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.
• 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.

Essential skillsets

• 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.
• 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
• Performance Tuning & Troubleshooting
• Ability to implement best practices for scalability and high-performance data processing.

Why join us?We’re on a journey to become market leaders in our space – and with that comes some incredible opportunities. Collaborate and learn from industry experts from all over the globe. Work with game-changing products and services. Get the training and support you need to try new things, adapt to quick changes and explore different paths. Join Keyloop and progress your career, your way. An inclusive environment to thriveWe’re committed to fostering an inclusive work environment. One that respects all dimensions of diversity.  We promote an inclusive culture within our business, and we celebrate different employees and lifestyles – not just on key days, but every day. Be rewarded for your effortsWe believe people should be paid based on their performance so our pay and benefits reflect this and are designed to attract the very best talent. We encourage everyone in our organisation to explore opportunities which enable them to grow their career through investment in their development but equally by working in a culture which fosters support and unbridled collaboration.
Keyloop doesn’t require academic qualifications for this position. We select based on experience and potential, not credentials.We are also an equal opportunity employer committed to building a diverse and inclusive workforce.  We value diversity and encourage candidates of all backgrounds to apply.