BI Developer SQL – (SSIS, SSAS)

Overview

In this role you drive BI delivery for a high-profile fintech client, building and maintaining data pipelines and a new data warehouse. You’ll consolidate data from multiple systems to enable clear reporting and analytics, while solving data integrity issues and shaping BI solutions. You work closely with cross-functional teams to deliver scalable data products that support decision-making in a fast-paced environment. This position offers ownership, growth toward senior BI roles, and exposure to diverse clients and evolving tech.

Pay / Benefits

• career progression
• bonus structure
• limited travel within the UK
• dynamic technical environment

Responsibilities

• Prepare and integrate data from multiple systems (SQL Server, Great Plains, Netsuite, Google Analytics) for reports
• Design and maintain BI tools, databases, and outputs
• Investigate and resolve data integrity issues
• Assess data quality and suitability of source data
• Analyze data and provide actionable insights for stakeholders

Key requirements

• 4 years BI experience
• Degree in Computer Science or similar
• Strong SQL and multidimensional queries (MDX/DAX)
• ETL design/build with SSIS for data warehousing
• Experience with SSIS/SSRS/SSAS and SQL Server 2014 or later
• Ability to call APIs from SSIS to pull data
• 3+ years SQL Server experience
• Data integration from external sources via API or FTP
• Understanding of Star Schema and Kimball methodologies
• Strong Knowledge of T-SQL, stored procedures, performance optimization
• Experience with SSAS, MDX, and DAX
• Experience with Microsoft BI stack (SSIS, SSAS)
• Experience handling large data volumes

• ownership and accountability
• analytical mindset
• problem solving
• SQL Server
• SSIS
• SSAS

…