Systems Analyst
: Job Details :

Salary: $81,458.00 - $134,406.00 Annually Location : MD 20850, MD Job Type: Full-Time Job Number: 202400104 Department: Department of Information Technology Division: I.T. Operations Opening Date: 08/08/2024 Closing Date: 12/31/2024 11:59 PM Eastern Job Summary This position is responsible for performing difficult professional and administrative work designing, implementing, and maintaining automated systems, systems programming, and database administration for software developed in-house as well as software acquired from third parties. The incumbent provides project management for assigned application development projects and oversees some technical support for existing applications. The incumbent provides data analytics, data portals and develops reports and interfaces. The incumbent also ensures that requirements analyses, specifications, programming, documentation, and testing are completed correctly, on time, and according to established standards. The incumbent is also responsible for some systems programming and database administration on one or more of the City's various software applications. The work requires a proactive approach to ensure the applications meet the needs of a wide range of users in a rapidly expanding environment. Assignments, tasks and projects are performed under general managerial direction and the work has serious impact on the objectives of the department and the work of the City as a whole. The incumbent is required to be on call and perform other duties as required. Essential Job FunctionsData Analysis

• Prepares reports, dashboards and visual displays of data to aid stakeholder's analysis and decisions.

Artificial Intelligence and Machine Learning

• Implements solutions using AI and ML to improve existing systems & processes and to bring new capabilities to the City.

System Maintenance

• Supports enterprise applications including the financial system, human resources system, and timekeeping system.
• Implements updates to enterprise applications.
• Maintains and documents system processes, accounts, and user profiles.
• Coordinates application batch processing.
• Investigates causes of performance problems and makes corrections as necessary.
• Reviews and checks system files, logs, reports, and capabilities.
• Investigates system problems and coordinates their timely resolution with vendor and hardware/network support personnel.
• Assists with disaster recovery procedures.

System Development

• Assists software development projects and provides analysis with objectives and outlined procedural approaches; performs detailed review of the end product for adherence to user requirements, development standards and documentation standards.
• Coordinates and directs project management, implementation of new applications, training, documentation, and maintenance activities.
• Assists staff with requirements analyses, system, and program specifications, writing and testing of software, and preparation of documentation.
• Assists in the drafts Requests for Proposals and other appropriate specifications for application and system software and utilities or related equipment.
• Prepares, plans, and assists in the installation of new releases for all city-wide applications.
• Ensures that requirements analyses, specifications, programming, documentation, and testing are accurately completed.

System Support

• Establishes procedures, standards, and reporting formats; trains staff and ensures that standards and procedures are being followed correctly.
• Assists end-users with problems encountered in the use of applications software.
• Assists with the training of system users.
• Assists staff and users with questions and problems regarding the above systems, or other systems related software.

Communication

• Interfaces with vendors regarding project definition, schedules, billing, and acceptance of work performed, where projects involve third-party vendors.
• Works closely with departments on related issues.
• Works directly with managers to plan and organize the implementation of automated systems schedules.
• Participates in the preparation of the division budget.
• Participates in interdepartmental committees to guide the direction of systems and processes.

Qualifications Preferred: bachelor's degree with major coursework in information systems or closely related field from an accredited university or college; and five (5) years of progressively responsible work with automated systems and programming. Knowledge, Skills, and AbilitiesPreferred:

• Experience with data analytics and reporting, data visualization.
• Familiarity with cloud-based data analytics (data ingestion, cleaning and visualization)
• Experience in R, Python and an understanding of artificial intelligence and machine learning.
• Familiarity with various systems and sub-systems including Financial, Payroll, Human Resources, General Ledger, Purchasing, Inventory, Time & Attendance, Performance Budgeting, Applicant Tracking, Procurement Card and Revenue systems.
• Understanding of frameworks to unify data and data portals.
• Critical-thinking and problem-solving skills.
• Skill in communication and presentation, including interaction with end users in an automated systems setting.

Desirable:

• Knowledge of GIS and some experience with ArcGIS Pro and ArcGIS Online.
• Understanding of accounting procedures, practices, and concepts and how they apply in an automated systems environment.
• Experience with SQL reporting in cloud and server-based environments.
• Knowledge of the hardware and software platforms currently used by the City.
• Experience with SQL reporting in cloud and server-based environments.
• Knowledge of CGI Advantage ERP system, cloud or on-premise, including AP, GL, Purchasing, Inventory, HR, Payroll, Budget, and Employee Self Service modules.
• Knowledge of Kronos Time and Attendance systems and how it relates to current financial and payroll systems.
• Familiarity with Business Objects or other data warehouse and report writing environments.
• Understanding of Excel macros.
• Experience in the area of systems analysis, including requirements analysis, general design, and detailed design.
• Familiarity with database and applications development, including coding, testing, debugging, implementation, and maintenance.
• Ability to understand hardware and software concepts, system security, data management, systems analysis and design, and programming techniques.
• Knowledge of vendor support services.

