Open Database Administrator

Job Description

• Hybrid Position
• The Open Data Administrator will be responsible for collecting, organizing, evaluating, and publishing datasets, as well as collaborating with internal departments to ensure data quality and upload compliance. The ideal candidate will have a passion for the use, understanding, and value of data, a strong understanding of data governance, and experience with data management platforms and metadata standards.The Open Data Administrator will work as a member of the BIDI team within Data Services team and manage the daily administration and expansion of the City’s two Open Data Portals, ArcGIS Online (AGOL) and Open GOV. This role will also augment internal analytics projects as needed. Key Responsibilities : Assist in project planning, execution, and monitoring to ensure the successful implementation of data solutions.Oversee the collection, storage, and maintenance of datasets.Identify datasets suitable for publication, in collaboration with data owners and legal / compliance teams, towards expansion of the city’s open data portal.Collaborate with external users (e.g., developers, researchers, civic tech groups) to understand data needs and usability.Maintain metadata standards to ensure datasets are well-documented and discoverable.Develop and maintain standard operating procedures, user guides, FAQs, and dataset documentation for public and internal users.Conducts workshops, webinars, and training sessions to improve data literacy and how to prepare and publish open data.Creates documentation, tutorials, and use cases to help users understand and apply open data.Builds and nurtures communities of data users, including civic tech groups, startups, and academia. Qualifications : Education : Bachelor’s degree in information technology, Data Science, or a related field. Experience : Proven experience in data management, preferably in an open data environment. Key Skills : Data Management : Proficiency in managing data, including collection, storage, and maintenance. Experience with database management systems (e.g., Oracle).Data Quality Assurance : Ability to ensure data accuracy, consistency, and integrity.Familiarity with data cleansing and validation techniques (preferably using Oracle tools).Data Security : Knowledge of data security protocols and best practices.Experience in implementing measures to protect sensitive information.Technical Proficiency : Proficiency in data analysis tools (e.g., Python, R, Excel).Familiarity with open data platforms and tools (e.g., OpenGov, Socrata, CKAN, Esri AGOL)Experience working with GIS spatial data.Regulatory Compliance : Ability to ensure compliance with relevant standards and policies.Communication and Collaboration : Strong communication skills to work effectively with various stakeholders.Ability to collaborate with different departments to identify data needs.Problem-Solving : Excellent analytical and problem-solving skills.Ability to troubleshoot and resolve data-related issues.Documentation : Skill in developing and maintaining technical and project documentationAbility to create clear and comprehensive reports.Training and Support : Experience in providing training and support to staff on data-related issues.Ability to explain complex data concepts in an understandable way.Data Visualization : Familiarity with data visualization techniques and software.Ability to present data in a clear and actionable manner.Required SkillsBachelor’s degree in information technology, Data Science, or a related field.Experience in data management, preferably in an open data environment.Proficiency in data analysis tools (e.g., Python, R, Excel).Familiarity with open data platforms and tools (e.g., OpenGov, Socrata, CKAN, Esri AGOL).

Requirements