Data Analyst and Reporting Specialist

Job Title : Data Analyst and Reporting Specialist Group: Administration Reports to: QA&A Program Compliance Manager Hours/Week: Full time (40 hours/week), generally 8-5 M-F. Occasional evening and weekend work required Compensation: $24.96- $30.26/ hour, depending on experience Benefits: Generous benefits package; see below for details Primary Work Site: Gateway Office Want to help make a difference? Our Just Future (OJF) counters the forces that keep people and communities in poverty by building relationships and assets that create opportunity - today and for future generations. We partnerwith people and communities impacted by poverty so they can achieve long-term housing and economic security. We invest in affordable housing and community assets that contribute to strong, inclusive neighborhoods. We advocatewith our community for policies and investments that expand housing and economic opportunity, eliminate wealth inequality and end poverty East Portland/East Multnomah County, Oregon is our home and the heart of our investments, advocacy and programs. Our Just Future envisions vibrant, healthy neighborhoods where all people can share in the security, hopes and advantages of a thriving, supportive community. Our Just Future operates as a nimble, financially strong organization driven by our passion, strategic goals and guiding principles. Diversity, inclusion and equity are fundamental values for Our Just Future, both internally and externally. OJF has an Anti-Oppression Diversity Committee, which serves as a sounding board for new internal policies and procedures to make sure that we're considering diversity and inclusion. It also helps with diversity-related projects, such as coordinating staff diversity training and providing ongoing input into our equity work. Our Just Future is working to end homelessness and poverty in our community because every one of us deserves a safe place to call home. What Our Just Future Can Offer You : We offer a comprehensive array of benefits in support of your physical, emotional and financial well-being. A few highlights: Employer paid premiums for employee health insurance. Generous paid time off, 13 paid holidays, a floating birthday holiday and the ability to maintain a great work/life balance. Employer paid premiums for short-term and long-term disability insurance and life insurance. Access to an employee assistance program. Flexible spending accounts for health and for dependent care. Professional development opportunities, including employee driven committees and monthly optional staff workshops. Access to wellness initiatives and resources including things such as walking groups, weekly yoga classes and workshops on stress management, self-care and healthy living. Opportunity to contribute to a 401k retirement plan with a 2% employer match after three months of employment. A six-week paid sabbatical after every seven years of consecutive employment with OJF. SUMMARY This position provides critical services to the Shelter Services Network, Community Programs for Social Justice, Career & Economic Development, and Affordable Housing Development & Programming groups by overseeing data quality, data analysis (qualitative and quantitative) and timely reporting for various funding streams. The information that this employee compiles on data accuracy, service outputs, service outcomes, and spending tracking is a major tool to streamline the efficiency and effectiveness of all programs and to ensure contract compliance. The job requires excellent time management and organizational skills and the ability to work independently because most activities need to be completed on a specific schedule, but also the flexibility to respond to requests for information or action with a short turnaround time. DUTIES & RESPONSIBILITIES Essential Provide training and technical assistance to Our Just Future direct service staff in entering accurate and timely data into HMIS, ETO, and other databases required by program funders or operations. Serve as primary ETO database administrator, including serve as liaison with Bonterra, and work with supervisors to develop custom reports and monitor staff efforts. Attend database trainings as required to stay up to date with any changes Lead efforts towards becoming a paperless agency by creating or uploading existing forms Perform data analysis, and data mining to identify challenges in opportunities to advance program development Translate data findings into clear, actionable recommendations. Assuring all dashboards and reports developed contain sufficient information (data sources used, terminology, considerations/limitations), such that stakeholders can leverage them with confidence. Manage data and reporting for multiple programs, internally and with partner agencies. Troubleshoot internally and with partner agencies regarding issues related to operating programs successfully. Work with Quality Assurance & Analysis when advocates are not keeping up with data entry or data quality responsibilities. Maintain confidentiality regarding supervision issues. Assist in compiling, tracking, and writing required outputs and outcomes, billings, and reports for funders. Reconcile Housing First, Supportive Community Programs, Shelter Services Network, and Career & Economic Development spending monthly with the Quality Assurance & Analysis Team. Investigate inconsistencies and facilitate communication when discrepancies arise. Data entry into HMIS for select programs. Assist with coordinating the annual or quarterly reporting in HMIS, SAGE, and ZoomGrants. Help the Quality Assurance & Analysis Team coordinate and create systems for reporting and tracking program results. Format and report program results monthly, quarterly, annually, and as needed to Our Just Future Board of Directors, Communications & Fundraising Group, and others. Work with the Finance team to ensure the accuracy of billings for client assistance program funding streams. Secondary Reconcile Housing First, Supportive Community Programs, Shelter Services Network, and Career & Economic Development spending monthly with the Quality Assurance & Analysis Team. Investigate inconsistencies and facilitate communication when discrepancies arise. Work with the Finance team to ensure the accuracy of billings for client assistance program funding streams. Data entry into HMIS for select programs. Assist with coordinating the annual or quarterly reporting in HMIS, SAGE, and ZoomGrants. Assist in compiling, tracking, and writing required outputs and outcomes, billings, and reports for funders. Report out OJF programs data analysis results to interested parties internally and externally Coordinate with Data Quality and Reporting Coordinator to ensure that the agency is HMIS (Homeless Management Information System) compliant. Train new staff on spenddowns, common data on the Community Programs Drive, and HMIS training in coordination with JOHS. Assess common agency needs or inaccuracies and develop and implement training tools to address those needs. Provide back-up to the QA&A team members when there is an absence Assist with any QA&A responsibilities as needed during critical periods. Attend and participate in scheduled Group, Team, and All Staff meetings. Other duties as assigned. QUALIFICATIONS The successful candidate must be able to satisfactorily perform each essential duty. The requirements listed below are representative of the knowledge and abilities required. Knowledge of: Systems and development of systems to record and report program data. A minimum of one year's experience working with database administration and data analysis both qualitative and quantitative Knowledge of Social Services programs. Social and economic issues which create poverty, working successfully with practices and techniques related to people with low income to achieve greater self-sufficiency. Ability to: Use (or learn) SAP Business Objects Present and speak to data findings in person to groups of stakeholders Ability to assess database for best practices and performance Accurately compile, analyze and interpret data. Prepare reports for funders in a timely and accurate manner. Train staff effectively Work cooperatively with all staff, interns, and volunteers. Develop and maintain productive working relationships within Our Just Future and with public and private agencies. Be culturally sensitive to diverse people seeking, receiving, and delivering services. Prepare and maintain clear, accurate, complete, and timely records and reports using Microsoft Word, Excel, and other programs as funders require. Administer the ETO internal database and create original reports for program managers. Represent Our Just Future at inter-agency and funder meetings as requested by the supervisor. Maintain professional boundaries with all persons served. Communicate effectively, clearly, responsively and in a trauma informed manner verbally as well as in all correspondence Understand and follow complex written and oral instructions, rules, and procedures; work independently and be a vital and contributing part of a team. EDUCATION and/or EXPERIENCE Any combination of education and work experience in social services or data quality and reporting totaling two years. A minimum of one years' experience working with data analysis and data systems. High-level MS Office Suite skills and willingness to learn other computer skills. Excellent mathematical and reasoning skills. LANGUAGE SKILLS Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from managers, clients, customers, and the general public. MATHEMATICAL SKILLS Ability to calculate figures and amounts such as proportions and percentages. Ability to apply concepts of basic algebra and geometry. REASONING ABILITY Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret various technical instructions in written, mathematical, or diagram form and deal with several abstract and concrete variables. TRANSPORTATION Reliable transportation is required. If the main source of transportation for the applicant is motor vehicle, the successful applicant needs a reliable automobile, current Driver's License and current automobile insurance carrying 100/300 limits of liability. PHYSICAL DEMANDS The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; and talk and/or hear. The employee frequently is required to reach with hands and arms. The employee is occasionally required to stand and walk. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, and distance vision. WORK ENVIRONMENT The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Hybrid work environment between virtual and in office is expected.