Community HousingWorks is looking for Business Intelligence Analyst to track, maintain and meet compliance needs for our Grants and continuous funding requirements. This individual will also be responsible for creating and releasing regular reports, both internally and externally. The reports measure the health of the portfolio and help maintain compliance. This individual will be assisting with updating and reporting on existing asset information and real estate in development.
This role will create, develop and maintain Business Intelligence solutions for the organization. This member of the BI team will collaborate with departments/teams for the purpose of collecting data and executing the company’s mission. It also includes the creation and maintenance of documentations of designs, requirement and user manuals pertaining to Business Intelligence solutions. Interaction with all internal functions as well as external suppliers of information will be an important part of this role. Expertise in visualization tools such as Power BI will be a crucial skill for this role.
Essential Duties and Responsibilities
Create automated processes for the import of data from external databases relevant to internal systems
Develop metrics for Demographics and Properties Analysis
Use techniques such as Rest API and other API-like process to move and aggregate data
Prep, ingest, cleanse and maintain data in the data warehouse for efficient delivery to Power BI
Assist in generating Real Estate Development Planning Tool on a quarterly basis (DPT)
Generate Portfolio Statistics Report (Monthly) to include re-design as needed
Export and Import data from and to the ETO Database on an as-needed basis
Adapt and become proficient in databases in-house (DPT, SharePoint, and BI internal Property Database)
Participate in weekly Department meetings and one on ones
Process, prepare and design a real estate portfolio database
Assist in the daily support of end-users ability to effectively and efficiently utilize reporting platform
Competencies and Qualifications:
The competencies listed below are representative of the knowledge, skills, and/or ability required to meet or exceed the minimum job requirements. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Identifying historical 12 month trends with real estate asset holdings - such as income, expenses and debt services
Detailed data review and reporting
Strong knowledge base in basic statistics and statistical reporting, such as identifying average and medians or area median Income vs. average income
Ability to query data to match pre-determined needs
Auditing peer reports
Able to adapt reporting design in order to meet stakeholders needs.
Exceptional attention to detail
Analytical; inquisitive by nature
Ability to handle large amounts of data and present and interpret
Self-motivated to assist with department team members autonomously and can plan own workload effectively to make and meet deadlines
Expert in data aggregation tools such as Excel and Phyton
Experience building complex report in Power BI, Tableau or similar platforms
Education and Experience:
Expertise in Excel, Power BI and Tableau
Familiarity with relational database concepts, Access
Experience downloading and uploading datasets from external interphases
Ability to discuss concepts and issues and purpose alternatives within department and with Stakeholders
Knowledge of real estate concepts for multi-family properties desired
Knowledge of affordable housing nuances a plus
Other Work-related Requirements:
Evidence of ability to work legally in the United States.
Valid driver's license and regular availability of an insured vehicle to travel within the San Diego County area.
The nature of the works is such that onsite, daily attendance is required during normal business hours, with the occasional weekends as requested for special events.
CHW offers employees generous benefits, including:
Medical, Dental and Vision Plan
401(K) with company matching contributions
Life Insurance, Short and Long Term Disability
FSA (Flexible Spending Account)
Paid time off
11 Paid holidays
EAP (Employee Assistance Program)
In addition to those benefits outlined above, CHW employees have access to a variety of other benefits to customize a benefit package that meets their individual needs. Examples of these benefits include Identify Theft Protection, Hospital Indemnity, Accident or Critical Illness Insurance, and ID Legal Shield Services Plan.