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.