Systems and Data Analyst
City of Rockville - Rockville, Maryland, us, 20849
Work at City of Rockville
Overview
- View job
Overview
Systems and Data Analyst
role at
City of Rockville Join to apply for the
Systems and Data Analyst
role at
City of Rockville 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 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 incumbent provides data analytics, data portals and develops reports and interfaces. 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. 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 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 incumbent provides data analytics, data portals and develops reports and interfaces. 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 Functions
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. Depending on area of concentration, 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.
Preferred
Knowledge, Skills, and Abilities
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 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 accounting procedures, practices, and concepts and how they apply in an automated systems environment. 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 AMS Advantage ERP system, 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. Knowledge of vendor support services. 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. Skill in communication and presentation, including interaction with end users in an automated systems setting. Ability to understand hardware and software concepts, system security, data management, systems analysis and design, and programming techniques. Understanding of frameworks to unify data and data portals. Critical-thinking, problem solving skills
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-314-8470.
Group Insurance Plans
Health 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.
Summary of Aetna Health Plan Benefits Summary of Kaiser Permanente Health Plan Benefits Health Plan Rates
Aetna
Rockville Group: 118583-011
Member Services: (800) 445-5299 or (888) 792-3862 (Rx Services)
Web Site: http://www.aetna.com
Kaiser Permanente
Rockville Group: 4205-4 (HMO)
Member Services: (301) 468-6000 or (800) 777-7902
TTY: (301) 816-6344
Web Site: http://www.kp.org
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.
Dental Plan Rates
Guardian Dental
Customer Service: (800) 541-7846
Web Site: http://www.guardiananytime.com/
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.
Vision Plan Rates
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.
Leave
Annual 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) 451-3399
Web Site: http://www.discoverybenefits.com/
Retirement Programs
Retirement 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.
Pension Plan for Administrative Employees Pension Plan for Police Employees Pension Plan for Union Employees City of Rockville Thrift & Supplemental Plan Summary
Retirement Plan Administrator:
Lincoln Financial
Retirement Plan
Member Services: (800) 234-3500
Website: https://lincolnfinancial.com
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) 234-3500
www.lincolnfinancial.com
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-314-8470.
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) 279-1964
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-728-5768
Web Site: http://legalresources.com/
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) 327-2251
Web Site: http://www.bhsonline.com/
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 year to less than 4 years 4 years to less than 6 years 6 years or more Required Question
Seniority level
Seniority level Mid-Senior level Employment type
Employment type Full-time Job function
Job function Information Technology Industries Government Administration Referrals increase your chances of interviewing at City of Rockville by 2x Get notified about new Data Analyst jobs in
Rockville, MD . Herndon, VA $70,000.00-$75,000.00 2 weeks ago Fairfax, VA $50,800.00-$119,200.00 2 days ago McLean, VA $100,000.00-$120,000.00 2 weeks ago Data Analyst - People Analytics (Short-Term Employment)
Washington, DC $124,000.00-$176,000.00 6 days ago McLean, VA $50,000.00-$115,000.00 23 hours ago Washington, DC $62,000.00-$141,000.00 1 week ago Washington, DC $73,950.00-$100,050.00 1 week ago Bethesda, MD $112,000.00-$179,000.00 1 day ago Reston, VA $75,000.00-$100,000.00 2 weeks ago Tysons Corner, VA $81,900.00-$117,000.00 1 day ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr