Position Title: Data Architect
Department: City Manager
Division: PMO
FLSA Status: Exempt
Union Code/Affiliation: Unrepresented
Starting Salary: $80,309-$117,270 (midpoint: $98,779)
Job Code: 07944
Application Deadline: 02/11/2026
Hours: Monday – Friday 8:00 a.m. to 5:00 p.m.
Job Description (This job description/posting in no way states or implies that these are the only duties to be performed by the employee occupying this position.)
The purpose of this job is to define city-wide data policies and procedures, establish, monitor, and control data governance, and design and maintain data management that enables data-informed decision-making, data quality, and data security.
Essential Functions:
- 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, taking 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.
Education and Experience (An equivalent combination of education, training & 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
Knowledge, Skills & Abilities:
Knowledge of:
- Data systems and platforms.
- Data management solutions.
- Data modeling, 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.
Supervision Exercised:
No supervisory authority. Work does require providing guidance and training to others.
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.