Business Intelligence Analyst at Guardrisk

Introduction

You will be responsible for analysing, designing, and developing business intelligence solutions for internal and external stakeholders according to requirements. Deliver actionable data insights to aid client acquisition and retention efforts.

Role Purpose

You will be responsible for analysing, designing, and developing business intelligence solutions for internal and external stakeholders according to requirements. Deliver actionable data insights to aid client acquisition and retention efforts.

Requirements

• Bachelor’s degree / diploma in one of the following fields: Informatics, Computer Science, Statistics, or Information Technology
• Experience for Intermediate Full Stack BI Developer
• Minimum of 5 years’ working experience in the following:
• SSIS (essential)
• Power BI (essential)
• SSRS (essential)
• Azure Data Factories (ideal)
• Azure Synapse Analytics (ideal)
• Python / R (ideal)
• Microsoft SQL Server (essential)
• T-SQL (critical)
• SSAS (essential)
• Understanding of insurance / accounting principles will be highly beneficial
• Intensive troubleshooting knowledge
• Data story telling
• Good communication and interpersonal skills
• Dashboard development and automation (essential)
• Report development and automation (essential)
• Duties & Responsibilities
• Participate in the analysis, design, development, troubleshooting and support of the reporting and analytics platform
• Develop BI solutions usiang SQL, ETL scripting, business intelligence tools, database programming and reporting tools on the Microsoft BI Stack
• Integrate with diverse source systems (including but not limited to: In-House, Vendor-based, On-prem and Cloud-based, and Office 365)
• Work with DevOps team and participate in testing of all database-related changes and application updates
• Responsible for the day to day database development/administrative tasks which include the development of queries, views, and other database schema objects
• Automation of recurring processes and the monitoring thereof
• Maintain data model schema, hierarchy within data warehouse, and reporting systems

Competencies

• Must have prior experience developing business intelligence solutions in large or midsize companies.
• Must be able to manage multiple tasks simultaneously and react to problems quickly.
• Must be able to translate concepts and directions into practical solutions.
• Must have experience in reporting and business intelligence solutions.
• Must have development experience with relational database structures, multi-dimensional database, and data warehouse design architecture.
• Experience with mobile deployment of business intelligence desired.
• Must have experience with T-SQL.
• Must be able to develop, maintain, review and explain data models.
• Must have excellent verbal and written communication skills.
• Must be a team player.
• Understanding of the financial services industry desired, especially Insurance.
• Development experience with Microsoft BI stack (SSIS, SSRS, SSAS, SharePoint)
• Experience with dashboard design and delivery.
• Experience using QlikView and Power BI to analyze data and report conclusions.
• Experience with Python and/or R desire