Skip to Main Content

Powered by JobAps

IT FUNCTIONAL ANALYST I

Contractual ETL Operator

Recruitment #22-006043-0001

GRADE

15

LOCATION OF POSITION

300 West Preston Street Baltimore, MD 21201

POSITION DUTIES

This contractual position supports collection efforts of the Central Collection Unit, (CCU) by developing methods to increase the accuracy and efficiency of database software applications to maximize collections. The duties include:

Executing and monitoring Extract, Transform and Load (ETL) programs as scheduled. 

Executing and monitoring SQL scripts as needed. 

Monitoring SSIS automation jobs.

Providing on-going user support of CCU staff and clients through service tickets.

Adding, updating and closing system defects and change requests.  

Creating and maintaining system documentation.

Performing system migration requests.  

Assisting in the design, development, training, and testing of application systems corrections or enhancements. 

This position will serve at the pleasure of the appointing authority.

MINIMUM QUALIFICATIONS

Education: Bachelor’s degree from an accredited college or university in accounting, Finance, Business Administration, Public Administration, Human Resource Management, Information Technology, or other related fields with specific course work in the structure and use of automated information systems.

Experience:    Six months of experience providing problem analysis and ongoing user support, coordinating system development and implementation and training users on the functionality of applications for agency or statewide systems housed on mainframe or large client server platforms.

Notes: 1. Graduation from an accredited high school or possession of a high
school equivalency certificate and two years of experience providing problem analysis and ongoing user support, coordinating system development and implementation, and training users on the functionality of applications for agency or statewide systems housed on mainframe or large client server platforms may be substituted for the required education.

2. Experience responding to and resolving help desk calls from users of computers, or operating computer equipment for the purpose of data entry, word processing, spreadsheet, graphics, database or other applications may be substituted on a year-for-year basis for a high school education.

3. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in the Cyber and Information Systems classifications or Cyber and Information specialty codes in the Information Technology field of work on a year-for-year basis for the required experience and education.

DESIRED OR PREFERRED QUALIFICATIONS

Preference will be given to applicants who possess the following preferred qualification(s). Include clear and specific information on your application regarding your qualifications.

FICO Debt Manager 

Actian DataConnect Integration and/or Pentaho Data Integration (Kettle)

SQL Server Management Studio (SSMS)

SQL Server Integration Services (SSIS)

ServiceNow

House on the Hill SupportDesk 

SmartBear QAComplete

Microsoft Office

SELECTION PROCESS

Please make sure that you provide sufficient information on your application to show that you meet the qualifications for this recruitment. All information concerning your qualifications must be submitted by the closing date. We will not consider information submitted after this date. Successful candidates will be ranked as Best Qualified, Better Qualified, or Qualified and placed on the eligible (employment) list for at least one year.

EXAMINATION PROCESS

The assessment may consist of a rating of your education, training, and experience related to the requirements of the position. It is important that you provide complete and accurate information on your application. Please report all experience and education that is related to this position.

BENEFITS

Contractual employees who work for an agency covered under the State Employee and Retiree Health and Welfare Benefits Program, have a current employment contract and work 30 or more hours a week (or on average 130 hours per month) may be eligible for subsidized health benefits coverage for themselves and their dependents. As a contractual employee, you will be responsible for paying 25% of the premiums for your medical and prescription coverage, including any eligible dependents you have enrolled. The State of Maryland will subsidize the remaining 75% of the cost for these benefits. You can also elect to enroll in dental coverage, accidental death and dismemberment insurance, and life insurance, but will be responsible to pay the full premium for these benefits.

Leave may be granted to a contractual employee who has worked 120 days in a 12 month period. This leave accrues at a rate of one hour for every 30 hours worked, not to exceed 40 hours per calendar year.

FURTHER INSTRUCTIONS

Online applications are highly recommended. However, if you are unable to apply online, the paper application and supplemental questionnaire may be submitted to: Department of Budget and Management, Recruitment and Examination Division, 301 W. Preston St., Baltimore, MD 21201. Paper application materials must be received in our office by the closing date for the recruitment. No postmarks will be accepted.

For questions regarding this recruitment, please contact the DBM Recruitment and Examination Division at Application.Help@maryland.gov or 410-767-4850, MD TTY Relay Service 1-800-735-2258.

We thank our Veterans for their service to our country.

People with disabilities and bilingual candidates are encouraged to apply.

As an equal opportunity employer, Maryland is committed to recruitment, retaining and promoting employees who are reflective of the State's diversity.

For education obtained outside the U.S., a copy of the equivalent American education as determined by a foreign credential evaluation service must be provided prior to hire.