VBA Developer Job Description
VBA developer
provides software expertise in Java, Angular, MS Power Apps/Power BI/Power Automate often in conjunction with SharePoint.
VBA Developer Duties & Responsibilities
To write an effective VBA developer job description, begin by listing detailed duties, responsibilities and expectations. We have included VBA developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop and test solutions using Access, VBA, .NET and SQL Server
To lead a team of VBA developers who develop and maintain a large number of spreadsheets for a valuation control group
Design and development of applications to assist in day-to-day tasks
Development lifecycle from requirements gathering, analysis & design, programming, implementation, testing and release with a focus on delivering solutions against business goals, technical requirements and platform engineering standards
The spreadsheets are used to price benchmark trades running risk predicts based on numbers received from external risk management systems
Development of database structures, views, stored procedures, functions and triggers
Use source control systems to manage their code changes
Work with other developers to merge and test code changes prior to release
Work with users so that they can perform UAT and sign-off prior to release
Manage the packaging and release process
VBA Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for VBA Developer
List any licenses or certifications required by the position: CECRL, B2, A2, APICS
Education for VBA Developer
Typically a job would require a certain level of education.
Employers hiring for the VBA developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and University Degree in Computer Science, Engineering, Finance, Education, Mathematics, Technical, Business, Accounting, Information Technology, Science
Skills for VBA Developer
Desired skills for VBA developer include:
SQL
Ariba
Cognos
MS-Access
Power BI
VBA
Power BI License model
Database analysis
Defined Benefits Domain
Design
Desired experience for VBA developer includes:
Ability to work independently part of a small team in fast-paced environment to drive issues through to completion
Relevant product experience with including but not limited to
Designing and implementing new features to existing application (forms, functions)
Understand users‘ requirements, seeking clarification if necessary, and record the requirements in JIRA
Work remotely with the users, communicating by email, telephone and instant messaging
Support alongside development projects
VBA Developer Examples
1
VBA Developer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of VBA developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for VBA developer
- Responsible for the design, development, and maintenance SQL Server Tables and Stored Procedures
- Collaborate with other team members to design and implement projects
- Analyze, design, and coordinate the development of software systems
- Strong knowledge of Visual Basic, VBA, VB.NET
- Provide timely support to users when they experience production issues
- Support occasionally weekend outages
- Report progress and escalate issues to management
- Work under strenuous schedules when necessary
- Occasional travel to UK may be required (once or twice a year)
- Maintenance and supporting the systems once they are up and running
Qualifications for VBA developer
- VBA programming knowledge (minimum 2 years)
- Dashboard reporting skills
- Expert/Advance Level MS Excel
- Top academics in A Levcls and University with a 2.i or higher achieved from a STEM (Science, Technology, Engineering or Mathematics)
- VBA Excel / Access database management
- C# development experience, ideally in .Net 4.0/4.5, experience in other programming languages such as Java, Python or C++ is a strong plus
2
VBA Developer Job Description
Job Description Example
Our company is looking for a VBA developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for VBA developer
- Excellent knowledge of VBA and Adv Excel
- Excellent SQL and MS Access skills with a proven experience of building complex Queries and basic visual code
- Gathering requirements, designing and executing solution on Excel VBA platform
- Production, certification, analysis and reporting of all financial data, risk and regulatory indicators related to market trading activities
- Monitoring of market risk exposures, ensuring that there is a clear and transparent flow of independent information to senior management on a daily basis
- Develop dashboards in Excel using Pivot Tables, Power Pivot
- Collect and connect data across the databases and information sources
- Write code/test code for part of software component/ work product
- Work together with a Process Specialists (coordinators) to prioritize the work, organize tasks and ensure timely and qualitative closure of all digitization projects
- Identify and resolve defects during test cycles and intensive care
Qualifications for VBA developer
- Test Driven Development (TDD) experience and Pair Programming
- Passion to understand and problems, building on domain knowledge and increasing market understanding
- Passion for development and programming both inside and outside of work
- Front office experience within a hedge fund, investment bank or asset management firm
- Experience working with Quants and Traders
- Familiar with SQL databases such as Redis or RabitMQ
3
VBA Developer Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of VBA developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for VBA developer
- For the first 12 months, VBA work will be 75% or more
- Understand the full SDLC
- Create well-designed, testable, and efficient code
- Review and debug existing source code
- Gather scope requirements and accurately document for software development
- Knowledge of ERP platforms a plus
- Objective-C / iOS programming experience a plus
- Selects, designs, develops, authorizes, and manages end user applications using products defined by Information Technology to ensure maximum efficiency of workflow, adherence to various provincial legislative requirements and corporate requirements, and to maintain outstanding customer service and effective process management minimizing delays and the need for assistance from other departments to implement changes and day to day management
- Provides technical advice/support, mentoring and direction to internal and external users in the functional areas to ensure the effective and efficient communication and resolution of issues
- Provides technical expertise and leadership on process improvements and technological solutions to ensure outstanding customer service and effective process management, within the department and corporately
Qualifications for VBA developer
- Development of tools based on MVC4/5 and ASP.NET with the use of C# or VB.NET
- Development of tools in VBA (Excel and Access)
- Point of technical advice and support for the tools created by the team
- Gathering of technical requirements and converting them into outstanding solutions
- Advanced IT Skills, especially in VBA/Excel
- Familiar with SQL Server 2008 SSRS
4
VBA Developer Job Description
Job Description Example
Our innovative and growing company is looking for a VBA developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for VBA developer
- Design automated trading systems
- Write macros and libraries for Excel in VBA
- Design, develop, test, deploy and maintain applications and modules
- Create new VBA macros
- Provides technical leadership to the business on a wide variety of corporate projects to define strategy and implement initiatives, in support of the achievement of department and corporate goals
- Assists in the determination of scope, development, and documentation of requirements, and the coordination of testing
- Co-ordinates projects, including testing, as assigned by management to assist in the achievement of functional objectives
- Ability to work an 8 hour work day between the hours of 6 a.m
- Resolve issues and provide updates for management
- Ensure that new database codes meet company standards for readability, reliability, and performance
Qualifications for VBA developer
- Familiar with software development methodologies and experienced several full software development life-cycles
- Must possess very strong VBA programming skills for MS Acess and MS Excel
- Strong in object-oriented programming, analysis and design
- Excellent in written and verbal communication and presentation skills
- Must be able to effectively communicate complex technical concepts with fellow team members
- Very Strong MS SQL Server development skills
5
VBA Developer Job Description
Job Description Example
Our company is growing rapidly and is looking for a VBA developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for VBA developer
- Develop new macros and convert business requirements into efficient VBA code
- Maintain existing VBA Macros and support the debug, maintenance and enhancement of existing macros
- Proven experience in estimation, planning and managing technology projects
- Can handle Standalone projects independently, and have hands on experience in Reporting within deadline
- Although the candidate will be operating as part of a team he/she will be client facing and individually responsible for the tasks they are assigned
- Communication with Product Owner and with users
- Sustain solution and be available to fast fix bugs or implement enhancements
- May include also planning tasks, based on candidate capabilities and experience
- Responsible for primary technical ownership and support of current MS Excel and MS Access based custom Applications
- Develop and automate end-user Excel applications and reports
Qualifications for VBA developer
- Risk Management Analyst/Quantitative Development experience
- Broad experience covering Fixed Income, Equity, and hybrid/structured products in both cash and derivatives markets
- Bachelors in Computer Science with 10 years experience in the financial industry
- Experience with agile development methodologies, test driven development
- Able to work under high pressure and multi-tasking
- Experience on communcation with vendors and users