SQL Server Developer / BI Lead - SSAS - Media - West Lon

Posted 13 September by Prism Digital
Easy Apply

SQL Server Developer / BI Lead - SSAS - Media Software, West London

Our client is a global industry leader, headed by a passionate and diligent team, who are looking for a capable SQL Server Developer / BI Leader for their head office in London. This vital role would see you lead our client to greater success in their most unique of entertainment markets.

Our client is in the media software industry vanguard, helping to modernise how their clients conduct business. Boasting a great company culture, with real potential for career growth in this role, this is a chance not to be missed!

The technical environment is certainly stimulating, with an emphasis on managing procedures in SQL Server, as well as working with OLTP/OLAP systems and Excel Powerpivots. Projects will involve an ever increasing focus on migration of data to the cloud, microservices, AWS etc.

Core duties:

  • Managing around 20 SQL Server environments (2008-2016)
  • Management of data extraction into the data warehouse, ensuring that all data is complete, appropriately cleansed and delivered to agreed timelines and accuracy
  • Delivering insight efficiently, and striving to continually improve the automated generation of reports
  • Using 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

Essential Skills and Experience:

  • SSAS experience is a must for this role. Please only apply if you have SSAS experience!
  • 5+ years' experience w/ SQL Server 2008 R2 upwards (including SSMS, SSAS, SSIS, SSRS)
  • 5+ years' experience w/ OLTP and OLAP systems
  • A sound understanding of Kimball methodology
  • A sound understanding of T-SQL and performance tuning
  • Be a subject matter expert in BI, including SSRS and Excel Powerpivots
  • Experience of manipulating data formats such as XML, JSON, CSV and text files
  • A sound understanding of product life cycles and release processes

Nice to haves:

  • Backup/Restore and DB failover procedures
  • Redgate Toolbelt
  • Experience with other databases, incl. Postgres, MySQL, and Oracle
  • Experience with SQL Extended Procedures
  • Any experience with financial systems, especially SAP, is a major bonus
  • Any experience of AWS

Benefits:

  • 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

You must be eligible to work full-time in the UK to be considered. Apply ASAP for success!

SQL Server Developer / BI Lead - SSAS - Media Software, West London

Required skills

  • Business Intelligence
  • SSAS
  • SQL Server Developer
  • BI Lead

Reference: 36109857

Bank or payment details should not be provided when applying for a job. reed.co.uk is not responsible for any external website content. All applications should be made via the 'Apply now' button.

Report this job