INFO SYS ADVISOR 2 (Data Inventory and Workflow Assessment Lead)

About the role

The Data Inventory and Workflow Assessment Lead is a limited-term, Public Health Infrastructure Grant (PHIG) funded position supporting the Metro Nashville Public Health Department in modernizing its data collection, management, sharing, and usage. This role will conduct a comprehensive departmental data inventory and workflow assessment to document current data assets, business processes, applications, repositories, and data-sharing practices. The goal is to identify inefficiencies, risks, and opportunities for improvement, ultimately enhancing operational efficiency and data accessibility for reporting and decision-making.

Following the assessment, this position will collaborate with ITS to implement approved recommendations within Metro’s enterprise data ecosystem, focusing on scalable and sustainable solutions aligned with enterprise standards. This is a temporary, non-civil-service position funded through November 30, 2027.

Responsibilities

• Lead discovery sessions with Health Department leadership, program staff, and technical personnel to understand data collection, storage, sharing, reporting, and usage across departmental operations.
• Develop and maintain an inventory of significant data assets, including collection points, repositories, spreadsheets, paper-based records, and other data sources.
• Identify and document departmental applications, tools, and platforms that store, process, or exchange data, including their business purpose, data types, and role in operational workflows.
• Map current-state workflows related to data collection, intake, storage, reporting, and sharing, with a focus on paper-based processes, manual entry, duplicate work, and fragmented handoffs.
• Identify data quality issues, inconsistent practices, duplicate data entry, reporting limitations, and other barriers affecting efficiency, visibility, compliance, or service delivery.
• Inventory existing data-sharing agreements and related documentation, identifying gaps where documentation is incomplete, outdated, or disorganized.
• Develop findings and recommendations to improve workflow efficiency, strengthen data management practices, reduce fragmentation, and support future data modernization efforts.
• Prioritize the use of existing enterprise solutions where feasible; recommend configurable commercial or enterprise-supported platforms over custom-developed tools to reduce long-term support burden.
• Apply data analysis and systems thinking to identify opportunities for standardization, digitization, improved data capture, and better use of departmental data.
• Work with departmental and enterprise stakeholders to distinguish quick wins from longer-term modernization opportunities.
• Translate assessment findings into an actionable implementation plan grounded in operational realities, staffing considerations, and organizational readiness.
• Prepare inventories, summaries, workflow documentation, findings, and executive-ready materials to communicate current-state issues and recommended next steps.
• Support the development of a phased work plan for future improvements to data collection, data management, application strategy, and reporting capability.

Requirements

• A bachelor's or master's degree in business administration, public health, health informatics, information management, computer science, data science, or a related field, or equivalent work experience.
• Five or more years of experience in business process analysis, data assessment, data management, business intelligence, health informatics, or related analytical work.
• Experience conducting discovery sessions, stakeholder interviews, workflow assessments, or current-state process documentation.
• Experience inventorying data assets, applications, repositories, or other information resources across a complex organization.
• Experience analyzing how data is collected, stored, shared, and used across multiple systems or business processes.
• Experience gathering business and functional requirements and translating them into practical recommendations.
• Experience identifying opportunities for digitization, standardization, workflow improvement, or better use of existing enterprise technologies.
• Experience working with structured and unstructured data sources, spreadsheets, forms-based processes, databases, or reporting environments.
• Experience preparing clear written findings, inventories, and executive-ready summaries for both technical and non-technical audiences.
• Must receive and maintain “pass” status from Metro Nashville Police Department (MNPD) background check.

Preferred Qualifications

• Experience in public sector, healthcare, public health, or other highly regulated operational environments.
• Experience supporting data modernization, application rationalization, reporting improvement, or digital transformation efforts.

Skills

• Strong understanding of core data management concepts, including data lifecycle, data quality, metadata, ownership, stewardship, and systems of record.
• Ability to assess operational workflows and identify inefficiencies, bottlenecks, manual workarounds, duplicate entry, and control gaps.
• Ability to analyze data flows, repositories, applications, and integrations to understand how data moves through business processes.
• Strong analytical and problem-solving abilities, with the capacity to connect operational issues to data and systems implications.
• Excellent interpersonal skills; ability to work across departmental and agency lines to achieve common goals.
• Strong interviewing, facilitation, and stakeholder engagement skills, including the ability to elicit useful information from both technical and non-technical staff.
• Excellent oral and written communication skills, including the ability to prepare inventories, workflow documentation, findings, and executive-level summaries.
• Ability to understand business needs and combine them with technical understanding to develop practical modernization recommendations.
• Skilled in organizing large amounts of information into clear themes, priorities, and next steps.
• Working knowledge of applications, databases, spreadsheets, forms-based processes, and common interoperability or reporting challenges.
• Ability to operate at both a strategic and operational level while maintaining focus on practical implementation and long-term maintainability.

Schedule

This is a temporary, grant-funded position with funding available through November 30, 2027.