Data & AI Engineer

Job Description

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.

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.