IT Data Engineer I Print (https://www.governmentjobs.com/careers/sanantoniotx/jobs/newprint/4692114) Apply  IT Data Engineer I Salary $59,000.24 - $87,207.12 Annually Location 78207, TX Job Type 4A Full-Time Job Number 2025-00144 Department ITSD Opening Date 10/14/2024 Closing Date 11/14/2024 11:59 PM Central Grant Funded No FLSA Status Exempt + Description + Benefits + Questions Job Summary 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 South Frio, 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. Job Requirements + 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. Preferred Qualifications + Two (2) years of experience working in an agile environment. + Experience using SQL, Python, R. + Experience in data modeling, ETL/ELT. + Experience using cloud applications. + Six Sigma certified. Applicant Information + 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 Note: + 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 (https://www.sanantonio.gov/Hr/About/ContactUs?sendto=HR) 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.