Data & AI Engineer

City of Bryan

Bryan (TX)

On-site

USD 65,000 - 85,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Certificate Pay Program (CPP)
Certification reimbursement

Job summary

The City of Bryan is seeking an on-site Data & AI Engineer to strengthen how data is collected, analyzed, and used to improve public services. The role builds reporting, automation, and AI-enabled solutions while enabling data-driven decision-making across departments.

Responsibilities include partnering with departments, supporting a data warehouse, building automated data loads, and creating dashboards. Ideal candidates have SQL, Power BI, and experience with automation tools; CJIS compliance

Qualifications

  • Bachelor’s degree plus two years data, reporting, or automation experience.
  • OR Associate’s degree plus four years related experience.
  • Internships or co-ops count toward the experience requirement.
  • Texas Class C driver’s license and CJIS access restrictions.

Responsibilities

  • Partner with City departments to design data-driven solutions and low-code apps.
  • Assist data warehouse implementation and maintenance per architecture.
  • Build and schedule data loads; maintain the data warehouse.
  • Create automated workflows to move data between City systems and vendors.
  • Develop reporting dashboards and web-based reports.
  • Evaluate and support AI-enabled solutions and test accuracy.

Skills

SQL proficiency
Power BI proficiency
n8n workflow automation
Power Automate proficiency
Git/version control
Python basics

Education

Bachelor’s degree in Computer Science / MIS / Data Analytics
Associate’s degree +4 years experience

Tools

n8n
Power Automate
Git
Microsoft SQL Server
Python
ETL/ELT

Job description

The City of Bryan is seeking a Data & AI Engineer (onsite) to support modernization efforts by strengthening how data is collected, analyzed, and used to streamline operations and improve public services. The role builds reporting, automation, and AI-enabled solutions while enabling data-driven decision-making across departments.

Responsibilities
  • Partner with City departments to understand business needs, identify manual or paper-based processes, and design data-driven solutions, including low-code applications.
  • Assist the City’s data warehouse consultant by implementing the warehouse according to the consultant’s architecture and design.
  • Build and schedule data loads from source systems, and maintain and support the warehouse once implemented.
  • Work with internal, vendor, and public data sources, including populating and extracting data from internal and public open datasets.
  • Create automated workflows and integrations to move data between City systems, vendor platforms, and other data sources using tools such as n8n and Power Automate.
  • Perform data analysis, including conceptualization, modeling, and presentation.
  • Design reporting dashboards and web-based reports, fulfill ad hoc reporting requests, and translate data into an understandable illustrative format.
  • Evaluate, implement, and support AI-enabled solutions, including testing accuracy and consistency before changes are put into use.
  • Monitor, troubleshoot, and maintain production data pipelines, reports, and automations.
  • Develop procedures for data validation, analysis, and presentation.
  • Handle sensitive and confidential data, including Criminal Justice Information Services (CJIS) and customer data, in accordance with City, state, and federal requirements.
  • Manage assigned projects from request through completion by tracking status, milestones, and business value such as staff time or costs saved.
  • Coordinate with vendors and IT staff on data access, integrations, and issue resolution, and work under vendor and contractor specialists on larger projects.
  • Train staff on updated tools and data processes.
  • Review and provide technical assistance for user requests for new data elements and systems, and identify and coordinate changes to the shared data environment.
  • Work with IT staff on database structures, data modeling, storage, backup and recovery, software upgrades, and test environments to support data integrity and security.
  • Support evaluation and recommendations for data management and reporting software, including coordination and support for migration to new platforms.
  • Research and recommend modern data tools, including AI-enabled platforms, to support modernization.
  • Maintain documentation of solutions, processes, and procedures so others can operate and support them.
  • Review and approve changes submitted by other staff through version control using git pull requests.
  • Perform related duties as required, including responding regularly and promptly to work.
Required Qualifications
  • Bachelor’s degree in Computer Science, MIS, Data/Business Analytics, Statistics, or a similar field, plus two (2) years of professional experience in data, reporting, or automation, including SQL and use of data visualization tools such as Power BI or similar.
  • OR, an Associate’s degree plus four (4) years of directly related experience in the areas listed above.
  • Internships and co-ops in these areas count toward the required experience.
  • Texas Class C driver’s license with a good driving record as measured by the City’s evaluation system.
  • On-call technical support is required on a rotating basis for all systems, with the ability to respond and *escalate* within posted time constraints.
  • Ability to access Texas Criminal Justice Information Services (CJIS) System data, with restrictions on felony/Class A misdemeanor convictions and Class B misdemeanor convictions within the past 10 years.
  • Employees must follow other job-related instructions and perform other duties as requested by authorized persons.
Preferred Qualifications
  • Experience supporting municipal government applications.
  • Experience with data engineering, workflow automation (such as n8n and Power Automate), version control (git), and/or applied AI/ML.
  • Certifications such as Microsoft Power BI Data Analyst Associate and/or CompTIA Data+.
Technologies
  • SQL
  • Power BI
  • n8n
  • Power Automate
  • Python
  • git
  • Microsoft SQL Server
  • ETL/ELT
  • Microsoft Power BI Data Analyst Associate
  • CompTIA Data+
Compensation

USD 65,000 - 85,000 per year.

Benefits
  • Certificate Pay Program (CPP): 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.
Working Conditions, Equipment, and Physical Demands

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

Equipment: May include multi-line telephone, computer, printer, fax, scanner, calculator, and a vehicle.

Physical demands: Includes sitting, talking, hearing, seeing, standing, walking, driving, bending, reaching, twisting, pushing, pulling, and using hands and fingers to operate office equipment and machines, with occasional lifting or moving objects up to and including 25 pounds.

Additional Notes
  • City management has exclusive rights to alter this job description at any time without notice.
  • This document does not create an employment contract, implied or otherwise, other than an at-will relationship.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data & AI Engineer
Data & AI Engineer

by Strategic Government Resources, Inc. • Bryan (TX)

On-site
USD 65,000 - 85,000
Data & AI Engineer for City Modernization
Data & AI Engineer for City Modernization

City of Bryan • Bryan (TX)

On-site
USD 65,000 - 85,000
Certificate Pay Program (CPP)
Certification reimbursement
City Engineer
City Engineer

City of Bryan • Bryan (TX)

On-site
USD 95,000 - 130,000
Payroll Technician
Payroll Technician

City of Bryan • Bryan (TX)

On-site
USD 40,000 - 56,000
Public Sector Data & AI Engineer for Digital Modernization
Public Sector Data & AI Engineer for Digital Modernization

by Strategic Government Resources, Inc. • Bryan (TX)

On-site
USD 65,000 - 85,000
Data Engineer II
Data Engineer II

City of Boise • Boise (ID)

Hybrid
USD 90,000 - 130,000
Employer-paid health coverage
PERSI retirement with employer match
Paid time off and holidays
+2
1000000881.DATA ENGINEER II.INFO TECH - OPERATIONS
1000000881.DATA ENGINEER II.INFO TECH - OPERATIONS

Dallas County • Texas

On-site
USD 90,000 - 130,000
Strategic Process & Project Analyst
Strategic Process & Project Analyst

Strategic Government Resources, Inc. • Georgetown (TX)

Hybrid
USD 69,000 - 86,000
Sr Data and Performance Analyst
Sr Data and Performance Analyst

City of Sugar Land, TX • Paynes (TX)

On-site
USD 74,000 - 86,000
Benefits from Day 1
Pension with city match
Paid holidays & leave
+2
IT MANAGER
IT MANAGER

City of Royse City • Royse City (TX)

On-site
USD 90,000 - 130,000