Description :

Job Summary :

- Responsible for the development, maintenance, and optimization of robust, scalable data solutions using the SAS programming language and ecosystem.

- Play a critical role in modernizing existing data pipelines by studying legacy SAS code and facilitating its migration to advanced, cloud-based data platforms.

- Work collaboratively with Analytics and IT teams to ensure the integrity of SAS Data Marts and the accuracy of data transformations throughout the ETL process.

Core Responsibilities :

SAS Development and Data Engineering :

- Design, develop, and test complex data transformation processes and data marts using core SAS components, demonstrating solid proficiency in Base SAS and SAS SQL.

- Implement and maintain ETL processes within the SAS environment, ensuring data quality, lineage, and efficient scheduling.

- Work closely with business intelligence and analytics teams to understand data requirements and translate them into efficient SAS data structures and code.

- Utilize advanced SAS techniques for data manipulation, cleaning, aggregation, and statistical reporting.

Modernization and Integration :

- Conduct comprehensive analysis and reverse engineering of existing, large-scale SAS codebases and data flows to understand business logic and dependencies.

- Actively participate in the strategic migration of SAS data marts and logic to modern data platforms (e.g., cloud data warehouses, Spark environments).

- Develop and implement integration solutions to ingest and export data from diverse enterprise sources, including relational databases, cloud databases, and APIs.

- Engage in rigorous testing and reconciliation efforts to ensure data parity and accuracy between legacy SAS systems and new target platforms post-migration.

Collaboration and Deployment :

- Work within an Agile framework, managing tasks related to development, testing, reconciliation, and subsequent production deployment of data pipelines.

- Collaborate with IT infrastructure and Data Governance teams to ensure security, compliance, and optimal performance of SAS environments and integrated systems.

- Utilize scripting languages to integrate SAS processes with enterprise scheduling and monitoring tools.

Required Technical Skills and Experience :

- Solid, professional experience of at least three plus years in hands-on SAS coding (Base SAS, SAS Macros, SAS/STAT, etc.).

- Strong, demonstrable understanding of the complete ETL process (Extract, Transform, Load) and the architecture of SAS Data Marts.

- Expertise in writing and optimizing complex SAS SQL queries and procedures for efficient data extraction and manipulation.

- Proven ability to study, interpret, and document existing legacy SAS code for the purpose of migration or re-platforming.

- Experience integrating SAS solutions with various enterprise data sources, including databases and APIs.

- Bachelors degree in Computer Science, Data Science, Engineering, or a related quantitative field.

Preferred Skills and Experience :

- Working knowledge and practical experience with Python and/or PySpark for data processing, indicating familiarity with modern data stack tools.

- Hands-on experience using SASpy for integrating SAS capabilities within Python environments.

- Direct experience with cloud databases (e.g., Snowflake, Google BigQuery, AWS Redshift) and cloud platforms (AWS, Azure, GCP).

- Familiarity with version control systems (e.g., Git) for managing SAS code changes.

- Experience in highly regulated industries (e.g., Finance, Pharma) where data governance and validation are critical.