City of San Antonio
Job detailsSalary$75,733 – $115,493 a yearJob TypeFull-timeLocation315 S Santa Rosa, San Antonio, TX 78207+ Leaflet | OpenStreetMap contributorsBenefitsPulled from the full job descriptionDisability insuranceHealth insuranceLife insuranceFull Job Description
Under supervision, is responsible for designing and implementing data and analysis products and solutions. Assists in determining what data management systems are appropriate and which data are needed for analysis. Builds and maintains data management systems that combine core data sources into data warehouses or other accessible structures to support reporting and analytical systems. Delivers expertise in a range of areas, including data analysis, data solution design, testing, and implementation of data solutions and data flow designs to create the design for a new system. Exercises no supervision. Work Location 315 S. Santa Rosa (Public Safety Headquarters), San Antonio, Texas 78207 Work Hours 7:45 a.m. – 4:30 p.m., Monday – Friday
Essential Job Functions
Assists in building and maintaining data management systems that combine core data sources into data warehouses or other accessible structures.
Performs data conversions, imports, and exports within and between internal and external software systems.
Develops programs to extract, transform, and load data between data sources and assists in creating custom software components and analytics applications.
Creates data transformation processes to support business systems and operational data flows. Implements processes to ensure data integrity and standardization.
Applies fundamental concepts, practices, and procedures to complete data engineering assignments.
Assists in maintaining the quality of Metadata Repository by adding, modifying, and deleting data.
Participates in short and long-term planning efforts with management.
Assists with developing and evaluating technical requirements for data systems.
Performs related duties and fulfills responsibilities as required.
Bachelor’s Degree from an accredited college or university
Two (2) years of work experience in Data Engineering, Data Base Administration, and/or Data Base Management System design and support.
Applicants for this position must pass a Criminal Justice Information Systems (CJIS) fingerprint-based background check and maintain CJIS eligibility. Due to CJIS requirements related to system access, the following will result in being disqualified for this position: Felony Convictions, Felony Deferred Adjudication, Class A & B Misdemeanor Deferred Adjudication, Class B Misdemeanor Convictions, an Open Arrest for Any Criminal Offense (Felony or Misdemeanor), and Family Violence Convictions.
Two (2) years of experience working in an agile environment.
Ability to conduct data engineering and analytics, including but not limited to database creation & management, relational database development & design, geospatial data analysis & management, and statistics.
Skill in the use of statistical packages that may include R or Python-statistical programming.
Advanced skill with SQL and Microsoft SQL Server Management Studio.
Knowledge and experience with the practical application of data engineering principles, techniques, procedures, automation tools, and equipment to the design and production of various goods and services.
Knowledge and experience in test harnessing, test simulation, testing platforms, and testing techniques.
Preferred skill and experience in machine learning and predictive analytics.
Strong skills in data visualization, mapping, and story telling.
Strong skills in open data, including API development.
Knowledge of statistical research, analysis, and reporting methods, techniques, and procedures.
Ability to find creative solutions to problem-solving.
Skill in applying mathematical and statistical methods.
Preferred knowledge of law enforcement operations, procedures, systems, and software.
Ability to interpret, compare, and analyze law enforcement information (preferred) and process large raw data sets (required).
Ability to create both technical and non-technical end-user documentation.
Ability to write clear and concise reports.
Ability to establish and maintain effective working relationships with co-workers, management, and the public.
Ability to work independently, with minimal supervision, and use rational judgment in making work-related decisions.
Ability to communicate clearly and effectively.
Ability to deliver formal presentations to small and large groups.
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.
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.
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
Knowledge, Skills, and Abilities
Knowledge of business and technical environments that spans one or more business areas
Knowledge of the practical application of data engineering and technology, including applying principles, techniques, and procedures to the design and production of data products
Knowledge of modern RDBMS systems, data structures, data warehouse concepts, and ETL techniques
Skill in working in an agile environment
Skill in identifying and solving system problems
Skill in preparing data structures, flowcharts, and logic flow diagrams
Ability to leverage modern architectural components and principles to design modular, flexible software solutions
Ability to communicate clearly and effectively with people at all levels of a business
Ability to perform all the essential functions of the position, with or without accommodations
Ability to work in an office environment
Benefits Information The City of San Antonio (CoSA) strives to provide a competitive compensation and benefit package to attract and retain a highly skilled workforce. To accomplish this, CoSA offers subsidized health care benefits for active and retired employees, paid disability benefits, paid life insurance, as well as automatic participation in a pension program which is currently matched two to one. For more detailed information, please click on the following link to view Benefits offered by the City of San Antonio: http://www.sanantonio.gov/hr/employee_information/benefits/index.asp
Part-Time, Temporary, and non-City positions are not eligible for CoSA Benefits.
Holiday and Leave benefits for Pre-K 4 SA positions may be different than what is listed at the above link.
Additional Information The City Of San Antonio is an Equal Opportunity/Reasonable Accommodation Employer. This means that the City does not discriminate on the basis of race, religion, sex (gender), age, disability, national origin, genetic information, or sexual orientation. All individuals are encouraged to apply and compete for jobs with the City of San Antonio.
If you require assistance at any stage of the application process due to a disability, please contact the Human Resources Department so that accommodations may be made to meet your needs. Our telephone number is 210-207-8705 and our fax number is 210-207-2285.
Health insuranceHiring InsightsJob activityPosted 3 days ago