Summary
This job involves gathering, cleaning, and analyzing data to support decision-making in the city's public works department, creating reports and visuals to explain findings to others, and sometimes leading a small team.
It's ideal for someone organized with a knack for numbers and technology who enjoys turning raw information into useful insights for improving city services.
A good fit would be a detail-oriented professional with experience in data handling and basic leadership skills.
Full Job Description
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 LocationNortheast Service Center - 10303 Toolyard, San Antonio, TX 78233
Work Schedule7:45 a.m. - 4:30 p.m., Monday - Friday
Requirements
- 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.
Qualifications
- 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- Experience in ArcGIS and/or ArcPro.
- Experience with Microsoft Office tools.
- Class "C" Texas Driver's License.
Applicant InformationUnless 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.
Additional Information
- 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.