ADMINISTRATOR II (076162)
Housing Research & GIS Analyst
|Department||DHCD - Office of Management Services|
|Date Opened||5/31/2019 2:56:00 PM|
|Filing Deadline||6/14/2019 11:59:00 PM|
|Salary||$48,034.00 - $62,343.00/year (Grade 17 base-step 9, with growth potential to $76,896.00)|
|HR Analyst||Ronnie Hammond|
This is a Skilled Service Position with full benefits.
Work that matters. Maryland Department of Housing and Community Development is a national leader in the development of affordable housing and community development lending. We are proud to be at the forefront in implementing housing policies that promotes and preserves homeownership and creating innovative community development initiatives to meet the challenges of a growing Maryland.
LOCATION OF POSITION
7800 Harkins Rd Lanham, MD 20706.
Department of Housing and Community Development Headquarters Office is located in Prince George's County across from the New Carrollton Metro stop.
This position works within the Research Department as a Housing Research Assistant & GIS Analyst to augment unit to research and analyze housing, demographic and economic issues, conduct surveys and collect data, analyze data using mathematical models and statistical techniques. Position will use data collected to prepare reports, tables, and charts that present research results as well as interpret and forecast future trends. Candidate will be expected to manage multiple projects, each with competing deadlines.
Candidate will be self- determining and be able to establish methodology for projects requiring training for mainly internal data familiarity. Position will be required to use intermediate to advanced skills in Access and Excel to dissect large datasets required for a study/project in order to meet external deadlines to the Governor’s Office as well as internal deadlines for the Secretary’s office or Program Directors.
Candidate will study historical performance/trends of our internal program and use them to make projections when required. This position must possess the ability and be familiar with advanced analytical features such as the data analysis toolpak for analysis and to run macros in order to assign data points for equitable distribution of funds to jurisdictions based on census and demographic data.
The preferred candidate will have experience using SQL or Python to script data processes including but not limited to automating data collection, scrubbing data, transforming data, and implementing improved processes. The candidate must have technical writing experience to create documentation of workflows and processes. Knowledge of data visualization tools (PowerBi, Tableau) will be a plus.
This position will help collect and scrub internal program data matching data from the Annual Report to tables in Economic Impact worksheet and to establish data consistency with Clean Data depository. This position must understand and have the ability to work with Census.gov decennial census data, American Community Survey, American Fact Finder as well navigating and extractions from BLS, Economy.com-Data Buffet, Maryland Realtor Association, to name a few required for most analysis. Work assigned may require original analysis set up using advance formula calculations - minimal template project work.
Not necessary to qualify for the position, this position may help support the GIS unit within the Housing Economic Research Office by collecting and or scrubbing program data for mapping requests for internal and external clients. Candidate must be able to create detailed maps and provides geographic (spatial) analyses using ArcGIS software (preferred), often in a fast paced environment with quick turnaround time for deliverables.
Education: A Bachelor's degree from an accredited college or university.
Experience: Four years of experience in administrative staff or professional work.
1. Additional experience in administrative staff or professional work may be substituted on a year-for-year basis for the required education.
2. Additional graduate level education at an accredited college or university may be substituted at the rate of 30 semester credit hours on a year-for-year basis for the required general experience.
3. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer involving staff work related to the administration of rules, regulations, policy, procedures and processes, or overseeing or coordinating unit operations or functioning as a staff assistant to a higher ranking commissioned officer on a year-for-year basis for the required education and experience.
Applicants who are not substituting graduate level education at the rate of 30 semester credit hours on a year-for-year basis for the required general experience must have at least two years of administrative staff or professional work experience with data analysis & standardization.
DESIRED OR PREFERRED QUALIFICATIONS
1. Two years of experience with data analysis & standardization;
2. One year of experience collecting & analyzing housing, demographic and economic data;
3. One year of experience with Geographic Information Systems (GIS) software;
4. One year of experience with Structured Query Language (SQL) and/or Python;
5. Bachelor’s Degree in Economics & Finance.
LICENSES, REGISTRATIONS AND CERTIFICATIONS
Employees in this classification may be assigned duties which require the operation of a motor vehicle. Employees assigned such duties will be required to possess a motor vehicle operator's license valid in the State of Maryland.
Please provide sufficient information on your application to document that you meet the minimum qualifications for the recruitment.
Educational credentials from foreign countries must be evaluated by an approved education review service. This evaluation may be required prior to hire. For further information, you may call International Consultants of Delaware, Inc. (302) 737-8715 or World Education Services Inc. 1-800-932-3897 or (202) 331-2925. Successful candidates will be placed on the employment (eligible) list for at least one year. Eligible list may be used to fill future vacancies of the same classification. Successful candidates must document eligibility to work in the U.S. upon hire.
The Maryland Department of Housing and Community Development is not sponsoring new employees in application of the H-1B Visa at this time due to budgetary constraints. All applicants must be legally authorized to work in the United States under the Immigration and Reform Control Act of 1986. Federal regulations prohibit H1B Visa candidates from paying sponsorship fees, all sponsorship fees must be assumed by the potential employer.
The examination will consist of a rating of your education, training, and experience related to the requirements of the position. You will be required to complete a qualifications supplement, and the rating is based on your application. Therefore, it is important that you provide complete and accurate information on your application. Report all experience and education that is related to this position. Successful candidates will be rated and placed in Best, Better and Qualified categories on the eligible list and will remain eligible for at least one year.
Additionally, because this position requires experience with analyzing and interpreting data, a test will be distributed that will identify your skill level with Microsoft Excel.
Online applications are STRONGLY preferred. However, if you wish to submit a paper application, you may mail your application and materials to:
Ronnie Hammond, Department of Housing and Community Development, Office of Human Resources, 7800 Harkins Road Lanham, MD 20706.
All application materials must be received by the filing deadline. If you are unable to upload your transcripts into the system, please send via email to firstname.lastname@example.org.
Please include the following information in the body of the email:
Attn: Ronnie Hammond, Senior HR Generalist
Your First and Last Name
Classification (Job Title) of Recruitment
Incorrect application forms, or resumes in place of the application, will not be accepted. If you are interested in the position and cannot apply online please fill out the revised paper application which can be found on JobAps.
For questions concerning this position, please call 301-429-7514.
TTY Users: call via Maryland Relay
We thank our Veterans for their service to our country, and encourage them to apply. As an equal opportunity employer, Maryland is committed to recruiting, retaining and promoting employees who are reflective of the State’s diversity.