SQL Server Engineer Jobs

1 job found

Today

Software Engineer

City Brewing Co Latrobe, PA

Latrobe, PA

Today

Full time Backend Developer .NET Agentic Ai

Apply Now

Job Description

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

View full job page →

Get SQL Server Engineer Jobs alerts

New SQL Server Engineer Jobs, daily.