Job Description :
Job Title: Insurance BI Consultant - BI Solution Architect

Job Description:
This role will consult with Insurance clients to gather BI solution architecture requirements, and designs and develops solutions to provide business insights and manage business performance. This role will be responsible for the analysis, design and delivery of BI solutions architecture for Insurance data warehousing, ODS, reports, analytics dashboards, ETL, big data and AI for clients.

Summary of Duties & Responsibilities:

Own the analysis, design and development of the whole BI solution architecture
Provides subject matter expertise and leadership to the project team
Provide data analysis and data modeling expertise leveraging Microsoft BI technologies
Assist in logical modelling, lead implement physical design (schema, indexes, partitions, etc
Experience in designing CDC, and deploying conformed dimensions is a must
Design ETL architecture including CDC, mappings, data flows, procedures, schedules, etc.
Design OLAP and semantic layer based on the reporting requirements
Design reporting architecture and provide recommendations for reporting technology
Design the solution to support two-way integration of data sourced from insurance systems, web-based systems and other systems as needed.
Lead designing, optimizing and deploying the BI solution infrastructure
Implement data quality and data governance processes
Evaluate, recommend and implement Business Intelligence Tools
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.

Minimum Qualifications/Experience/Attributes:

10 years of systems architecture experience, with a heavy emphasis on data architecture, data integration and analytics. Microsoft 70-463 and Insurance experience a plus.
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.
5 years strong experience/exposure to Microsoft data management suite including SQL Server, Azure SQL DW, T-SQL, DAX, EDX, SSIS, SSRS, DDL and DML tuning, Power BI. Microsoft 70-463 a plus.
5 Years Insurance BI, analytics and data warehousing projects
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