Senior manager - DWH - Mumbai

<p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:20pt;line-height:115%;font-family:Cambria, serif;color:#C00000;">JOB DESCRIPTION</span></b></p><p><b></b></p><b></b><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p><table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-width:medium;border-style:none;"> <tbody><tr> <td width="253" valign="top" style="width:189.7pt;border:solid #C0504D 1pt;background:#EFD3D2;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;color:#000000;">POSITION</span></b></p><p></p> </td> <td width="454" valign="top" style="width:12cm;border:solid #C0504D 1pt;border-left:none;background:#EFD3D2;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> Senior Manager - Dataware Housing </span></p> </td> </tr> <tr> <td width="253" valign="top" style="width:189.7pt;border:solid #C0504D 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;">DESIGNATION</span></b></p><p><b></b></p><b></b> </td> <td width="454" valign="top" style="width:12cm;border-top:none;border-left:none;border-bottom:solid #C0504D 1pt;border-right:solid #C0504D 1pt;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;">Sr Manager/Chief Manager</span></p><p></p> </td> </tr> <tr> <td width="253" valign="top" style="width:189.7pt;border:solid #C0504D 1pt;border-top:none;background:#EFD3D2;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;color:#000000;">POSITION GRADE</span></b></p><p></p> </td> <td width="454" valign="top" style="width:12cm;border-top:none;border-left:none;border-bottom:solid #C0504D 1pt;border-right:solid #C0504D 1pt;background:#EFD3D2;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p> </td> </tr> <tr> <td width="253" valign="top" style="width:189.7pt;border:solid #C0504D 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><b><span style="font-size:12pt;">JOB CODE</span></b></p><p><b></b></p><b></b> </td> <td width="454" valign="top" style="width:12cm;border-top:none;border-left:none;border-bottom:solid #C0504D 1pt;border-right:solid #C0504D 1pt;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><span style="font-size:12pt;"> </span></p> </td> </tr> </tbody></table><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p><table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-width:medium;border-style:none;"> <tbody><tr> <td width="251" valign="top" style="width:187.9pt;border:solid #000000 1pt;background:#C0C0C0;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;color:#000000;">DEPARTMENT</span></b></p><p></p> </td> <td width="446" valign="top" style="width:334.4pt;border:solid #000000 1pt;border-left:none;background:#C0C0C0;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;color:#000000;">IT</span></p><p></p> </td> </tr> <tr style="border-left:1px solid #000000;height:20.8pt;"> <td width="251" valign="top" style="width:187.9pt;border:solid #000000 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:20.8pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;">REPORTING</span></b><span style="font-size:12pt;line-height:115%;"> <b>POSITION</b></span></p><p></p> </td> <td width="446" valign="top" style="width:334.4pt;border-top:none;border-left:none;border-bottom:solid #000000 1pt;border-right:solid #000000 1pt;padding:0cm 5.4pt 0cm 5.4pt;height:20.8pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;">VP</span></p><p></p> </td> </tr> <tr> <td width="251" valign="top" style="width:187.9pt;border:solid #000000 1pt;border-top:none;background:#C0C0C0;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><b><span style="font-size:12pt;color:#000000;">WORK LOCATION</span></b><b></b></p><p><b></b></p><b></b> </td> <td width="446" valign="top" style="width:334.4pt;border-top:none;border-left:none;border-bottom:solid #000000 1pt;border-right:solid #000000 1pt;background:#C0C0C0;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><span style="font-size:12pt;color:#000000;">Goregaon (East), Mumbai. Corporate office</span></p><p></p> </td> </tr> </tbody></table><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;">Objective of the role</span></b></p><p><b></b></p><b></b><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p><table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-width:medium;border-style:none;"> <tbody><tr style="border-left:1px solid #000000;height:23.1pt;"> <td width="572" valign="top" style="width:428.7pt;border:solid #C0504D 1pt;background:#A6A6A6;padding:0cm 5.4pt 0cm 5.4pt;height:23.1pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:14pt;line-height:115%;color:#FFFFFF;">Key Responsibilities</span></b></p><p><b></b></p><b></b> </td> <td width="124" valign="top" style="width:92.8pt;border:solid #C0504D 1pt;border-left:none;background:#A6A6A6;padding:0cm 5.4pt 0cm 5.4pt;height:23.1pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:14pt;line-height:115%;color:#FFFFFF;">Weightage</span></b></p><p><b></b></p><b></b> </td> </tr> <tr style="border-left:1px solid #000000;height:254.6pt;"> <td width="572" valign="top" style="width:428.7pt;border:solid #C0504D 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:254.6pt;"> <p class="MsoListParagraphCxSpFirst" style="margin:0cm;line-height:normal;background-size:initial;"><span style="font-size:12pt;color:#000000;">Development</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;"> Design, develop and improvise on the BI data mart to facilitate fast and high-end reporting & analytics</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Implement Subject area mart and operational data store</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Work on environment of SAS data mart and ensuring data consistency across hybrid systems</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Enabling data integrity, collation & reporting standards</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;line-height:normal;background-size:initial;"><span style="font-size:12pt;"> </span></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Develop SAS code/SAS ETL/ SAS reports</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Testing and recon of reports/Dashboards</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;line-height:normal;background-size:initial;"><span style="font-size:12pt;"> </span></p> <p class="MsoListParagraphCxSpMiddle" style="margin:0cm;line-height:normal;background-size:initial;"><span style="font-size:12pt;color:#000000;">Support</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Responsible for broadcasting MIS at defined frequency </span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Perform BAU activities pertaining to ensure that all daily reports are broadcasted</span></p><p></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;line-height:normal;background-size:initial;"><span style="font-size:12pt;"> </span></p> <p class="MsoListParagraphCxSpMiddle" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Work closely with MIS manager to implement and maintain the models spanning the entire gamut of business namely Sales/Ops/Fin </span></p><p></p> <p class="MsoListParagraphCxSpLast" style="margin-bottom:0cm;text-indent:-18pt;line-height:normal;background-size:initial;"><span style="font-size:12pt;font-family:Symbol;">·<span style="font-style:normal;font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:12pt;color:#000000;">Documentation of Data dictionary, ETL artefact</span></p><p></p> </td> <td width="124" valign="top" style="width:92.8pt;border-top:none;border-left:none;border-bottom:solid #C0504D 1pt;border-right:solid #C0504D 1pt;padding:0cm 5.4pt 0cm 5.4pt;height:254.6pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"> </p><p></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;">30 %</p><p></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;">20 %</p><p></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;">30 %</p><p></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;">20 %</p><p></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"></p><p> </p> </td> </tr> <tr style="border-left:1px solid #000000;height:2.1pt;"> <td width="572" valign="top" style="width:428.7pt;border:solid #C0504D 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:2.1pt;"> <p class="MsoListParagraph" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:36pt;line-height:normal;"><span style="font-size:12pt;">TOTAL</span></p><p></p> </td> <td width="124" valign="top" style="width:92.8pt;border-top:none;border-left:none;border-bottom:solid #C0504D 1pt;border-right:solid #C0504D 1pt;padding:0cm 5.4pt 0cm 5.4pt;height:2.1pt;"> <p class="MsoNormal" style="margin-bottom:0cm;line-height:normal;"><span style="font-size:12pt;">100%</span></p><p></p> </td> </tr> </tbody></table><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><span style="font-size:12pt;line-height:115%;"> </span></p><table class="MsoNormalTable" border="1" cellspacing="0" cellpadding="0" style="border-width:medium;border-style:none;"> <tbody><tr> <td width="696" valign="top" style="width:522.3pt;border:solid #C0504D 1pt;background:#A6A6A6;padding:0cm 5.4pt 0cm 5.4pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:14pt;line-height:115%;color:#FFFFFF;">MUST HAVE </span></b></p><p><b></b></p><b></b> </td> </tr> <tr style="border-left:1px solid #000000;height:122.95pt;"> <td width="696" valign="top" style="width:522.3pt;border:solid #C0504D 1pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;height:122.95pt;"> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:12pt;line-height:115%;">Education: Degree or appropriate professional qualification </span></b></p><p><b></b></p><b></b> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><b><span style="font-size:12pt;">Work experience in years: 3 to 7 yrs in BFSI industry, preferably in Insurance<br /> Skills / experience required : Hands on with SQL, ETL tool, reporting tool, SAS VA 9.4 , SAS Viya, SAS EG, SAS studio</span></b></p><p><b></b></p><b></b> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><b><span style="font-size:12pt;"> </span></b></p> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><br /></p><p><b></b></p><b></b> <p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;line-height:normal;"><b><span style="font-size:12pt;"> </span></b></p> </td> </tr> </tbody></table><p class="MsoNormal" style="text-align:justify;"> </p><p class="MsoNormal" style="margin-top:0cm;margin-right:-1.2pt;margin-bottom:0cm;margin-left:0cm;"><b><span style="font-size:14pt;line-height:115%;"> </span></b></p> <p class="MsoNormal" style="text-align:justify;"><br /></p>