Duties and Responsibilities
Development & Support
Develop and maintain applications, reports, interfaces and data collection processes.
Use programming languages such as C#, PHP, .NET and JavaScript, including Object-Oriented Design, to develop, maintain and enhance applications for the business.
Design/code/implement custom business applications and develop specifications.
Design high-performance reports using SQL and understand complex data schemas to write efficient queries.
Develop complex SQL queries, stored procedures, views and other database objects in Microsoft SQL Server.
Design, develop and maintain SSIS ETL processes and manage SSRS production and test environments.
Use standard coding techniques, source control and change control.
Develop test plans and thoroughly test and debug all programs before implementation.
Develop data auditing techniques with users to ensure data integrity.
Work closely with the IT team and project managers to provide timeline and task information based on proposed project scopes.
Actively participate in developing and maintaining IT Development standards, including coding and testing standards.
May act as project leader and direct the work of others.
Business Applications Support
Assist with software evaluation and make recommendations for acquisition and implementation.
Evaluate, recommend and implement business application upgrades.
Coordinate system bug, enhancement and upgrade requests with vendors and internal users, assisting with specification, testing and implementation.
Work with users to develop proper business procedures, standard practices and documentation to support efficient use of business applications.
Collaborate with business analysts and end users to understand project requirements and develop program specifications.
AI & Agentic AI
Identify, evaluate and implement AI and generative AI solutions that improve operational efficiency, reporting and the user experience.
Design, build and deploy agentic AI solutions, such as autonomous agents and multi-step workflows that use tools and APIs to complete business tasks.
Integrate large language models (LLMs) and AI services into existing and new applications through APIs and integration frameworks such as the Model Context Protocol (MCP).
Apply prompt engineering, retrieval-augmented generation (RAG) and agent orchestration techniques to build reliable, maintainable solutions.
Establish guardrails, testing, monitoring and human-in-the-loop controls so AI outputs are accurate, secure and auditable.
Use AI-assisted development tools to improve code quality, testing, documentation and delivery speed.
Partner with business users to identify AI automation opportunities and train teams to use AI tools effectively.
Communication
Communicate with other members of the digital team, end users, customers as necessary.
Collaborate with business users, the Helpdesk and Technical Support Associates to troubleshoot problems.
Project Standards & Procedures
Follow all City Brewing Standards and Systems Standards to develop and support projects.
Provide input to IS Standards for modifications or changes.
Production Issues
Identify and proactively resolve problem trends.
Execute action plans for problem resolution following established processes.
Troubleshoot questions and problems.
Participate in the On Call Support rotation with other Applications team members.
Security & Confidentiality
Maintain information security and confidentiality, reporting unauthorized incidents to management.
Suggest and recommend ideas for systems and data security, including secure and responsible use of AI.
Follow City Brewing values and perform other duties as assigned by the supervisor.
Minimum Qualifications
Bachelor’s or associate degree in computer science, Information Technology, Software Engineering, Management Information Systems or a related field or at least 5 years of related relevant experience
ERP or Warehouse Management Systems (WMS) applications experience preferred.
3-5 years of experience in programming languages including C#, PHP, .NET (.NET Core or similar) and JavaScript, with Object-Oriented Design.
3-5 years of experience with Microsoft T-SQL and Microsoft BI technologies (T-SQL, SSIS, SSRS, SSAS).
Experience with Web APIs and REST-based communication.
Experience in Agile development practices preferred.
Hands-on experience applying AI and generative AI (LLMs) to solve business problems, including integrating them into applications through APIs.
Experience designing, building or deploying agentic AI solutions, including tool use, multi-step workflows and agent orchestration.
Experience using AI-assisted development tools in day-to-day engineering work.
Understanding of AI governance, data security and responsible-use practices, including testing and human oversight of AI outputs.
Ability to work with internal and external users to translate needs into system solutions.
Planning and tracking of ongoing projects.
Troubleshooting and attention to detail.
City Brewery is an Equal Opportunity Employer, and all applicants will be considered without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.
