Data & AI Engineer

at  City of Carrollton

JOB TITLE: Data & AI Engineer
DEPARTMENT/DIVISION: Information Technology
REPORTS TO: Data & AI Manager
SUMMARY: The Data & AI Engineer is responsible for managing and optimizing both on- premises and cloud-based databases and data lakehouses within Azure and Databricks environments. This role includes developing and maintaining data pipelines, managing AI applications such as chatbot development, and employing machine learning techniques to enhance system performance and capability. This position will also handle routine database administration duties, ensuring high levels of performance and security.

KNOWLEDGE, SKILLS, AND ABILITIES:

• Knowledge of database theory
• Knowledge of database design
• Knowledge about the RDBMS itself, e.g. Oracle Database, Microsoft SQL Server, IBM Informix
• Knowledge of Structured Query Language (SQL)
• Knowledge of distributed computing architectures, e.g. Client/Server, Internet/Intranet, Enterprise
• Knowledge of the underlying operating system, e.g. Windows, Linux
• Knowledge of storage technologies, memory management, disk arrays, NAS/SAN, networking
• Knowledge of routine maintenance, recovery, and handling failover of a Database
• Knowledge of disaster and business recovery practices
• Knowledge of government operations and processes
• Skilled in managing cloud-based technologies, particularly in Azure and Databricks environments.
• Skilled in designing secure networks, systems, and applications architecture
• Skilled in evaluating quality and reviewing final work products
• Skilled in analyzing security processes
• Skilled in assessing cost efficiency and effectiveness of municipal operations
• Skilled in tracking service call and installations
• Skilled in identifying and solving problems
• Skilled in documenting service outages and resolutions
• Skilled in working independently or part of a team in delivering excellent customer service
• Skilled in reading and interpreting technical documents
• Skilled in applying independent judgment, personal discretion, and resourcefulness in interpreting and applying guidelines
• Skilled in reading, interpreting, applying, authoring and explaining rules, regulations, policies, and procedures
• Skilled in preparing clear and concise reports
• Skilled in gathering and analyzing information and making recommendations based on findings and in support of organizational goals
• Skilled in operating a computer and related software applications
• Skilled in communicating effectively with a variety of individuals
• Ability to communicate with users to define system requirements and resolve problems
• Ability to analyze technical problems and develop workable solutions

MINIMUM QUALIFICATIONS:

• Bachelor’s degree in a related field of study or equivalent work experience
• 1 year of progressively responsible information technology experience
• CompTIA Security+ certification or equivalent upon management approval within 1 year of employment.
• 1 or more of the following certifications (or substantially similar) or ability to obtain within 1 year of employment;
• Microsoft Certified: Azure AI Engineer Associate
• Microsoft Certified: Azure Data Engineer Associate
• Microsoft Certified: Azure Database Administrator Associate
• Must qualify for and maintain compliance with Criminal Justice Information Systems access requirements
• Must possess or be able to obtain and maintain a valid Texas driver’s license

Please refer the Job description for details