What are the responsibilities and job description for the Data Architect position at City of Columbia, MO?
The purpose of this job is to define citywide data policies and procedures, establish, monitor, and control data governance, and design and maintain data management systems that enable data-informed decision-making, data quality, and data security.
Essential Duties and Responsibilities - The intent of this job description is to provide a representative summary of the major duties and responsibilities performed by employees in this job. Employees may be requested to perform job-related tasks other than those specifically presented in this description
- Develops and maintains enterprise reference architecture, specifying data domains and data flows across different business applications
- Creates and stewards a comprehensive data inventory, improving accessibility to and classification of city data and relevant third-party data.
- Contributes to an enterprise data management strategy, reducing unnecessary data replication and aligning with business goals.
- Creates and optimizes data models, including conceptual, logical, and physical data models, reflecting business users’ information needs.
- Defines and maintains business glossary, controlled vocabularies, and metadata repositories to facilitate understanding and use of data assets.
- Establishes the city’s data governance strategy and data management policies and procedures to ensure data quality and security.
- Design solutions that take into account utilization, interoperability, and security for integrating data from various sources, ensuring consistency and accuracy.
- Monitors, audits, and reports compliance with data standards, relevant regulations, and performance expectations.
- Regular attendance is a necessary and essential function.
- Performs other duties as assigned.
Supervisory Responsibilities
- No supervisory authority. Work does require providing guidance and training to others.
Human Collaboration and Job Impact - This area describes the personal interaction with others outside direct reporting relationships as well as the impact the job has on organization, the department or unit objectives, the output of services, or employee or public satisfaction
- Interactions may result in decisions regarding implementation of policies. Contact may involve support of controversial positions or the negotiation of sensitive issues or important presentations. Contacts may involve stressful, negative interactions with the public requiring high levels of tact and the ability to respond to aggressive interpersonal interactions.
- Interactions have significant impact on the organization in terms of time, money, or public/employee relations.
Fiscal Responsibility
- Position has limited fiscal responsibility.
- May assist in the collection of data in support of recommendations for departmental budget allocations. May monitor division or program/promotional-level budgets and expenditures.
Education and Experience - An equivalent combination of education, training and experience will be considered
Education and Experience
- Bachelor’s Degree in Data Science, Business, Data Analytics, Computer Science, Statistics, or related field
- 5 years of experience in business functional requirements gathering, documentation, and translation to IT technical requirements.
Licenses or Certifications
- None.
Knowledge, Skills and Abilities which may be representative, but not all-inclusive of those commonly associated with this position
Knowledge of:
- Data systems and platforms.
- Data management solutions.
- Data modeling and data analytics tools and techniques.
- Data standards and data governance best practices.
Skill in:
- Communicating verbally and in writing to meet the audience’s needs.
- Assessing business and operational risks.
- Working in close coordination with technical resources and business users.
- Collecting, organizing, and analyzing complex and/or technical data.
- Maintaining detailed and accurate records.
- Applying active listening and asking questions for understanding.
- Preparing and presenting reports.
Ability to:
- Establish goals and objectives, implement and evaluate projects.
- Recognize, analyze, and solve problems.
- Work independently under little or no supervision.
- Compile, organize, and interpret data and communicate results and recommendations concisely.
- Apply logic and reasoning to evaluate the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems.
- Focus on tasks.
Work Environment – Environmental or atmospheric conditions commonly associated with the performance of the functions of this job
Work Environment:
Office or similar indoor environment – Frequently/Often
Exposures:
Individuals who are hostile or irate – Sometimes
Office or similar indoor environment – Frequently/Often
Exposures:
Individuals who are hostile or irate – Sometimes
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 essential functions.
- This position is relatively free from unpleasant environmental conditions or hazards and is generally sedentary.
- Incumbents may be required to exert up to 10 pounds of force occasionally, a negligible amount of force frequently, and/or constantly have to lift, carry, push, pull, or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.
Hours/Days
8:00 am to 5 pm, Monday to Friday
Starting Salary
$81,515 to $119,038 (midpoint: $100,256)
Pay Grade
112
Number of Positions Available
1
Deadline to Apply
05/05/2026
Open Until Filled
No
Special Instructions to Applicants
THIS IS NOT A REMOTE WORK POSITION
Notice to Applicants
Individuals needing accommodation to apply may call 573.874.CITY (2489)
TTY: 711 (MO RELAY)
THE CITY OF COLUMBIA IS A MERIT, AFFIRMATIVE ACTION, EQUAL OPPORTUNITY EMPLOYER: MALE / FEMALE
THE CITY OF COLUMBIA REQUIRES PRE-EMPLOYMENT DRUG TESTING
The City of Columbia participates in the federal E-Verify work authorization program
TTY: 711 (MO RELAY)
THE CITY OF COLUMBIA IS A MERIT, AFFIRMATIVE ACTION, EQUAL OPPORTUNITY EMPLOYER: MALE / FEMALE
THE CITY OF COLUMBIA REQUIRES PRE-EMPLOYMENT DRUG TESTING
The City of Columbia participates in the federal E-Verify work authorization program
Salary : $81,515 - $119,038