ETL Operator (IT FUNCTIONAL ANALYST II)

Company: State of Maryland
Location: Baltimore
Posted on: November 8, 2024

Job Description:

Introduction
This 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. This is a special appointment position that serves at the pleasure of the appointing authority. A hybrid work schedule is available.
GRADE
18
LOCATION OF POSITION
300 W. Preston Street, Baltimore, MD 21201
POSITION DUTIES
This position supports the 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 ongoing user support for 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.
  
  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 coursework 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:
  
  
• 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.
  
• 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.
  
• 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
  The ideal candidate would possess knowledge of the following:
  

• 
  
• C&R Debt Manager
  
• Pentaho Data Integration (Kettle)
  
• SQL Server Management Studio (SSMS)
  
• SQL Server Integration Services (SSIS)
  
• ServiceNow
  
• House on the Hill SupportDesk
  
• SmartBear - QAComplete
  
• Microsoft Office Suite
  
  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
  As an employee of the State of Maryland, you will have access to outstanding benefits, including health insurance, dental, and vision plans offered at a low cost. Personal Leave - new State employees are awarded six (6) personnel days annually (prorated based on start date). Annual Leave - ten (10) days of accumulated annual leave per year. Sick Leave - fifteen (15) days of accumulated sick leave per year. Parental Leave - up to sixty (60) days of paid parental leave upon the birth or adoption of a child. Holidays - State employees also celebrate at least twelve (12) holidays per year. Pension - State employees earn credit towards a retirement pension. Positions may be eligible for telework.
  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.
  #J-18808-Ljbffr

Keywords: State of Maryland, Potomac , ETL Operator (IT FUNCTIONAL ANALYST II), Professions , Baltimore, Maryland