• Analyze the needs of internal clients and translate them into technical solutions • Design, develop and maintain software using a LAMP stack • Build and maintain APIs, integrations and internal tools • Use AI-assisted development tools such as Claude.ai to improve productivity, debugging, documentation and test coverage • Review, validate and secure AI-generated code before it is used • Design and develop in accordance with established best practices, coding standards and security guidelines

• Develop and enhance backend services and APIs using C# and .NET within a modern microservice architecture • Design and implement modern REST interfaces • Work with PostgreSQL and Microsoft SQL Server • Take active responsibility for the production operation of your services across the entire software lifecycle • Analyze and sustainably resolve bugs, performance issues, and technical debt • Collaborate closely with frontend, QA, UX, product management, and other development teams • Contribute to technical decisions and the continuous modernization of our products • Opportunity to help shape new AI tools and AI-supported product features

Role Description - Design and maintain various databases, including stored procedures, indexing, and data models. - Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server. - Execute large-scale data migrations, including cleansing, validation, and transformation across enterprise systems. - Develop and optimize SQL scripts and stored procedures to support data conversion, validation, and ongoing processing needs. - Build data ingestion and transformation workflows across raw, staging, curated, and analytics layers. - Build and maintain various reporting solutions using SSRS and PowerBI. - Design and implement logical and physical data models (ERDs) for various applications. - Develop stored procedures, views, SQL scripts, and other database components supporting transactional and reporting systems. - Provide production support, including troubleshooting performance issues and on-call support when needed. - Collaborate with cross-functional teams and participate in Agile ceremonies, development activities, code reviews, and release cycles. - Provide knowledge transfer. Qualifications - 10+ years of experience in database development or data engineering. - Expertise in SQL Server, T-SQL and performance tuning. - Experience with ETL tools (SSIS), Python, or PySpark. - Strong background in data modeling and data integration. - Experience with reporting tools (SSRS, PowerBI). - Working knowledge of DevOps tools such as Azure DevOps, GitHub, or Jenkins. - Experience supporting critical applications in financial, government, or legal industries.

Role Description We are seeking a Software Engineer to collaborate with cross-functional teams in creating innovative solutions that support AVB Marketing clients' eCommerce presence. This role will be responsible for developing, testing, troubleshooting, and deploying web applications while partnering closely with development, design, and DevOps teams. The ideal candidate is passionate about building high-quality, maintainable software and delivering reliable solutions that enhance the user experience. Supervisory Responsibilities - N/A Essential Functions and Responsibilities - End-to-end development: design, develop, test and fix bugs - Troubleshoot code and implement fixes - Collaborate with development and design teams to create functional and user-friendly applications - Work closely with the DEVOPPS/IT team to design deployment procedures for products and take ownership of rollouts to ensure success - Write high-quality code for web applications or perform updates to existing codebases that are easily understandable and maintainable - Develop software solutions following enterprise architecture, processes, procedures, and protocols Remote Work/Travel This position will work remotely from a home address and is subject to AVB's Remote Work policies and procedures which are then in effect. In addition, from time to time, this position will be required to engage in travel, including travel to attend AVB's Annual All-Employee Meeting as well as other travel obligations which may be required of the position such as meetings with members, attendance at conventions and shows and other events where you will represent AVB. (Any requests for accommodations to required travel (including medical) should be addressed with Human Resources.) Required Skills and Abilities - Strong troubleshooting and critical thinking skills - Proficiency in developing PHP applications - In-depth knowledge of PHP and Magento - Experience with AWS Lambda, EC2, 53, and RDS - Familiarity with MVC architecture and RESTful API development - Strong understanding of optimized web server configurations and experience in scaling web applications on AWS - Familiarity with DevOps practices and Cl/CD pipelines on AWS and/or GitHub - Ability to implement security best practices for PHP applications - Demonstrated problem-solving skills in AWS cloud environments Education and Experience - Bachelor's degree (preferably in Computer Science or a related field) or equivalent experience - Minimum of 3 years of hands-on experience in developing PHP applications - Experience working with MySQL Server and SQL - Experience working in an Agile SCRUM environment - Proven track record of PHP development with a strong emphasis on Magento - Practical experience working with AWS services, including but not limited to AWS Lambda, EC2, 53, and RDS - Familiarity with DevOps practices and setting up Cl/CD pipelines - Any relevant AWS certifications would be considered a significant asset for this position Physical Requirements - Prolonged period of sitting at a desk and working on a computer