8,113 total live jobs
Search jobs
Enter keyword(s):Search tips
Select job sector:
Enter Town/Country/Postcode
Enter salary range (£)
Advanced search
Register your CV
Let us make life easier for you! By storing your CV in our secure database recruiters can find YOU taking the hassle out of looking for jobs yourself.

BI (Business Intelligence) Lead
Title: BI (Business Intelligence) Lead
Category: IT/Software Development
Job type: Permanent
Job status: Full Time
More jobs like this
More jobs by this recruiter
Create jobs by email
Responsible for the management and delivery of the Business Intelligence (BI) services. Be a subject matter expert in BI, including SSRS and Excel Powerpivots. Management of data extraction into the data warehouse, ensuring that all data is complete, appropriately cleansed and delivered to agreed timelines and accuracy. Deliver insight efficiently, striving to continually improve the automated generation of reports. Strong T-SQL skills to create standards based reports and stored procedures in SQL Server. Ability to build data cubes or queries that can be reused across multiple reports or used by the business to self-generate reports within a safe environment that does not impact on production environments. In addition to the specifics above, you may be required to undertake such other duties as may reasonably be required of you in the post and department above.


5+ Years experience of SQL Server 2 including SSMS, SSAS, SSIS, SSRS). 2+ Years experience of OLTP and OLAP systems. Experience of manipulating data formats such as XML, JSON, CSV and text files. Experience with Excel especially with Power Pivots connecting to OLAP cubes. A sound understanding of T-SQL and performance tuning. A sound understanding of Kimball methodology. A sound understanding of product life cycles and release processes A general understanding of Amazon Web Services NICE TO HAVE SKILLS

AWS: Redshift, RDS, Glue, Data Pipeline, Quick Sight Any experience with financial systems especially SAP B1 is a major bonus. Any DBA experience backup/restore and DB failover procedures. Any knowledge of GitHub, Terraform, Consul, Docker, Kubernetes Any experience with Python Any visualisation/analytics tools: Tableau, Alteryx, PowerBI, Periscope Data Experience with PostgreSQL, MySQL, Oracle. Benefits

The best people deserve only THE best...

Eligible to participate in Annual Bonus scheme (discretionary based on company and personal performance) 23 days holiday per year PLUS 3 days over the Christmas period. Flexible working practices Private medical insurance Medical cash back plan Income protection insurance Life insurance Season Ticket Loans Child Care Vouchers Cycle to work Scheme Loyalty Discount Cards Weekly Fruit Drops Last Friday of each month Social Unfortunately Arts Alliance Media cannot assist with Visa Sponsorship.

Only applicants who have a full entitlement to work in the UK will be considered for this role.

As with any recruitment process, Arts Alliance Media collects and processes personal data relating to job applicants. Arts Alliance Media is committed in ensuring transparency and meeting data protection obligations.

Please take time to review our Job Applicant Privacy Notice HERE
Apply for this job
(3rd party vacancy)
If this job is not for you, why not try one of these instead?