Kotak Life Insurance—Senior manager - DWH - Mumbai

Job description

Description: JOB DESCRIPTION POSITION Senior Manager - Dataware Housing DESIGNATION Sr Manager/Chief Manager POSITION GRADE JOB CODE DEPARTMENT IT REPORTING POSITION VP WORK LOCATION Goregaon (East), Mumbai. Corporate office Objective of the role Key Responsibilities Weightage Development · Design, develop and improvise on the BI data mart to facilitate fast and high-end reporting & analytics · Implement Subject area mart and operational data store · Work on environment of SAS data mart and ensuring data consistency across hybrid systems · Enabling data integrity, collation & reporting standards · Develop SAS code/SAS ETL/ SAS reports · Testing and recon of reports/Dashboards Support · Responsible for broadcasting MIS at defined frequency · Perform BAU activities pertaining to ensure that all daily reports are broadcasted · Work closely with MIS manager to implement and maintain the models spanning the entire gamut of business namely Sales/Ops/Fin · Documentation of Data dictionary, ETL artefact 30 % 20 % 30 % 20 % TOTAL 100% MUST HAVE Education: Degree or appropriate professional qualification Work experience in years: 3 to 7 yrs in BFSI industry, preferably in Insurance Skills / experience required : Hands on with SQL, ETL tool, reporting tool, SAS VA 9.4 , SAS Viya, SAS EG, SAS studio