Database Coordinator - Full-time

About US

Homeward Trust Edmonton (HTE) is a not-for-profit organization charged with ending homelessness in Edmonton. Our efforts are guided by community need and priorities as outlined in Edmonton’s Plan to Prevent and End Homelessness. We have a dynamic work environment, filled with high-energy, dedicated, and passionate people.
 
Homeward Trust coordinates and provides resources for local efforts to address homelessness and its devastating impacts on individuals, families, and communities. We work with agencies, neighborhoods, mainstream systems, community members, and all orders of government in pursuit of this singular objective, grounded in the belief that we can, and will, end homelessness in Edmonton. Homeward Trust is proud our community is recognized both nationally and internationally as a leader in this work.
 

Our programs involve both housing (capital project funding, property management and sourcing access to new or existing units for client use) and supportive services for individuals in or seeking access to housing programs. We believe in finding housing accommodations first and then establishing the individualized supports required by the client to remain in a home.

For further information visit: http://homewardtrust.ca/.

Position Summary

The Database Coordinator is responsible for the administration, reporting, training and user support of Efforts to Outcomes™ (ETO), a Client Relationship Manager (CRM) system that serves as Homeward Trust’s primary database tool. The Database Coordinator ensures the proper use of ETO by our staff and agencies, ensuring timely and complete collection of client data, as well as enabling the generation of accurate status and progress reports on a regular and ad hoc basis.

The Database Coordinator serves as a data ambassador and works closely with a diverse group of stakeholders – providing training and expertise in the development and use of the database system as required, supplementing homelessness and housing data and information collection used to measure and report on our progress in enacting the community plans to end homelessness.

This position reports directly to the Manager, Data and Analytics and is a member of the Planning and Research Team.  There are no direct staff reports to this position, but supervision of students, volunteers, and others may be required from time to time.

Duties and Responsibilities

Administration 

• Design, develop, and modify ETO and other database systems in response to user needs, research and reporting requirements.
• Train and otherwise assist Homeward Trust, stakeholders, and sub-licensee staff on setup, implementation, and use of ETO and other database systems for data management and reporting.  This includes the development of and implementation of manuals, training documents and training sessions.
• Respond quickly and effectively to queries related to administration and coordinating ETO and other database systems, including management of user accounts, licenses, training and permissions.
• Provide support to management and departmental staff, including but not limited to maintaining files, drafting correspondence, and preparing reports.
• Foster supportive relationships with and among sector partners focused on client relationship management tools. Create a network of expertise within the sector, including trainers to support their own teams.
• Lead a sector-specific community of practice in client data stewardship, including training, skill development tools, tutorial creation, and ongoing engagement with front-line service providers.

Reporting 

• Develop and implement database structures, relationships, queries, reports, and other elements for effective, timely, and reliable utilization of information from ETO and other databases for use by our stakeholders.

• Support Homeward Trust and System partners with reporting needs. This includes report creation, modification, production, and submission to required stakeholders, including government, funders, agencies, management, Support Services staff, Planning and Research staff, and others as required.
• Ensure reports are accurate, timely and provide data required for information generation, analysis and research.
• Provide narrative or briefing summaries on ETO and database reports, projects and related issues as required and requested.

Data Quality and Functionality 

• Ensure quality and reliability of all data collection, management, and reporting procedures and tools. Regularly cull and clean database as required.
• Work collaboratively with research staff, management, and user agencies to ensure correct, complete and timely data collection and data corrections.
• Proactively and in response to user feedback, continually design and refine database systems, structures, and procedures to ensure optimal usability and reliability.
• Facilitate regular meetings with ETO and other database users to ensure alignment of database structures, data policy, and tools with requirements for service delivery, contract management and reporting, research, and program evaluation.
• Liaise with Social Solutions Inc and other database providers to address problems in a timely manner and ensure database integrity and reliability.
• Perform other tasks as appropriate and time allow

Education and Experience 

• Degree or diploma in computer science, information technology or related discipline, or a degree in social sciences with experience in database management and administration component.
• Minimum 3 years related experience in developing and administering database systems, with user interface and reporting responsibilities.
• Experience with basic statistical and qualitative analytic methods is an asset.
• Prior experience working in the not-for-profit, social/human services or related industry is an asset.

Knowledge, Skills, and Abilities

• Advanced knowledge of data management systems, including Efforts to Outcomes™ or other related system platforms.
• Analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Ability to learn quickly, think logically, and understand abstract relationships.
• Excellent communication and interpersonal skills, and ability to train and support end-users
• Proven time management and organization skills. 
• Understanding of business processes associated with the social sector, community-based organizations and multiple levels of government.
• The belief is that housing is a human right, and that homelessness is solvable.
• Knowledge of and experience with reporting packages (Business Objects etc.), databases (SQL etc.), programming (XML, JavaScript, or ETL frameworks) is an asset.
• Knowledge of and familiarity with Aboriginal history, cultures, contexts, and traditions is an asset

While we evaluate all applications based on merit, we especially appreciate and recognize the unique insights that come from personal lived experiences, such as homelessness or houselessness. We are deeply committed to fostering a diverse and inclusive workplace. Applicants from marginalized groups, including but not limited to Indigenous peoples, LGBTQ2S+, women, and newcomers, are encouraged to apply.

This competition will close at 4:30pm on October 2nd, 2024. We thank all applicants for their interest: however, only those selected for an interview will be contacted.