Sr Data Analyst (SAS)

Mandatory skills: SAS E.G, VBA, SQL, IBM Netezza, Aginity, Microsoft Office, Tableau Preferred skills: SAS E.G, VBA, SQL, IBM Netezza, Aginity, Microsoft Office, Tableau Detailed Job Description: Candidate must have minimum 5-10 years of experience with SAS, SQL, Tableau. He / She must have excellent working knowledge on SAS Macros and SAS procedures. Should have familiarity with Oracle / DB2 and Host files. Must be able to rewrite SAS codes to fine-tune and automate various SAS processes. Strong communication skills and ability to work in groups as well as independently. Strong experience in coding using SQL, Procedures/Functions, SAS macros. Experience in creating SAS programs and performing data validation on raw data sets and creating data sets for analysis. Good analytical skills pertaining to understanding a business domain coupled with excellent teamwork and strong communication skills. Experience in creating test scenarios to find errors and confirm programs meet specifications. Followed System Development Life Cycle (SDLC) methodology for the design, development, implementation, and testing of various SAS modules. Capable of utilizing data management techniques like merging, concatenating, interleaving of SAS datasets using MERGE and SET statements in DATA step. Performed PROC SQL joins and worked with PROC SQL set operators to combine tables horizontally and vertically. Experience in using various MS Office tools for analyzing, arranging, and presenting data. Responsible for accessing and managing data and for performing complex queries and analysis. Producing data in various output formats including HTML, RTF, PDF, MS-EXCEL using ODS (Output Delivery System). Proven ability to support multiple projects under deadlines often with competing priorities and complexities. SAS Certification is desirable. Experience in Banking and Insurance industry.