Data Coordinator

City of San Antonio • Full-time • San Antonio, TX, US • $64.10k - $96.15k / year • 3w ago

Job Summary

Under direction, compiles and interprets data to help organizations make informed decisions. Collects, processes, analyzes, and presents data in a concise format for presentation. Oversees research, creates complex statistical data, designs planning timetables, evaluates systems policies and procedures, and assists with recommendations to achieve goals and objectives. May exercise supervision over assigned staff.

Work Location
City Tower - 100 W Houston Street, San Antonio, TX 78205

Work Schedule
7:45 a.m. - 4:30 p.m., Monday - Friday; May include evening and weekend hours to attend community meetings and public hearings.

Essential Job Functions

Oversees the collection, cleaning, and analysis of data from various sources to ensure accuracy and reliability.
Oversees the production of reports, maps, applications, and visualizations for internal or external stakeholders.
Reviews data analysis to identify patterns, trends, and anomalies for program development and/or modification.
Develops and designs statistical methods and data modeling techniques to interpret data and make predictions.
Monitors databases and data collection systems for optimal data quality and efficiency.
Designs reporting dashboards to translate data to an understandable illustrative format to non-technical audiences and oversees the importation of data for their use and distribution.
Assist in developing procedures for department level GIS; Plans and coordinates GIS projects, initiatives and activities to optimize opportunities for data and systems integration; Conducts research; recommends improvements; and assesses outcomes
Communicates complex data insights in a clear and understandable manner to non-technical audiences.
Monitors collaboration with cross-functional teams to understand data needs and deliver relevant data-driven solutions.
Ensures data privacy and security compliance in all data handling and processing activities.
Stays updated with the latest data analysis tools, techniques, and industry trends for continuous improvement.
Develops and designs data analysis processes where possible to enhance efficiency.
May assist in the preparation and monitoring of the annual budget.
Reviews written reports, summaries, and presentations.
Uses findings to make data-driven recommendations for practices, programming, and policies.
Performs quality assurance and/or quality control on all department data and products. Evaluates the work product of GIS departmental staff.
Performs related duties and fulfills responsibilities as required.

Job Requirements

Bachelor's Degree from an accredited college or university.
Three (3) years of increasingly responsible experience in statistical modeling or data analysis, to include one (1) year of supervisory or lead experience.

Preferred Qualifications

American Institute of Certified Planners (AICP).
Bachelor's degree in city, urban, or regional planning, geography, public administration, or a related field.
GISP Certification.
Advanced knowledge of ArcGIS software and analysis.
Experience managing large and diverse data sets with appropriate Quality Assurance and Quality Control.
Experience utilizing a range of quantitative and GIS mapping methodologies, joining of diverse datasets, historical/trend analysis, multi-criteria overlay analysis, network analysis, etc.
Experience producing compelling and intuitive maps and data visualizations to boost understanding of complex topics and concepts across a broad range of technical and non-technical stakeholders.
Experience collecting, organizing, analyzing, and presenting demographic and geographic data relevant to Planning Department initiatives.
MS Office experience.
Strong writing skills.
Valid Class "C" Texas Driver's License.

Applicant Information

Unless otherwise stated, applicants are permitted to substitute two years of related full-time experience for one year of higher education or one year of related higher education for two years of experience in order to meet the minimum requirements of the job. One year of full-time experience is defined as 30 or more hours worked per week for 12 months. One year of higher education is defined as 30 credit hours completed at an accredited college or university.
Applicants selected for employment with the City of San Antonio in this position must receive satisfactory results from pre-employment drug testing and background checks. If required for the position, a physical, motor vehicle record evaluation, and additional background checks may be conducted.
Please be advised that if selected for this position, information regarding employment history as it relates to the qualifications of the position will be needed for employment verification. Applicants claiming military service to meet the experience requirement for this position may attach a DD214 to the application.
If selected for this position, official transcripts, diplomas, certifications, and licenses must be submitted at the time of processing. Unofficial transcripts and copies of other relevant documents may be attached to the application for consideration in advance.

Knowledge, Skills, and Abilities

Knowledge of data analysis and technology.
Knowledge of data models, database design development, data mining, and techniques.
Knowledge of computer software and hardware applications.
Knowledge of statistics and experience using statistical packages for analyzing datasets.
Knowledge of budget and accounting principles.
Knowledge of web/mobile application development and programming languages (JavaScript, .Net, CSS, HTML, R, Python, and other programming languages).
Knowledge in MS SQL database structure and design, writing complex SQL queries, functions, stored procedures, entity relationship diagrams, and data transformation.
Ability to train and/or assist colleagues and communicate with users at differing experience levels, experience with Power BI is plus.
Ability to coordinate with cross functional teams to complete projects; Confers with the City's Enterprise management and other departments regarding data migration, integration and transformation.
Ability to identify, gather, and evaluate data.
Ability to operate a computer keyboard and other basic computer equipment.
Ability to provide technical assistance and training to users.
Ability to communicate clearly and effectively.
Ability to supervise, evaluate, and monitor performance in accordance with City policies and procedures.
Ability to perform all the physical requirements of the position with or without accommodations.
Ability to work primarily in an office environment.