VBA Developer Job Description
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:
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:
Desired experience for VBA developer includes:
VBA Developer Examples
VBA Developer Job Description
- 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
- 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
VBA Developer Job Description
- 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
- 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
VBA Developer Job Description
- 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
- 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
VBA Developer Job Description
- 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
- 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
VBA Developer Job Description
- 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
- 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