Data Manager

Responsibilities

• Assist in the overall maintenance of the Coalition’s Programs and Advocacy departments’ data in Bonterra’s ETO database and other formats, including but not limited to, files maintained on the Coalition’s shared servers;
• In collaboration with department heads and identified team members, build, develop, and modify reports, and extract data in support of the organization’s many reporting requirements, grant deliverables, and advocacy goals;
• Track, check, and manage the receipt of all data provided to the Coalition by the City and other third parties and ensure that data is properly recorded, stored and circulated;
• Establish productive and collaborative working relationships with staff to capture programmatic and advocacy efforts effectively and accurately in ETO and other tracking systems;
• Create and maintain protocol guides for staff to access data and reports as needed;
• Serve as a staff resource to identify, problem solve, and answer questions regarding general data management needs and help resolve system issues;
• Assist with training on data entry and reporting for new staff or when changes to data systems are implemented and provide ongoing support to Coalition database users;
• Supervise part-time Data Assistant by providing support needed and ensuring the accuracy of the data for the tasks assigned;
• Assist with tasks related to various department workflows such as:
  • Uploading data to HUD’s Homeless Management Information System (HMIS) Awards system;
  • Producing preliminary data utilized for quarterly and annual funding requirements and assisting program staff in cross- referencing databases, where necessary and applicable;
  • Identifying, modifying, and/or replacing existing databases to better align with department needs;
  • Regularly checking the sources of public data relevant to the Coalition’s advocacy work; capturing, organizing, and managing relevant data identified; and communicating the same to Coalition staff;
  • Generating materials such as geographical maps to support program and advocacy work;
  • Creating dashboards to provide staff with individualized, at-a-glance summaries; and
  • Support Coalition staff by providing the data needed to respond to various inquiries.
• Develop and maintain thorough and up-to-date understanding of ETO and other systems used by the Coalition by viewing webinars and attending relevant classes or conferences offered by Bonterra or other applicable providers;
• Compile and ensure the accuracy of data reported on the Coalition’s website; and
• Perform all other duties as may be assigned by direct supervisor or designee.

Skillset

• At least two years of database administration experience required;
• Expertise in Microsoft Excel highly preferred;
• Knowledge of Bonterra Efforts to Outcomes (ETO) database, including ability to design and run complex reports therein and manage updates highly preferred;
• BA/BS preferred;
• Solid understanding of the principles of database design and architecture and use of tools such as MS Access also desired;
• Proficiency in SQL, R, and/or Python desired;
• Experience with ArcGIS (or other mapping software) and with data visualization tools such as Tableau or PowerBI desired;
• Exceptional oral and written communication skills required;
• Must be well-organized, detail-oriented, able to work independently, able to meet strict deadlines, flexible, able to triage among competing priorities, and able to work across multiple departments in a supportive and team-oriented manner.