Data & AI Engineer

Position Details

Position Information

Posting Number 2026649

Position Title Data & AI Engineer

Position # #9000228

FLSA Exempt

Classification Type Professional

Department Information Technology

Job Type Full Time

Work Schedule Monday-Friday; 8am-5pm

Hiring Pay Rate $65,000-$85,000/year (depending on qualifications)

Posting Opening Date 11/13/2026

Posting Closing Date

Job Summary Supports the City of Bryan’s modernization efforts by improving how data is collected, analyzed, and used to streamline operations and enhance public services. Work involves partnering with departments to transform manual and paper-based processes into efficient, digital, and automated workflows; building reporting, automation, and AI-enabled solutions; and supporting data-driven decision-making across departments. This position helps improve City operations, empower staff through data, and deliver modern public services to residents.

Essential Job Functions

• Partners with City departments to understand business needs, identify manual or paper-based processes, and design data-driven solutions, including low-code applications.
• Assists the City’s data warehouse consultant with implementing the warehouse, following the consultant’s architecture and design, including building and scheduling data loads from source systems, and maintains and supports the warehouse once it is in place.
• Works with internal, vendor, and public data sources, including populating and extracting data from internal and public open datasets.
• Builds automated workflows and integrations, using platforms such as n8n and Power Automate, that move data between City systems, vendor platforms, and other data sources.
• Performs data analysis, including conceptualization, modeling, and presentation of data.
• Designs reporting dashboards and web-based reports to translate data into an understandable illustrative format and fulfills ad hoc reporting requests.
• Evaluates, implements, and supports AI-enabled solutions, including testing results for accuracy and consistency before changes are put into use.
• Monitors, troubleshoots, and maintains production data pipelines, reports, and automations.
• Develops procedures for data validation, analysis, and presentation.
• Handles sensitive and confidential data, including Criminal Justice Information Services (CJIS) and customer data, in accordance with City, state, and federal requirements.
• Manages assigned projects from request through completion, including tracking status, milestones, and business value (e.g., staff time or costs saved).
• Coordinates with vendors and IT staff on data access, integrations, and issue resolution, and works under the direction of vendor and contractor specialists on larger projects.
• Trains staff on updated tools and data processes.
• Reviews and provides technical assistance to users’ requests for new data elements and systems, and identifies and coordinates changes to the existing shared data environment.
• Works with IT staff on database structures, data modeling, storage, backup and recovery, software upgrades, and test environments to ensure data integrity and security.
• Assists in the evaluation of and recommendation for data management and reporting software. Coordinates and supports migration to new data management systems and reporting platforms.
• Researches and recommends modern data tools, including AI-enabled platforms, to support modernization.
• Maintains documentation of solutions, processes, and procedures so that others can operate and support them.
• Reviews and approves changes submitted by other staff through version control (git) pull requests.
• Performs related duties as required.
• Responds regularly and promptly to work.

Minimum Qualifications

• Bachelor’s degree in Computer Science, MIS, Data/Business Analytics, Statistics, or similar field of study plus two (2) years of professional experience in data, reporting, or automation, including SQL and use of data visualization tools (e.g., Power BI or similar); OR an Associate’s degree plus four (4) years of directly related experience as previously listed. Internships and co-ops in these areas count toward the required experience.
• Experience supporting municipal government applications is a plus.
• Experience with data engineering, workflow automation (e.g., n8n, Power Automate), version control (git), and/or applied AI/ML is a plus.

Equivalent combinations of related education, experience, training, and certification may also be considered.

Knowledge, Skills & Abilities

Knowledge of:

• Principles, methods and techniques used in designing, developing, testing, implementing, and maintaining computer software systems.
• Data processing, integration, and automation techniques.
• Basic project management principles and techniques.
• Structured analysis and database concepts.
• Relational database concepts, including tables, keys, relationships, joins, normalization, and indexing, and how queries affect database performance.
• Working knowledge of data warehousing concepts, including dimensional modeling (e.g., star schemas), ETL/ELT processes, and data quality checks.
• Principles of data security, privacy, and the responsible use of AI.
• Data governance, data quality, and version control practices.

