ADMINISTRATIVE OFFICER II (C20016/231649)
Junior Business/Data/GIS Analyst
Recruitment #20-003235-0007
Department | DHCD - Office of the Secretary |
---|---|
Date Opened | 2/13/2020 10:54:00 AM |
Filing Deadline | 4/2/2020 11:59:00 PM |
Salary | $19.83 - $25.56/hour (Grade 14 Base-Step 9 with promotional growth to $31.46) |
Employment Type |
Full-Time
|
HR Analyst | Ronnie Hammond |
Work Location |
Prince George's
|
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
LOCATION OF POSITION
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
- Intermediate to advanced operation with Microsoft Office, particularly, Access and Excel;
- Knowledge/Experience with GIS software;
- Knowledge of SQL, Python and data visualization tools (PowerBi, Tableau) a plus;
- Experience working with ETL (Extraction, Transform, Load) Tools a plus;
- Experience working with OLAP (Online Analytical Processing) Tools a plus;
- Experience working with Housing Data;
- Bachelor’s degree in economics & finance a plus.
LICENSES, REGISTRATIONS AND CERTIFICATIONS
SELECTION PROCESS
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
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.