BI Developer SQL – (SSIS, SSAS)
Quant Capital
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
- 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
- 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
Reference: WJ-747_30151817