Ability to:

• Streamline manual tasks and support automation projects.
• Extract and query data from database systems such as Microsoft SQL Server and vendor applications.
• Write SQL and scripts (e.g., Python) to extract, transform, and automate data.
• Use git to manage scripts, queries, and report code, including branches, pull requests, and code review.
• Multitask and work in an environment with frequent interruptions.
• Maintain current proficiency on data, automation, and AI technologies, methodologies, and concepts.
• Maintain confidentiality of sensitive information.
• Perform all phases of business systems analysis and design functions, responsible for application design, coding, testing, debugging and thorough documentation skills.
• Translate business processes into detail application design specifications.
• Analyze, breakdown, identify requirements and design or modify an application or system to solve a business problem.
• Organize workload; establish priorities; and meet established deadlines.
• Prepare clear, concise and complete reports, correspondence and other written materials.
• Anticipate, identify and effectively resolve various issues and problems.
• Provide management with sound, positive advice and information concerning job tasks.
• Explain technical information and data findings clearly to non-technical staff and management.
• Work independently and take ownership of solutions from design through ongoing support.
• Display regular and timely attendance (report to work on time, work scheduled hours, utilize leave responsibly to ensure sufficient coverage of departmental operations, etc.).
• Comply with City and department administrative directives, policies, and procedures.
• Establish and maintain positive and cooperative working relationships with all levels of City staff and the general public.

Skills:

• Strong verbal and written communication skills.
• Strong customer service skills with City staff and vendors.
• Strong analytical, problem-solving, and time-management skills.

Licenses, Certifications & Special Requirements

Licenses:

• Texas Class C driver’s license with a good driving record as measured by the City’s evaluation system.

Special Requirements:

• On-call technical support is required on a rotating basis for all systems; must be able to respond and escalate within posted time constraints.
• Must be able to access Texas Criminal Justice Information Services (CJIS) System data. As a result, the person selected for the position cannot possess a felony or Class A misdemeanor conviction; or a Class B misdemeanor conviction within the past 10 years.

Certifications:

• Certifications such as Microsoft Power BI Data Analyst Associate and/or CompTIA Data+ are a plus.

Certificate Pay Program:

• The City of Bryan OBI provides a Certificate Pay Program (CPP) to certain positions. New employees are eligible after the first 90 days of employment. Employee must be in good standing to qualify.
• The primary goal of the CPP is to develop the technical skills of staff to improve/focus on the overall service level of IT support services.
• Receive up to $450/month in certification pay for qualifying certificates.
• Reimbursement is available for qualifying passed certificate exams while employed by the City of Bryan.

Physical Demands Physical demands include but are not limited to: sitting, talking, hearing, seeing, standing, walking, driving, bending, reaching, twisting, pushing, pulling, using hands and fingers to operate office equipment and machines, and occasionally lifting and/or moving objects up to and including 25 pounds.

Working Conditions Work is performed primarily in an office setting or a well-lighted and temperature-controlled working environment.

Equipment Work shall be performed with tools, appliances and equipment approved by those agencies and bodies that have control, authority, or approval of the design working ranges or limitations of those items; the employee has the responsibility to conform to those ranges and limitations.

Equipment may include but is not limited to: multi-line telephone, computer, printer, fax, scanner, calculator, and vehicle.

Additional Notes/Instructions for Applicants This job description is not intended to be construed as an exhaustive list of responsibilities, duties, and skills required. City management has exclusive rights to alter this job description at any time without notice.

Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. This document does not create an employment contract, implied or otherwise, other than an ‘at-will’ relationship.

Quicklink for Posting https://www.bryantxjobs.com/postings/5246