SAS Application Programmer

SAS APPLICATION PROGRAMMER

Division of Assessment and Accountability MODE System

State of Maryland

Contract Duration

Innosoft/Maryland State Department of Education (MSDE)

On-site at 200 W Baltimore St. Baltimore, MD 21201

12 Months with 2 one-year renewal options

In-Person

Project Overview

The SAS Application Programmer has advanced skills in SAS programming and development. Programs

and macros are developed to manipulate, analyze, and disseminate data.

Duties/Responsibilities

• Develop PROC SQL data queries to query and subset detail and summary data from the MSDE data
• warehouse, summarize detail data, combine tables using joins and set operators, and use macro
• variables in SQL.
• Develop and perform programming to manipulate data by merging, appending, and sorting
• datasets; manipulate data with functions; create custom formats; concatenate and merge tables;
• process repetitive code (DO loop and SAS array); restructure tables (PROC TRANSPOSE); and
• perform pattern matching (SOUNDEX).
• Use Macro functions and write SAS Macro programs to facilitate and automate data management
• operations.
• Use Output Delivery System (ODS) to produce RTF, PDF, HTML, and EXCEL deliverables.
• Use SAS for descriptive and inferential statistical analysis (PROC MEANS, PROC FREQ, PROC
• UNIVARIATE).
• Use PROC COMPARE to create verification PDF or RTF reports of databases and metadata stored in
• the Education Data Warehouse (EDW).
• Develop quality-assurance syntax to perform data checks to ensure correctness and integrity of
• education data.
• Collaborate with the data warehouse architect to ensure integrity of stored data in the MSDE data
• warehouse and resolve data issues.
• Perform quality review and validation of SAS programs generated by data analysts or other SAS
• programmers.
• Establish and maintain program folders of fully documented and validated SAS
• programs/macros/procedures.
• Modify/update SAS code to incorporate changes in data collection and reporting processes.
• Acquire knowledge about manuals related to MSDE data collections, gather business requirements
• for federal/state reporting, and provide recommendations.
• Resolve SAS performance problems and monitor computer resources and efficiency.

Minimum Qualifications Required

• Bachelor s degree in Computer Science, Statistics, Mathematics, Data Science, or a closely related
• field; or equivalent experience.
• 6+ years of professional SAS programming experience (Base SAS and Macro), developing production
• grade code.
• Strong PROC SQL skills and proficiency with Data Step programming, arrays, and macros.
• Hands-on experience with ODS to generate RTF/PDF/HTML/Excel deliverables.
• Proficiency with PROC MEANS, PROC FREQ, PROC UNIVARIATE, PROC TRANSPOSE, PROC COMPARE,
• and use of SOUNDEX and custom formats.
• Experience implementing data quality controls, peer review/validation, and documentation
• standards.
• Experience working with enterprise data warehouses (e.g., Oracle EDW) and large relational
• datasets.
• Base SAS Programmer and/or Advanced SAS Programmer certification, or equivalent demonstrated
• expertise.