Skip to Main Content

Powered by JobAps

ADMINISTRATIVE OFFICER II (C20016/231649)

Junior Business/Data/GIS Analyst

Recruitment #20-003235-0007

Introduction

This a contractual position with limited State of Maryland benefits

Work that matters. The Maryland Department of Housing and Community Development (DHCD) is a national leader in the financing and development of affordable housing and community development lending. As such, the primary function of the Community Development Administration is to encourage and support homeownership in Maryland. We are good but strive to be great. To make this happen our team needs members that will challenge the status quo, effectively communicate ideas and issues, independently bring forth practical and efficient solutions, believe change is good, and want to come to work knowing that what they do makes a difference in their neighborhood.

The Housing Economic Research Office support the mission of the Department of Housing and Community Development by providing housing, demographic and economic data with analysis/reporting to support the Governor’s agenda and its partners to finance housing opportunities and revitalize communities for Maryland citizens to live, work and prosper.

GRADE

14

LOCATION OF POSITION

7800 Harkins Rd Lanham, MD 20706

The Department of Housing and Community Development Headquarters is located in Prince George's County across from the New Carrollton Metro stop.

Free parking is available to the Department's employees on site at the present time; however, please be advised that this is subject to change. The Department is also accessible by MARC, WMATA, and other public transportation options.

POSITION DUTIES

This position works within Research as a Junior Business Data Analyst. Candidate will serve as the main point of contact (POC) between Research and IT for the ongoing development and completion of Data Warehouse called DIPPER. Position will be responsible for initial reviews of ETLs from source data into DIPPER as well as program data reconciliation in comparison with those in the DIPPER.  

The Junior Business Analyst will be the initial and main point of contact for incoming/outgoing data for the Department. The incumbent will extract, scrub and analyze the Departments data for program reporting as well as from a myriad of relevant data for Economic, Housing and Demographic data as needed for analysis and reporting.

The Junior Business Analyst will be responsible for the extraction and update of all data sets such Moody’s Economy.com, Decennial Census, American Community Survey, CHAS and HMDA, PUMs, CoreLogic Market Trends and Trac data monthly, quarterly and annually for Shortage Report, Penetration Reports and other reports as required.

The incumbent will assist Senior Analyst and Senior GIS Specialist with data sets required for all standard reporting for Research as well as for working in coordination with Director to update Annual Report tables, Economic Impact worksheets and uploads for Clean Data.

MINIMUM QUALIFICATIONS

Education: Possession of a Bachelor's degree from an accredited four-year college or university.

Experience: Two years experience in administrative or professional work.

Notes:

1. Candidates may substitute additional experience in administrative staff or professional work on a year-for-year basis for the required education.

2. Candidates may substitute additional graduate level education at an accredited college or university at the rate of 30 semester credit hours for each year of the required experience.

3. Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer involving staff work that included regular use of independent judgment and analysis in applying and interpreting complex administrative plans, policies, rules or regulations or analysis of operational programs or procedures with recommendations for improvement on a year-for-year basis for the required education and experience.

DESIRED OR PREFERRED QUALIFICATIONS

  1. Intermediate to advanced operation with Microsoft Office, particularly, Access and Excel;
  2. Knowledge/Experience with GIS software;
  3. Knowledge of SQL, Python and data visualization tools (PowerBi, Tableau) a plus;
  4. Experience working with ETL (Extraction, Transform, Load) Tools a plus;
  5. Experience working with OLAP (Online Analytical Processing) Tools a plus;
  6. Experience working with Housing Data;
  7. Bachelor’s degree in economics & finance a plus.

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.

SELECTION PROCESS

Please provide sufficient information on your application to document that you meet the minimum qualifications for this recruitment. Unofficial transcripts, certifications or diplomas to document educational or certification qualifications are required. Educational credentials from foreign countries must be evaluated by an approved education review service. This evaluation must be submitted with your application. 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.

Please note: 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.

EXAMINATION PROCESS

The examination will consist of a rating of your education, training, and experience related to the requirements of the position. You may be required to complete a qualifications supplement, or the rating may be 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.

BENEFITS

Contractual employees who work for an agency covered under the State Employee and Retiree Health and Welfare Benefits Program (the Program), have a current employment contract and work 30 or more hours a week (or on average 130 hours per month) may be eligible for subsidized health benefits coverage for themselves and their dependents. As a contractual employee, you will be responsible for paying 25% of the premiums for your medical and prescription coverage, including any eligible dependents you have enrolled. The State of Maryland will subsidize the remaining 75% of the cost for these benefits. You can also elect to enroll in dental coverage, accidental death and dismemberment insurance, and life insurance, but will be responsible to pay the full premium for these benefits.

Leave may be granted to a temporary/contractual employee who has worked 106 days in a 12 month period. This leave accrues at a rate of one hour for every 30 hours worked, not to exceed 40 hours per calendar year.

FURTHER INSTRUCTIONS

Online applications are STRONGLY preferred. However, if you wish to submit a paper application, you may mail your application and materials to:

Mr. 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 Ronnie.Hammond@maryland.gov. Please include the following information in the body of the email:

  • Attn: Mr. Ronnie Hammond, HR Business Partner
  • Your First and Last Name
  • Recruitment #
  • Classification (Job Title) of Recruitment

Incorrect application forms, or resumes in place of the application, will not be accepted. If you are interested in these positions and cannot apply online please fill out the paper application. For questions concerning these positions, please call 301-429-7418.

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.



Click on a link below to apply for this position:

Fill out the Supplemental Questionnaire and Application NOW using the Internet. Apply Online
View and print the Supplemental Questionnaire. This recruitment requires completion of a supplemental questionnaire. You may view and print the supplemental questionnaire here.
Apply via Paper Application. You may also download and complete the Paper Application here.