Data Analyst with SAS and SQL

Role Overview

The Data Analyst is a developing professional role that applies specialty area knowledge in monitoring, assessing, analyzing and/or evaluating processes and data. Identifies policy gaps and formulates policies.

What You Will Do

Develops complex SQL queries and SAS scripts/macros to extract, transform, and aggregate datasets from relational databases and enterprise data lakes. Conducts data analysis, data reconciliation, validation, and quality assessments across multifaceted financial and transactional datasets.

Why It Might Be a Fit

Requires experience in data analysis, reporting, and database programming. Strong hands-on querying, complex joins, subqueries, analytical window functions, indexing, and query optimization skills are necessary.

Requirements

• Experience: Minimum 3+ years of hands-on professional experience in data analysis, reporting, and database programming.
• SAS: Intermediary to advance proficiency in Base SAS, SAS Macros, PROC SQL, and data step processing.
• SQL: Strong hands-on querying, complex joins, subqueries, analytical window functions, indexing, and query optimization across enterprise RDBMS +Basics of python /Spark and understanding of HIVE
• Good to have BI & Reporting Tools: Direct hands-on experience developing reports and visual dashboards in at least one enterprise reporting platform (e.g., Tableau, Power BI, Qlik, MicroStrategy, or SAP BusinessObjects).
• Domain Knowledge: understanding of banking, financial services operations, and core financial metrics.
• Analytical & Logical Capabilities: Good problem-solving, critical thinking, and structured analytical skills with keen attention to detail.

Tagged as: Data Analysis, SQL