Summary of Employee Benefits The following is a brief summary of the major benefits provided to new full-time, regular employees. Part-time, regular employees working more than 20 hours per week may be entitled to these benefits on a pro-rated basis in accordance with Rockville City Laws and personnel policies and procedures. Benefits are not available to temporary employees. Details about benefits and costs for full-time and part-time employees are available by calling the Human Resources Department at 240-###-####. Group Insurance PlansHealth Insurance Participation is available in one of a number of types of health plans. The City contributes toward each plan. Participation is optional. Detailed information about each plan and the associated cost is available through the Human Resources Department. Employees may participate in one of the following plans: Aetna HMO $30/$40, Aetna HMO $30/40 Deductible, Aetna HMO Health Reimbursement Account, Aetna Point of Service, Kaiser Permanente HMO, or Kaiser Permanente Point of Service. Start date of coverage is the date of hire or the first of the following month. .Aetna Rockville Group: 118583-011 Member Services: (800) ###-#### or (888) ###-#### (Rx Services) Web Site: Kaiser Permanente Rockville Group: 4205-4 (HMO) Member Services: (301) ###-#### or (800) ###-#### TTY: (301) ###-#### Web Site: Dental Plan Employees may join the City's dental program and receive dental benefits in addition to any such benefits provided by the group health plans. The City contributes a portion of the cost of each employee's dental coverage. If dental coverage is waived, the City's contribution is reallocated toward the employee's health plan cost. Start date of coverage is the first of the month following date of hire.Guardian Dental Customer Service: (800) ###-#### Web Site: Vision Insurance City of Rockville is offers a vision plan with VSP. Members will have a $130 allowance (in-network) for lenses/frames or contacts. Go to www.vsp.com to locate a participating provider. VSP members get a 20% savings on additional glasses and sunglasses, including lens enhancements, from any VSP provider within 12 months of your last WellVision Exam. Ask your provider about Laser Vision Correction discounts as well. Group Life Insurance The City provides life insurance equal to one and one-half times an employee's base salary. There is no cost to the employee for this benefit. Employees have the option of purchasing additional supplemental life insurance coverage for self, spouse and dependent child(ren). New employees joining within their first 30 days will not be required to provide evidence of insurability. LeaveAnnual Leave Annual leave ranges from 16 to 23 days per year depending upon the length of service with the City. Leave may be used as it is accrued with the permission of the employee's supervisor. Annual leave is paid at termination after completing six (6) months of service. An employee normally accrues annual leave in the following manner: Months of Service Monthly Vacation Accrual in Hours (37.5 hrs/wk)/(40 hrs/wk) 1-24 Months 10.00 / 10.40 25-60 Months 11.53 / 12.40 61-96 Months 13.08 / 14.00 97+ Months 14.23 / 15.20 Holidays Administrative and Police employees generally receive the following eleven (11) holidays per year. New Year's Day Martin Luther King, Jr. Day Presidents' Day Memorial Day Juneteenth Day Independence Day Labor Day Veterans' Day Thanksgiving Day Thanksgiving Friday Christmas Day The City also observes all days of general and congressional elections throughout the State of Maryland. This holiday falls on even numbered years. Union employees and certain other employees may receive different holidays in accordance with the terms of a contractual agreement. Sick Leave Sick leave is earned monthly at the rate of 1.25 days per completed month of service. There is no waiting period for using earned sick leave nor is there a limit to the amount of earned sick leave that may be used in connection with any legitimate illness. Flexible Spending Accounts (FSA)Dependent Care FSA The Dependent Care FSA allows employees to set aside up to $5,000 on a pre-tax basis for eligible dependent care expenses. Prior to the beginning of each calendar year, employees estimate the amount of these eligible expenses and agree to have this amount deducted from their annual salary on a bi-weekly basis. Employees avoid paying federal, state, and Social Security taxes on the total amount of their deferral. When expenses are incurred, employees submit a receipt and are reimbursed from their account. A detailed description of the plan is available in the Human Resources Department. Medical FSA The Medical Care FSA allows employees to set aside up to $3,200 on a pre-tax basis for eligible health care expenses. Prior to the beginning of each calendar year, employees estimate the amount of these expenses and agree to have that amount deducted from their annual salary on a bi-weekly basis. Employees avoid paying federal, state, and Social Security taxes on the total amount of their deferral. An employee may use a FSA debit card to pay for eligible expenses, or may submit receipts when expenses are incurred in order to be reimbursed from their account. A detailed description of the plan is available in the Human Resources Department. Pre-tax Deductions for Health Insurance Through Section 125 of the Internal Revenue Code, pre-tax payroll deductions may be made for the City's health and dental insurance premiums. Pre-tax deductions allow employees to avoid paying Federal, State, and F.I.C.A. taxes on the amounts of these payroll deducted premiums. Wex Benefits Customer Service: (866) ###-#### Web Site: Retirement ProgramsRetirement Plan The City's retirement plans consist of a Defined Benefit and a Defined Contribution portion. Administrative and Union employees may contribute between one (1) and five (5) percent of their base salary, on a pre-tax basis, to the defined contribution portion. The deferral election is made at the time of employment and may not be changed. Therefore, employees are advised to give considerable thought to their decision of what percent to contribute. The City will make a matching contribution of 50 cents for each dollar contributed. A minimum of one (1) percent participation is mandatory. Employees have different investment fund options in which to direct contributions. The investment direction may be changed biweekly. Vesting in the Defined Contribution portion occurs at the beginning of the 3rd year. Normal retirement is age 60 or 65 depending on date of hire. The Defined Benefit portion of the retirement plan is based on a percentage of average annual salary multiplied by length of credited service. Administrative employees are required to make a mandatory one (1) percent contribution to the Defined Benefit portion of the plan. Vesting occurs after ten (10) years. Police Officers contribute 8.5 percent of their earnings on a pre-tax basis to a defined benefit pension plan. Normal retirement for police officers is permitted at the earlier of age 60 or after 25 years of service, regardless of age. Benefits at retirement are based on a percentage of final average earnings multiplied by length of credited service.Retirement Plan Administrator:Lincoln Financial Retirement Plan Member Services: (800) ###-#### Website: Deferred Compensation (457) Plan The deferred compensation plan is designed specifically for City employees, and makes it possible to defer income and the payment of income taxes on the deferred investment. The plan is not meant for short-term savings or investment purposes as monies deferred are generally not available until termination or retirement. Employees may defer the lesser of 25 percent of base salary or a minimum of $10.00 per pay up to the current IRS limit on a pre-tax basis. Roth 457 The Roth 457 is a supplemental retirement plan which is funded through employee contributions only. Employees are eligible to enroll from the date of hire. Contributions are taxed but earnings grow tax free. Lincoln Financial Member Services: (877) ###-#### Social Security Regular employees receive employer contributions to Social Security (also known as FICA). Social Security benefits are available in accordance with Federal law. For more information about benefits, contact the Human Resources Department at 240-###-####. Credit Union Employees may participate in the Sky Point Federal Credit Union, conveniently located at Courthouse Square in Rockville. This credit union also participates in Family Service Center with shared branches available throughout the metropolitan area. Services include savings and checking accounts, loans, payroll deduction, and direct deposit. Sky Point Federal Credit Union Member Services: (301) ###-#### Legal Resources Through Legal Resources, participating employees and their eligible family members can get free advice, consultation, and courtroom representation for common legal services. Member Services: 1-800-###-#### Web Site: Employee Assistance Program The City provides free, confidential counseling, assessment, and referral services to help employees deal with personal problems. Trained, certified employee assistance counselors are available 24 hours a day, 7 days a week. The Employee Assistance Program (EAP) is also available for family members who are eligible health insurance plan dependents. BHS EAP 24 hour Assistance Line (800) ###-#### Web Site: Long-term Disability Programs The City's Income Protection Plan provides long-term disability benefits for both on and off the job injuries or illnesses. Coverage for off the job injuries or illnesses is provided after one year of employment with the City. Details are available from the Human Resources Department. College Savings Plans College America is a 529 college savings plan that can help you build a nest egg for college. These plans, named after a section of the tax code, were created by Congress to offer significant tax advantages to those who invest for higher education. Details are available from the Human Resources Department. 01 Which of the following best describes your level of education?

• High School or GED
• Some College
• Associates Degree
• Bachelors Degree
• Masters Degree or Higher
• None of the Above

02 How many years of experience in automated systems and programming?

• No Experience
• Less than 2 years
• 2 years to less than 3 years
• 3 years to less than 4 years
• 4 years to less than 5 years
• 5 years or more

Required Question