Data Architect

Required experienced Data Architect / Data modeler to join the team and undertake requirement analysis activities to map out the data across the lines of business.

The candidate will be applying knowledge of data definition, data models and data mappings across business capabilities and applications to help draw out commonalities, differences and therefore contribute to a proposed future state.

Key Activities/Responsibilities:

• Arrange and attend requirements gathering meetings and workshops with client’s business and IT stakeholders
• Gather and analyze business requirements to distil these into data requirements.
• Document data entity and key data attribute definitions for business review and approval
• Discuss and develop entity relation diagrams at a conceptual level.
• Map out data flows on the end-to-end journey through the scope of the architecture showing how data is captured and processed through business capabilities and applications.
• Map the data assets to capabilities and to applications to show data usage.
• Develop and recommend target state Data architecture.
• Contribute to an enterprise level data architecture across the financial services business for policy administration.

Skills and Experience Specification:

• The successful candidate will be an experienced data analyst and/or data modeler with a business analysis focus. Equally this role would suit a business analyst with experience and acumen for data definition and modelling.
• Good interaction and communication skills to quickly establish rapport with business and technical SME personnel at all levels.
• Excellent documentation skills to create clear business level definitions in diagrams and written form.
• Demonstrable understanding and experience of business focused data models using conceptual data modelling techniques as a key communication tool.
• Demonstrable experience of data analysis gained on BI and reporting projects, migration projects or
• Experience with a broad range of data analysis tools including a good working knowledge of SQL and use of tools such as TOAD, SQL Developer, MS Excel,
• Experience of working with data modelling tools and understanding of reverse engineering and cataloguing of technical data using data modelling and data catalogue tools.
• Experience of data quality frameworks and assessing data quality/data defects is desirable.
• Experience of master data management and reference data management implementations is desirable.
• Experience in General Insurance, ideally within specialty commercial and global Markets

Must have :

• Total 10+ yrs in Data warehouse, ETL and 2+ years experience working on end to end implementation in native cloud based DWH.
• 5+ years of experience working as a Data Architect / Data Modeler for insurance programs
• Good understanding of concepts like Micro-partitions, Warehouse, Clone, Stages(external, internal), Time travel, Cluster keys.
• Expertise in ETL using SQL, writing complex stored procedures.
• Experience with AWS & services like AWS RDS (PostgreSQL), API Gateway, VPC, IAM, CloudWatch, CloudTrail etc.
• Experience in ingesting data into Lakes / Warehouse from S3, SharePoint , APIs.
• Experience in scheduling the ingestion pipelines using Tasks, pipe, Airflow etc.
• Expertise in advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning.
• Good hands on skills in SQL, PLSQL, Unix shell scripting.
• Good communication skills.

Nice to have :

• Experience with Informatica (ETL) and SnapLogic would be an added plus.
• Has understanding/working knowledge of Big data technologies like Hadoop, Hive, Impala.
• Has experience in handling technical issues on visualization tools like Power Bi / Tableau.