We have an urgent role with our client State of MD. Need Locals and looking Locals who can go In Person Interview.
If Interested, please share resumes to discuss further.
SAS Application Programmer
Project Identifier MSDE
Project Name Division of Assessment and Accountability – MODE System
Client State of Maryland
Agency Maryland State Department of Education (MSDE)
Location On-site at 200 W Baltimore St. Baltimore, MD 21201
Contract Duration Teleworking is permitted at the discretion of the Supervisor
Interview Type 5 years with 2 one-year renewal options
Tentative Start Date 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.
-
Innosoft is an Equal Opportunity/Affirmative Action employer
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 productiongrade 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
Regard's
Sharon
Account Manager
Akhuratha Solutions INC
43003 Lost Farm Terrace, Leesburg - VA 20175