About the job Senior Business Intelligence Developer Job Title: Senior Business Intelligence Developer Location: Houghton Estate (Hybrid) What will you do? End to End Data Solutions through Microsoft BI Stack Create and optimize advanced SQL queries for efficient data retrieval, manipulation and reporting. Create and manage stored procs, functions, views & triggers for efficient data processing Liaise with End Users & Stake Holders on adhoc requirements logged to discuss possible solutions Create Reporting, Dashboards & Value-Adding use cases based on User Requirements Automation of Manual Business & BI Processes. Task and Self Organisation on KANBAN Board and Online Log Tracking Software Assist Junior Developers with SQL/DAX Code Optimisation & QC to align with best practice. Complete the list of prioritised logs from the Business within current Sprint Cycle. Generate financial data required for Revenue Services, Financial Authority, Reserve Bank reports & Actuarial Model Point files. Administer Month End procedures and Monthly Commission runs Adhoc duties as assigned by Line Manager / Team Leader Create and update documentation for the BI environment Qualification and Experience Bachelors Degree in Computer Science, Information Technology or a related field. Microsoft Certifications in Business Intelligence and / or Data Engineering advantageous. Experience with Microsoft Azure, Cloudera, SAP HANNA advantageous. Minimum 6 Years experience as a Microsoft SQL Developer. Minimum 6 Years experience in SSIS (ETL Development), SSAS (Data Cube / Mining), SSRS (Report Development) & Power BI (Data Visualisations). Knowledge and Skills Query optimization and troubleshooting Workflow tools including Atlassian JIRA Version control tools including Azure DevOps and Team Foundation Server #J-18808-Ljbffr