Salary: $63,891.00 - $113,151.00 Annually Location : Largo, MD Job Type: Career Job Number: 11918 Department: PGC Planning Division: Information Management Div Opening Date: 11/15/2024 Closing Date: 12/13/2024 11:59 PM Eastern Description The Prince George's County Planning Department of The Maryland-National Capital Park and Planning Commission is seeking an experienced and highly skilled Information Systems Specialist II to become part of our Data Systems team. The Department provides land use planning for the physical development of Prince George's County, Maryland. As the second most populous county in Maryland, Prince George's has a population of approximately 900,000 residents and is home to The University of Maryland at College Park, NASA Goddard Space Flight Center, and Joint Base Andrews. Prince George's County is also home to many attractions such as Northwest Stadium (formerly FedEx Field), National Harbor, and Six Flags Amusement Park. If you are interested in working for the Prince George's County Planning Department, we invite qualified candidates to apply for our Information Systems Specialist II position. This is a unique position that will focus on data analysis, quality assurance and system support related activities for the various applications used for community planning, countywide planning, and development review activities across the Department. Our ideal candidate would be interested in a position that provides the opportunity to be involved in multiple tasks to support the department, an interest in data improvement, quality assurance, validation testing, system administration and learning new technologies. This position requires strong SQL or other query language skills, a desire to analyze and improve data quality, outstanding organizational, business analysis, report writing, communication and task/project management skills. The ideal candidate will have an interest in technology and researching and training on new technology initiatives when assigned. Under direction, the employee will be responsible for responding to ad-hoc reporting requests, assisting with departmental mailings, development and maintenance of specialized databases and applications, assisting with system/software testing and implementations. Support for conversion of the existing data and implementation of the new applications will be a key job responsibility. Examples of Important Duties Under general supervision:
- Maintains the Multi and Single-Family Dwelling datasets.
- Works to maintain and improve the quality of various departmental datasets.
- Assists with maintaining, updating, querying and developing Division wide planning applications using tools such as SQL and Microsoft Access.
- Performs analytical work and generates reports from the Department's development activity, permitting, land records management systems and databases.
- Responds to ad-hoc data requests, using SQL select statements or SSRS for request fulfillment.
- Assists with analysis using the Department's enterprise-wide GIS database.
- Uses Commercial Off the Shelf (COTS) tools and databases to assist with quality assurance and data analysis requests. Examples of tools include products from CoStar, and Metrostudy.
- Assists with functional system validation, verification, testing, user training and implementation of system enhancements and new applications.
- Involvement in the migration to and implementation of new Commercial Development Application software.
- Assists with system conversion tasks, configuration, inputs and validation.
- Installs, tests, documents processes as directed by senior staff members.
- Processes Land Data File, New Construction, and Public Lands files and related reports as directed.
- Produces re-occurring weekly/monthly/quarterly/annual reports as requested.
- Assists with System Administration duties such as User Maintenance, System Access and Roles, System Configuration and System Set Up.
- Documents assigned processes, procedures and workflows.
- Assists with the requirements analysis, information gathering, workflow development, training, and user support for the Department's planning applications.
- Assists and supports senior staff with analysis projects related to land development.
- Provides application support and training for Planning Department applications and software as necessary.
- Develops departmental training material.
- Conducts research to analyze technology solutions to support planning operations and assists with the implementation of such solutions.
- Assistance with other technology initiatives as needed.
Note that this is not an IT Tier I or Tier 2 helpdesk support position. The successful candidate will primarily support data analysis and not hardware, networking, or user support. Minimum Qualifications
Bachelor's Degree in Information Systems, Computer Science, Geographic Information Systems or any related field. Two (2) years of experience in applications support and development. An equivalent combination of education and experience may be substituted, which together total six (6) years. Depending upon area of assignment, a valid driver's license in accordance with both State and Commission rules and regulations. Driver's license must be unencumbered by restrictions, revocations, suspensions, or points that could limit the employee's ability to drive Commission vehicles or perform driving duties required by the position of assignment. PREFERRED QUALIFICATIONS In addition to the minimum qualifications listed above, the ideal candidate will possess one or more of the following:
- Must be detail-oriented, full of energy for challenging tasks, and enjoy working hard in a multi-faceted position with a wide range of responsibilities.
- 5 or more years of experience with SQL or other query languages.
- 5 or more years of experience with Relational Database Management Systems.
- Experience with state and local government systems and applications including land records, development activity (Tyler, Hansen, InFor, Accela, Cityworks, etc.) permitting, and document management.
- Experience with Office 365 tools and applications including Sharepoint Online, Teams, PowerBI and other tools as part of the application suite.
- Experience with cloud-based applications.
- The ability to edit and maintain existing Access database applications.
- Professional certifications (software, database, project management)
Supplemental Information Classification Specification Information Systems Specialist II Why Prince George's Planning? Amenities:
- Telework opportunities
- Flexible schedules
- Onsite fitness center
- Complimentary access to M-NCPPC gymnasiums throughout Prince George's County
- Free parking is available for employees
- Professional development opportunities/Tuition assistance
- Positions may qualify for federal student loan forgiveness assistance
The M-NCPPC offers a competitive salary range of $63,891 to $113,151 (salary is commensurate with education and experience) at the Information Systems Specialist II level with excellent benefits including generous leave, extensive health coverage, deferred compensation plan, and employee pension plan. The Prince George's County Planning Department is conveniently located in Largo, Maryland, near Metro and I-495. May be subject to medical, drug and alcohol testing. The Maryland-National Capital Park and Planning Commission (M-NCPPC) is an Equal Opportunity Employer. We celebrate a workplace culture of diversity, equity and inclusion without discrimination or harassment on the basis of race, color, religion, sex, age, national origin, sexual orientation, marital status, disability, genetic information, gender identity, or any other non-merit factor. Applicants with Disabilities under the Americans with Disabilities Act. If you require accommodations or special arrangements due to a qualifying disability, please notify the Recruitment & Selections Services Unit at the time of application at 301-###-#### (Maryland Relay 7-1-1). M-NCPPC will make all efforts to reasonably accommodate you. THE MARYLAND-NATIONAL CAPITAL PARK AND PLANNING COMMISSION 2024 BENEFIT SUMMARY FOR MERIT SYSTEM EMPLOYEES The following benefit summary is provided for informational purposes only and is not, nor should be construed as an employment agreement with the M-NCPPC, implied or actual. It is not all-inclusive and is subject to change. Benefits listed are extended to all Merit System employees of the Maryland-National Capital Park and Planning Commission (M-NCPPC). All plans are optional except the Defined Benefit and Long-Term Disability plans. Eligibility You have 45 days from your hire date to elect your benefits. Your coverage begins on the first of the month following receipt of your enrollment forms and required documentation. Retirement Programs
- Defined Benefit Plan (Mandatory Participation) - Plan E excludes FOP members.
Plan: Employee Contribution Plan C: 9.5%*of base salary (FOP members only) Plan E: 4% of base salary up to maximum Social Security Wage Base (SSWB) and 8% in excess of SSWB.
- Deferred Compensation ICMA-RC-457 plan (Optional)
- Traditional and Roth IRAs (Optional)
Health Insurance Plans (FOP Members Pay 23% for Medical, Prescription and Dental and same as all other employees for Vision.) All other employees pay percentage below.
- Medical
- Kaiser Permanente Health Maintenance Organization (HMO) with Prescription Plan - (15%)
- UnitedHealthcare Select Exclusive Provider Organization Health Plan (EPO) - (20%)
- UnitedHealthcare Choice Plus Point of Service (POS) - (20%)
Prescription - CVS Caremark - (15%) Dental - Delta Dental PPO and DeltaCare USA HMO - (20%) Vision - EyeMed - (80% of Low Option plan paid by Commission. Any balance paid by employee.) - Low, moderate, and high options are available. Frequency of covered services differs.
Flexible Spending Accounts (Employee Pays 100%)
- Medical Account - Maximum annual contribution: $3,050
- Dependent Care Account - Maximum annual contribution: $5,000
Long-Term Disability Insurance (Mandatory Participation)
- Employee Pays 20%: Commission Pays 80% (FOP Members Pay 100%)
- Benefits paid at 66 2/3% of base salary, maximum of $6,000/month
Supplemental Long-Term Disability Insurance (Employee Pays 100%)
- Benefits paid at 66 2/3% of base salary that exceeds $108,000; capped at $216,000
Basic Life and AD&D Insurance (Employee Pays 20%: Commission Pays 80%)
- Two (2) times base salary; maximum benefit is $200,000 for each
- Automatic coverage with opt-out provision
Supplemental and Spouse/Dependent Life Insurance (Employee Pays 100%)
- Supplemental - 1,2,3,4, or 5 times base salary; maximum benefit is $750,000
- Spouse/Dependent Combination - $10,000/$5,000, $20,000/$10,000, or $30,000/$15,000
Sick Leave Bank (Contribution and Benefit hours prorated for part-time employees)
- Employees have 60 days from date of hire to enroll.
- Employee contributes 8 leave hours each year
- Annually covers up to 688 hours for own serious medical condition, and 480 hours for parental responsibilities (birthadoption or foster care), and 80-160 hours for serious medical condition of an immediate family member
Leave Programs
- Annual: 15 days per year
- Personal: 3 days per year (12-month waiting period)
- Sick: 15 days per year
- Holidays: 11 days per year
Other Benefits
- Credit Union
- Employee Assistance Plan
- Legal Services Plan
- Tuition Assistance Program
- Wellness Program
- Work-Life Program
For a more detailed description of benefits, please contact the Commission's Health and Benefits Office at ...@mncppc.org or 301-###-####. 01 What best describes your level of education?
- Some College
- Associate's Degree
- Bachelor's Degree
- Master's Degree
- Doctorate
02 Is your degree in Computer Science, Information Systems, Information Systems Management, Data Science, or a related technology field?
03 How many years of experience do you have providing Information Systems specialist services?
- No experience
- Less than 2 years
- 2 years to less than 5 years
- 5 years to less than 10 years
- 10 years to less than 20 years
- 20 years or more
04 How many years of experience do you have working with SQL or other query languages?
- No experience
- Less than 2 years
- 2 years to less than 5 years
- 5 years to less than 10 years
- 10 years to less than 20 years
- 20 years or more
05 Do you hold current professional elated technical certifications - (Oracle or other RDBMS, Project Management, Software certifications)?
06 What is your skill level with Microsoft Collaboration Software and Tools (Teams, Outlook, Excel, Sharepoint)?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
07 Do you have experience designing, creating, analyzing, and generating reports from databases?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
08 Do you have experience with local government business applications - e.g. land records, development activity, permitting, work order or asset management?
09 Do you have experience in systems administration, including creating and maintaining users accounts and performing technical support?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
10 Do you have experience with relational databases?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
11 Do you have experience with database administration?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
12 Do you have experience with quality assurance, testing, or data improvement?
- No skill/experience
- Beginner (little to no practical experience,)
- Intermediate (5 to 7 years practical experience)
- Expert (more than 7 years practical experience)
Required Question