Rippling

Since 1973, Jubilee has worked to provide high quality affordable housing and holistic support to those experiencing persistent economic hardship in the Adams Morgan and Columbia Heights neighborhoods of Washington D.C. Jubilee operates 11 properties totaling 464 units of affordable housing, with another four properties and 120 units under development, and offers robust programming for residents and community members pursuing life goals.. Jubilee Housing is an innovator in financing and social services for affordable housing communities in the heart of the Nation’s Capital.. Pull datasets from Salesforce, Apricot, ETO, and Realpage Onesite database systems, process and analyze data using M.S. Excel basic and advanced formulas and features, including filtering, sorting, summarizing data tables using pivot table, etc.. Monitoring and maintaining funder and investor reporting schedules and requirements.. Knowledge of Microsoft Office Suite, database applications, data visualizations such as Tableau, or Power BI.

data analyst

The mission of Jubilee Housing is building diverse, compassionate communities that create opportunities for everyone to thrive. Since 1973, Jubilee has worked to provide high quality affordable housing and holistic support to those experiencing persistent economic hardship in the Adams Morgan and Columbia Heights neighborhoods of Washington D.C. Jubilee operates 11 properties totaling 464 units of affordable housing, with another four properties and 120 units under development, and offers robust programming for residents and community members pursuing life goals.
Jubilee Housing is an innovator in financing and social services for affordable housing communities in the heart of the Nation’s Capital. Jubilee’s model of Justice Housing is affordable to those with the fewest financial assets, located in neighborhoods where resources such as good schools, grocery stores, and public transportation are readily accessible, and near services that support residents as they pursue educational and career attainment.
Position Description
JHI is actively recruiting to fill the position of Data Analyst. This position will report to the Director of Research, Impact, and Evaluation with a close working relationship with Program teams. The person who will be a great fit for this role is detail and data-oriented and able to process and analyze data, undertake monitoring and reporting process seamlessly and in a timely manner. This role is a good fit for someone who loves to help tell the story of our organizational successes using datasets, key performance indicators and outcome measures using both quantitative and qualitative datasets pulled from database systems including Apricot, ETO, and Real Page Onesite.
Specific Duties
Navigate and work with Apricot Client Record Management software, create new forms, track changes, and provide technical support as needed by Apricot users throughout the organization.
Assist with training and troubleshooting of our data management software (training on our system will be provided!). This role is a system administrator in Apricot.
Pull datasets from Salesforce, Apricot, ETO, and Realpage Onesite database systems, process and analyze data using M.S. Excel basic and advanced formulas and features, including filtering, sorting, summarizing data tables using pivot table, etc.
Assist in Data Quality Assurance (DQA) process to ensure that all datasets meet JHI’s data quality standards including Completeness, Accuracy, and Reliability.
Pull datasets from different data sources and crosscheck/cross-reference them to ensure all data are consistent across all data sources.
Conduct regular data quality checks in coordination with program teams to ensure all data are up-to-date, of high quality and in accordance with the DQA standards.
Proactively monitor data inputs monthly to ensure all program data are on track and on time.
Prepare data to support the assessment and measurement process of all JHI’s program inputs, outputs and outcomes as outlined in Logic Models, and Strategic Planning document.
Prepare data visualizations using charts, graphs, trends, in M.S. Excel or any other Data Visualization software program.
Assembling all necessary supporting materials and documents including budget reports, outcome measurements, success stories and submit reports to funders and investors.
Monitoring and maintaining funder and investor reporting schedules and requirements.
Work collaboratively with Program Directors and Finance Department to establish timelines and deliverables to meet reporting deadlines and requirements.
Tracking progress toward organizational and programmatic outcomes and goals using Theory of Change and Logic Models.
Desired Qualifications Bachelor's degree or equivalent background, with a minimum of 3 years of experience in data analysis, research and evaluation.
Organized with high attention to detail and analytical skills.
Storyteller. Able to use both data and narrative to compellingly frame Jubilee’s successes consistent with our initial applications to funders.
Tech-savvy. Comfortable learning new technologies. Willing to learn our database systems and help others (training will be provided for you on the specific systems). Knowledge of Microsoft Office Suite, database applications, data visualizations such as Tableau, or Power BI.
Ability to read and interpret funder documents (for example, grant reporting guidelines) and help the organization comply, in partnership with other departments.
Strong writing and communication skills in English language.
Benefits include health, vision, and dental insurance, STD, LTD, and Life insurances, paid vacation, sick leave, holidays, transportation stipend and a 403b matched contribution retirement plan. Background Check and Drug Screening
Finalist(s) for this position will be subject to a drug screening and will be required to consent to a pre-employment background check as a condition of employment.
References
Please be prepared to provide 3 professional references if you are selected for this role.
Hybrid Work Model
Three-day, onsite hybrid work schedule required; agreed upon schedule with manager.
COVID-19
N/A
Jubilee Housing is an Equal Opportunity Employer
The pay range for this role is:
55,000 - 65,000 USD per year (1631 Euclid Street, N.W., # P-5 Washington DC 20009) #J-18808-Ljbffr

START NEW SEARCH