Sr Data Analyst

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 performed data validation on raw data sets and created data set for analysis.

• Good analytical skills pertaining 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