Software Engineer

The Software Engineer at City Brewing Co in Latrobe, PA (onsite) helps users and customers turn business needs into reliable desktop and web applications, reports, integrations, and data-driven automation, including AI-enabled solutions.

What You’ll Do

• Develop and maintain applications, reports, interfaces, and data collection processes.
• Use programming languages including C#, PHP, .NET, and JavaScript, applying Object-Oriented Design to build, maintain, and enhance business applications.
• Design, code, and implement custom business applications, including development of specifications.
• Create high-performance reports using SQL, working with complex data schemas to write efficient queries.
• Develop complex SQL Server database objects, including stored procedures, views, and related components.
• Design, develop, and maintain SSIS ETL processes and support SSRS production and test environments.
• Apply standard coding practices, using source control and change control.
• Create test plans and perform thorough testing and debugging before implementation.
• Build data auditing techniques with users to support data integrity.
• Coordinate with the IT team and project managers to provide timeline and task information based on project scope.
• Contribute to IT Development standards, including coding and testing standards.
• May serve as a project leader and direct the work of others.
• Support software evaluation by recommending acquisitions and implementations.
• Evaluate, recommend, and implement business application upgrades.
• Coordinate system bug, enhancement, and upgrade requests with vendors and internal users, including specification, testing, and implementation support.
• Collaborate with business analysts and end users to understand requirements and develop program specifications.
• Work with users to establish business procedures, standard practices, and documentation that support efficient application usage.
• Identify and implement AI and generative AI solutions to improve operational efficiency, reporting, and user/customer experience.
• Design, build, and deploy agentic AI solutions, including autonomous agents and multi-step workflows that use tools and APIs.
• Integrate LLMs and AI services into existing and new applications using APIs and integration frameworks such as Model Context Protocol (MCP).
• Apply prompt engineering, retrieval-augmented generation (RAG), and agent orchestration techniques to build reliable and 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 support team adoption of AI tools.
• Communicate with the digital team, end users, and customers as needed.
• Collaborate with business users, Helpdesk, and Technical Support Associates to troubleshoot issues.
• Follow City Brewing Standards and Systems Standards for development and support work, provide input for IS Standards changes, and assist with security practices.
• Identify, evaluate, and proactively resolve problem trends; execute action plans using established processes.
• Troubleshoot questions and problems, including participation in the On Call Support rotation with other Applications team members.
• Maintain information security and confidentiality, reporting unauthorized incidents to management, 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.

Requirements

• 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 programming with C#, PHP, .NET (.NET Core or similar), and JavaScript, using 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 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.
• Ability to plan and track ongoing projects.
• Troubleshooting ability and attention to detail.

Key Technologies

• C#, PHP, .NET, JavaScript
• Object-Oriented Design
• SQL, Microsoft SQL Server, T-SQL
• SSIS, SSRS, SSAS
• Web APIs, REST
• Agile
• LLMs, generative AI, agentic AI, autonomous agents, multi-step workflows
• APIs, Model Context Protocol (MCP)
• Prompt engineering, retrieval-augmented generation (RAG), agent orchestration
• Human-in-the-loop controls, AI-assisted development tools