Job description

The Regional Initiatives division specializes in providing large scale public benefit programs to low-income families in our region. We operate our programs across multiple database platforms and serve over 25,000 families each year.

Develops and maintains database queries and reporting applications to support Regional Initiatives programs. Documents reports and reporting processes, procedures, and report design.

Expected Outcomes

  • As requested, (monthly) provide data and scenarios across RI programs to locate neighbors that are enrolled in BR programs and identify other potential programs for those neighbors.
  • Locate and use existing databases outside of BR to identify neighbors that would benefit from BR administered programs and share those potential program participants with RI Leadership.
  • Provide total duplicated and unduplicated households served by each RI program and other BR programs through the program integration objectives.

CORE DUTIES AND RESPONSIBILITIES:

  • Use analytical tools, such as Excel, SQL, R, Python, and Power BI, to extract, clean, and analyze data.
  • Produce regularly scheduled and ad hoc reports to provide insight on key performance metrics and goals as set forth by the agency and/or sponsors from the private, public, or non-profit sectors.
  • Automate the reporting process where appropriate.
  • Visualize data through Excel, Power BI, or other software tool.
  • Provide analytical support to all departments within the division, including but not limited to Rental Assistance, Shelter, Rapid Rehousing, Utility Assistance, and other relevant programming as determined necessary.
  • Communicate and explain analyses and findings to program and agency staff.
  • Act as a data subject matter expert, through an understanding of the database and data structure, data collection, and use of data within Regional Initiatives Division.
  • Take immediate action to address and resolve funders, program participants, and vendor inquiries.
  • Perform other duties as may be assigned.

Qualifications

Skills

Preferred

Business Acumen: Advanced

Analytical: Advanced

Problem solving: Advanced

Behaviours

Preferred

Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well

Functional Expert: Considered a thought leader on a subject

Motivation

Preferred

Self-Starter: Inspired to perform without outside help

Education

Required

Bachelors or better in Management Information Systems or related field

Experience

Required

1-2 years: SalesForce platform; SQL developing queries for reports and data generation; report writing tools; data analytics languages such as Python and R, data visualization (such as Power BI, Python, Tableau)

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.