The aim of this role is to contribute to a vibrant, growing, Tableau installation and data warehouse, developing new reports, and working with stakeholder's right across the business to ensure their needs are met.
Purpose of Job:
Being an Architect with deep level subject matter expertise across the board, and proven ability to deliver projects in a fast paced and changing business environment.
Focus is primarily in delivering a data warehouse that is utilised by our Tableau based Analytics teams but should be available to any tooling. As such the main skills focus is SQL Server, SSIS, but the ideal candidate will need to understand end to end solutions with the aim to create Self-service environments and information sets
The Information Solutions Architect will:
Architect and design Data Warehouse infrastructure and solutions
Gather and analyse business requirements and develop technical specifications and design documents
Develop, enhance, and integrate Data Warehouses/Data Marts and Business Intelligence Solutions to Enterprise standard solutions
Develop overall strategic data architecture direction and provide a comprehensive road map for the Enterprise Data Warehouse
Perform data profiling to detect patterns, trends and anomalies to gain more in-depth understanding of data requirements and needs to ensure model is fit-for-use
Test, deploy and maintain Data Warehouses/Data Marts
Continue the redesign the Current Data warehouse and scale it up into an Enterprise level solution.
Provision of a Certified information layer for Reporting and Self-Service
Mentor the more junior team members
Qualifications, Skills and Experience
5+ years of experience with majority of exposure in Insurance working as Data Solution Architect / Data Modeller
In-depth understanding of Insurance based business model preferred In-depth SQL knowledge to enhance and develop the data architecture required to support SQL Server based applications and data warehouse environments essential.
Strong quantitative and analytic skills are required. Proven ability to quickly earn the trust of key stakeholders
Extensive experience implementing data warehousing, data architecture, & data modelling, including strong knowledge of various data modelling approaches and practices (Kimball Preferred)
Hands-on experience with complex database implementations in SQL Server 2012 onwards
In-depth understanding of data integration and interface platforms and technologies
ETL (Extraction, Transformation and Loading) experience required
Actively used Agile Scrum methodology in a Data warehouse environment
Experienced in using modelling tools Erwin & ER/Studio Data Architect