Deputy Manager, Financial Reporting & Accounting

  • Company:
    XL Catlin
  • Location:
  • Salary:
    negotiable / month
  • Job type:
    Full-Time
  • Posted:
    2 weeks ago
  • Category:
    Insurance

Skill: information technology , data warehousing , sql , database , ssas , data quality , dwh , system architecture , ssis; Exp: 5-8 years; Deputy Manager, Financial Reporting & Accounting ( Job Number 13003500D20180918 ) DISCOVER your opportunity Development of high quality database solutions Develop, implement and optimize stored procedures and functions using T-SQL Creation of cubes on DWH (Dimensional & Fact tables) model. Review and interpret ongoing business report requirements Research required data and Build appropriate & useful reporting deliverables. Analyze existing SQL queries for performance improvements. Develop procedures and scripts for data migration. Develop as a Data expert to provide extended support to various global stakeholders for any adhoc requests. Prepare Source to Conforming Layer data reconciliations and publish results as requested. Ensure data related control processes are adhered to and make recommendations for improvements in Data. Support conversion/Integration activities, perform impact assessment and work with different teams for any data clean-up projects. Support business specification development for any new system deployment and/or enhancements to existing systems. Perform User and/or Business Validation Testing (UAT/BVT). Includes extraction of data, review results during vairous stages i.e. DEV, UAT, BVT and document results and provide / cordinate sign-offs. Work on any ad-hoc activities or projects as assigned and be open for travelling to support business needs. SHARE your talent Four year degree in Information Technology (preferred) 5 years of working experience on Data Warehousing/Reporting projects. Solid Insurance and/or Reinsurance knowledge (required) preferably obtained through experience at an insurance company, reinsurance company, agency or consulting firm. Familiarity with data representation and manipulations within at least one of assigned source systems (preferred). Finance system architecture and dataflow knowledge or the ability to acquire this knowledge quickly (preferred). Experience with one or more data management disciplines such as Data Governance, Master Data Management, Data Quality, Data Warehousing, Reporting etc. (required). Robust analytical skills (required). Expertise in T-SQL, SSIS, SSAS, Stored procedures, Performance tuning SQL quires. Strong understanding of Star and Snowflake Schemas, SCDs, Dimensional Modelling, Data Warehousing Ability to work independenttly in a fast paced environment, prioritize and adapt to changing requirements. Strong organizational, time management, multi-tasking and coordination skills (required). Excellent written and verbal communication skills (required).

Data Warehousing

Degree: 

Experience: 5-8

Function: IT Software : Software Products & Services