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
About k0deHut
k0deHut is a technology company working on cool gigs while helping developers find their dream gigs. The gigs we provide developers are perm, temp or business-to-business. Our Gigs involve building, enhancing and fixing software.