Job Description :
Job Description:
This role will consult with Insurance clients to gather BI data 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 data solutions for Insurance data warehousing, analytics and big data clients.

Summary of Duties & Responsibilities:

Own the analysis, design and development of the whole data solution for Insurance data warehouses, staging, ODS, data marts, reports and analytics
Design and develop all data models conceptual, logical and physical optimized
Instantiate the physical models on SQL Server or Azure SQL Data Warehouse applying techniques to optimize for data load, data storage and data access
Design the solution to support two-way integration of data sourced from insurance systems, web-based systems and other systems as needed.
Ensure analysis and design is completed efficiently and accurately and incorporates the entire set of data requirements.
Own creation and maintenance of documentation across the entire life-cycle
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:

Insurance KPIs, and metrics, 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 servce and establish gate way refresh schedules.
Implement calculations, perspectives, hierarchy structurs, score cards and key performance indicators
5 Years Insurance BI, analytics and data warehousing projects
10 years of systems architecture experience, with a heavy emphasis on data architecture and data integration
Ensure common application architectural framework across different subject areas and conformance with best practices. Proven experience in designing and deploying conformed dimensions is a must
10 years of hands-on IT experience, to include data warehouse, business intelligence, custom development, data analytics and reporting, master data management, requirements gathering, and solutions design
Strong experience/exposure to Microsoft data management suite including SQL Server, Azure SQL DW, SSIS, SSRS, & Power BI
5 years of data profiling and data cleansing
2-3 years’ experience of a leading ETL tool and thorough understanding of data extraction, transformation and load processes and data architecture best practices.
Demonstrated ability to liaise closely with business and IT leadership to establish, defend, and persuade implementing recommended solutions
Strong communication, organizational, interpersonal and time management skills
Must work independently with minimal direction and be ability to deal with a dynamic environment
Experience leading others through the full development life-cycle
BI Certification a plus