Data & AI Engineer
Job Description
The City of Bryan is seeking a Data & AI Engineer to support modernization efforts by strengthening how data is collected, analyzed, automated, and used to improve operations and public services. This role focuses on building reporting, integrations, production data pipelines, and AI-enabled solutions while supporting data-driven decision-making across departments.
Key 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 based on the consultant’s architecture and design, including building and scheduling data loads from source systems; maintain and support the warehouse after implementation.
- Work with internal, vendor, and public data sources, including populating and extracting data from internal and public open datasets.
- Build automated workflows and integrations using platforms such as n8n and Power Automate to move data between City systems, vendor platforms, and other data sources.
- Perform data analysis, including conceptualization, modeling, and presentation.
- Design reporting dashboards and web-based reports to present data clearly and fulfill ad hoc reporting requests.
- Evaluate, implement, and support AI-enabled solutions, including testing results for accuracy and consistency prior to deploying changes.
- Monitor, troubleshoot, and maintain production data pipelines, reports, and automations.
- Develop procedures for data validation, analysis, and presentation.
- Handle sensitive and confidential data, including CJIS and customer data, in accordance with City, state, and federal requirements.
- Manage assigned projects from request through completion, including tracking status, milestones, and business value (for example, staff time or costs saved).
- Coordinate with vendors and IT staff on data access, integrations, and issue resolution; work under the direction of vendor and contractor specialists on larger projects.
- Train staff on updated tools and data processes.
- Review and provide technical assistance to user requests for new data elements and systems, and coordinate changes to the existing 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.
- Assist with evaluating and recommending data management and reporting software, including coordinating and supporting 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 and respond regularly and promptly to work needs.
Required Qualifications
- Bachelor’s degree in Computer Science, MIS, Data/Business Analytics, Statistics, or similar field, plus two (2) years of professional experience in data, reporting, or automation, including SQL and use of data visualization tools (for example, 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.
- A 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 CJIS System data; cannot possess a felony or Class A misdemeanor conviction, or a Class B misdemeanor conviction within the past 10 years.
- Employees must follow other job-related instructions and perform other job-related duties requested by authorized persons.
Preferred Qualifications
- Experience supporting municipal government applications.
- Experience with data engineering, workflow automation (for example, n8n, Power Automate), version control (git), and/or applied AI/ML.
Tools & 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
Location & Work Setting
Bryan, TX (onsite). Work is performed primarily in an office setting or a well-lighted and temperature-controlled working environment.
Physical Demands & Equipment
Physical demands may include 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 or moving objects up to and including 25 pounds.
Equipment may include multi-line telephone, computer, printer, fax, scanner, calculator, and a vehicle.
Benefits
- Certificate Pay Program (CPP): Receive up to $450/month in certification pay for qualifying certificates.
- Exam reimbursement: Reimbursement is available for qualifying passed certificate exams while employed by the City of Bryan.
Certifications
- Certifications such as Microsoft Power BI Data Analyst Associate and/or CompTIA Data+ are a plus.
Additional Notes for Applicants
- 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.