Job Description :
Job Title: Insurance BI Consultant - Analyst/Developer

Job Description:
This role will work with Insurance clients to gather BI analytic requirements, and designs and developes solutions to provide business insights and manage business performance. This role will be responsible for the analysis, design and delivery of BI reports, dashboards and analytics solutions using BI and Data Warehousing best practices and technologies.

Summary of Duties & Responsibilities:
Owns the analysis, design and development of Insurance reports and analytics sourced from Data Marts, Data Warehouses and other traditional and unstructured data sources
Analyze, design, and ideally develop, reports and analytics as required for deployment
Perform incoming and outgoing data quality, consistency and integrity checks
Own KPI analytical data marts and contributing to data sources and pipeline architecture
Analyze, design, and ideally develop data marts to client defined measures, dimensions and facts
Work on complex data modleing and design patterns for BI reports/analytics using star scheme, tabular and multidimensional data stores
Develop and assist in system testing and training of reports, dashboards and BI solutions
Create and maintain user and technical documentation, including metadata
Apply critical thinking to resolve reporting and data issues and combine data from multiple systems
Develop proof of concepts to mock up reporting requirements
Work with development and database team members to ensure the data models created will meet the objectives of the business requirements.
Develop and document procedures and train users where needed
Participate in pre-sales, sales, training and support
Deliver on-site technical engagement with clients
Works with BI Analytics Developer, BI Architect and BI ETL Developer to design and develop the complete technical solution

Minimum Qualifications/Experience/Attributes:

5 years Insurance KPIs, and ideally in at least one business area (e.g. Actuarial, Claims ,Operations etc)
Develops Power BI Reports, Dashboards, implement complex hierarchical row level security, publish reports to power bi service and establish gate way refresh schedules.
Implement calculations, perspectives, hierarchy structurs, score cards and key performance indicators
Traditonal and cloud data warehouse environments (eg. SQL Servicer or Azure SQL Data Warehouse)
5 Years Insurance BI, analytics and data warehousing projects
2-4 years experience of the following tools (or similar): Power BI, SSRS, SSAS, SSIS Reporting
Good understanding of BI and data warehousing concepts, approaches and techniques.
Excellent communicator, both verbally and in writing.
Must deal with ambiguity and communicate effectively.
Strong Consulting skills with the ability to give presentations and lead meetings.
Creative thinker, who can come up with simple yet effective business solutions
Self-starter with ability to produce results efficiently and accurately
Great customer focus, a bias for action and confidence to own the requirements and design processes