Sr Data Analyst (SAS)

TechDigital Group; San Antonio (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking company seeking a skilled professional with extensive experience in SAS, SQL, and Tableau. In this role, you will leverage your expertise to automate SAS processes, create robust data programs, and validate data for analysis. You will also utilize your strong analytical skills and communication abilities to support multiple projects within the Banking and Insurance sectors. This position offers a dynamic work environment where you can thrive and make impactful contributions to data management and analysis. If you are passionate about data and eager to take on new challenges, this opportunity is perfect for you.

Qualifications

• 5-10 years of experience with SAS, SQL, and Tableau.
• Strong knowledge of SAS Macros and procedures.
• Experience in Banking and Insurance industry.

Responsibilities

• Rewrite SAS codes to automate various SAS processes.
• Create SAS programs and perform data validation.
• Follow SDLC methodology for SAS module design and testing.

Skills

SAS

SQL

Tableau

VBA

IBM Netezza

Aginity

Microsoft Office

Education

Bachelor's Degree in a related field

Tools

SAS Macros

Oracle

DB2

Job description

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:

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