Title: SAS Data Administrator/Analyst Lead - #00144

State Role Title: Information Technology Specialist III

Hiring Range: $100,000.00 - $120,000.00

Pay Band: 6

Agency: Dept of Human Resource Mgt

Location:Dept of Human Resource Mgmt

Agency Website:www.dhrm.virginia.gov

Recruitment Type: General Public - G

Job Duties

The Department of Human Resource Management (DHRM) is seeking a qualified individual for the position of SAS Administrator and Analyst lead within the Office of Information Technology overseeing the administration, development, requirements engineering, and management of the DHRM data warehouse. The incumbent of this position will be responsible for performing the following functions:
• Providing subject matter expertise in Data Warehouse technologies in support of the DHRM mission
• Designing, developing, and implementing Extract, Transform, Load (ETL) frameworks
• Performing SAS administration, script development, security procedures, and support for Windows based applications, software, and programs. Development, implementation, and support of automation tools to aid in the administration and management of systems and applications
• Working with the IT Operations and Development teams to provide support of the SQL Server database environment
• Interpretating and executing of client server, network, and application architectures
• Being the subject matter expert on historical data stored in our Data Warehouse and assist with reporting requests
• Compiling and analyzing data from the Data Warehouse to create/summarize for analysis
• Applying data analytics, design, and modeling tools skills to facilitate, strengthen, and execute the DHRM mission
• Working with DHRM IT team to develop Systems Architecture and Standards that promotes best practices
• Ensuring secure practices are followed and security is implemented in all processes
• Assisting in the design, development, implementation, and maintenance of multiple information systems and databases
• Identifying system production problems and implementation of corrective measures by researching code and reviewing system and program documentation and coordinating the implementation of the corrected code with the users
• Maintaining strong knowledge of DHRM application infrastructure architectures and environments
• Effectively work with the business units to analyze business requirements and provide guidance on using appropriate tools and coding techniques including statistical methodologies and data manipulation

Minimum Qualifications

Considerable knowledge of and experience with SAS system administration, installations, upgrades, and modifications to network and PC SAS configurations, script development, security procedures, management of SAS license renewals. Detailed knowledge of relational databases and supporting application design and development tools and languages. Knowledge and proficiency in SQL Server database administration. Strong knowledge of current application infrastructure architectures and environments. Considerable experience in data modelling tools and strong understanding of programming languages including SAS and R. Strong knowledge in Windows, with proficiency in SAS Base, SAS Datasets, SQL, SAS Connect, SAS Macros, and SQL Loader. Experience in writing complex SQL queries. Experience with various Data Visualization and Business Intelligence tools such as SAS VIYA, Tableau, and Power BI. Experience demonstrating analytical and problem-solving skills and working in deadline driven environment. Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional environment. High school graduate or equivalent.

Additional Considerations

Experience in the use and development of prevalent web technologies. Experience with the Microsoft Power Platform including Power BI. Experience with procurement and contract management. Knowledge of HR applications.

Special Instructions

You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to "Your Application" in your account to check the status of your application for this position.

State employees who have been affected by Policy 1.3 Layoff and possess a valid Interagency Placement Screening Form (Yellow Card) or a Preferential Hiring Form (Blue Card) must submit the card BEFORE the closing date for this position. The card may be scanned and attached to the application or faxed to (804) 371-7401. Please include your name and the position number of the fax cover sheet. AMERICORPS, PEACE CORPS, AND OTHER NATIONAL SERVICE ALUMNI ARE ENCOURAGED TO APPLY.

Commonwealth's Alternate Hiring Process
In support of the Commonwealth's commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their Certificate of Disability (COD) provided by a Certified Rehabilitation Counselor within the Department for Aging & Rehabilitative Services (DARS). Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS to get their Certificate of Disability. If you need to get a Certificate of Disability, use this link: https://www.vadars.org/drs/cpid/PWContact.aspx, or call DARS at 800-552-5019.

All applicants are subject to a background investigation. The investigation may include: fingerprint checks (State Police, FBI); local agency checks; employment verification; verification of education (relevant to employment); credit checks; and other checks requested by the hiring authority.

Contact Information

Name:

Phone:

Email:

In support of the Commonwealth's commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019.

Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.