Full Stack Bi Developer at Guardrisk

Role Purpose    

• You will be responsible for designing and developing ETL, data integration, data warehouse, performance tuning and BI reporting to deliver dashboard/reporting solutions to the business.

Requirements    

• Appropriate 3/4 year IT qualification
• Exposure to the full BI development life cycle
• 3 - 5 year experience of BI development 
• The successful candidate should have experience with SSRS, SSIS and SSAS.
• Qlickview and Power BI required
• Understanding of insurance / accounting principles will be highly beneficial
• Knowledge of Data Transformation Services, File Transfer Protocol
• Intensive troubleshooting knowledge

Duties & Responsibilities    

• Participate in the analysis, design, development, troubleshooting and support of the enterprise reporting and analytics platform
• Design, construct, test and implement reporting, visualization, and dashboard processes that present reporting at summary level with functionality to drill down into detail
• Develop BI solutions using 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
• Lead role in establishing data management best practices to ensure data accuracy and quality
• 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 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 Qlickview and Power BI to analyze data and report conclusions.
• Experience with Python and/or R desired

Closing Date: 6th, August 2022