What are the responsibilities and job description for the Senior VBA Developer position at BCS Financial Corporation?
Position Overview
The Senior VBA Developer will be responsible for designing, developing, and maintaining applications using Visual Basic for Applications (VBA) across Microsoft Office Suite and other enterprise applications. The ideal candidate should have a strong background in Excel automation, Access databases, and integration with SQL Server. This role requires excellent problem-solving skills, attention to detail, and the ability to collaborate with business users to optimize workflows and automate processes.
This role will report to the Head of Software Solutions.
Essential Elements
- Develop, maintain, and optimize VBA applications in Excel, Access, and other Microsoft Office tools.
- Expert level understanding of SQL Server in creating/supporting complex queries, stored procedures, triggers, Views, CTEs etc.
- Enhance macros and automation scripts to improve business processes and efficiency.
- Integrate VBA applications with SQL Server and other databases for data retrieval and manipulation.
- Troubleshoot, debug, and enhance existing VBA applications.
- Work closely with business users to understand requirements and develop tailored solutions.
- Design and implement user-friendly interfaces, ensuring usability and efficiency.
- Automate reporting processes using Power Query, Power Pivot, and Power BI.
- Maintain proper documentation and version control of scripts and applications.
- Provide technical support and mentoring to junior developers when needed.
- Good Knowledge of Azure DevOps or other similar Work Management/Code Management tools e.g - Jira/Team foundation Server/VSS etc.
Requirements
Education and Certifications
- Bachelor’s degree in Computer Science, Management Information Systems or similar, or commensurate experience required.
Experience
- Minimum 12 years of professional experience in VBA development.
- Expert proficiency in Excel VBA, Access VBA, and macro automation..
- Strong experience integrating VBA applications with SQL Server (T-SQL, Stored Procedures, Queries).
- Proficiency in Microsoft Office applications (Excel, Word, Outlook, PowerPoint, Access).
- Knowledge of Power BI, Power Query, and Power Pivot for data visualization and reporting.
- Experience in debugging and performance optimization of VBA applications.
- Understanding of Object-Oriented Programming (OOP) principles within VBA.
- Strong analytical skills and ability to optimize business processes through automation.
- Excellent communication skills to interact with stakeholders and translate business needs into technical solutions.
Travel Required
- Up to 10% travel to Oakbrook Terrace, IL office.
Competencies
BCS Core Competencies
Informing, Customer focus, Action oriented, Drive for results, Learning on the fly, Courage
