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
• Attention to detail
• Quality, Compliance and Accreditation
• Business Requirements Definition
• Technologies

Personal Attributes

• Organisational savvy
• Manages complexity
• Plans and aligns
• Optimises work processes

Core Competencies

• Cultivates innovation
• Customer focus
• Drives results
• Collaborates
• Being resilient