Excel VBA Developer Job Description
Excel VBA developer
provides expert technical knowledge and leadership in the use of enterprise middleware development tools/languages, object oriented application design, and enterprise application environment architecture.
Excel VBA Developer Duties & Responsibilities
To write an effective excel VBA developer job description, begin by listing detailed duties, responsibilities and expectations. We have included excel VBA developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Develop MS-Office document interaction with SQL server utilizing VB for applications, javascript, and SQL
Full development life cycle , analysis, design, implementation and support of RAD application portfolio
You will take ownership and accountability of specific modules within an application and provides technical support and guidance during solution design for new requirements, problem resolution for critical / complex issues
You will represent/lead discussions related to product/application/modules/team (for example, leads technical design reviews)
Work closely with the Front Office on our Trading platform
Coach and Mentor junior team members as required
Maintain end user relationship relationship with other development teams across Rates Technology
Mathematics, Computer science or numerical related degree strongly desirable
Production, analysis, certification, consolidation and reporting of all financial data, and production of risk and regulatory indicators of market and brokerage activities for MACC partners and stakeholders including but not limited to P&L, P&L attribution, VaR, Stressed VaR, Stress Tests and Market Risk sensitivities
Support of business lines, Risk and Finance departments on regular reports and ad hoc requests
Excel VBA Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Education for Excel VBA Developer
Typically a job would require a certain level of education.
Employers hiring for the excel VBA developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Collage Degree in Computer Science, Mathematics, Information Technology, Engineering, Science, Education, Technical, Finance, Computing, Software Development
Skills for Excel VBA Developer
Desired skills for excel VBA developer include:
Excel/VBA
Object-oriented programming
Phases of application systems is maintained
SQL
Accounting systems
Application
Computer skills and languages is an advantage
Data and infrastructure architecture disciplines
Data visualization best practices
Experience with PC
Desired experience for excel VBA developer includes:
Front-office/risk management business knowledge Knowledge of financial instrument features and trade processing would be a definite plus
Knowledge of Relational Database Modeling
Previous experience in Banking Operations a plus
Strong understanding of Interest Rate derivatives ( would consider Fixed income, Credit or FX derivs )
Mathematics, Computer science or numerical related degree
Financial background, esp
Excel VBA Developer Examples
1
Excel VBA Developer Job Description
Job Description Example
Our company is looking to fill the role of excel VBA developer. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for excel VBA developer
- Experience in SQL to link Excel to Oracle or SAS datasets
- Maintenance and quality controls of market data related to all businesses
- Contribution to the definition of Information System strategies and lead initiatives related to organization and process developments
- Develop and modify Stage / Gate process models as necessary using enterprise Accolade Project and Portfolio Management (PPM) Software
- Provide project management for the implementation of new software releases and business processes (small to medium size projects)
- Document and communicate objectives, plans, status, issues and risks in a timely manner to team members, stakeholders, and senior management
- Work proactively with our pricing tool stakeholder community in underwriting and actuarial to define technical requirements for pricing tool changes
- Implement modifications to our pricing tools using sound coding and development principles with robust unit testing
- Collaborate with Actuarial to support accuracy testing for changes impacting calculations or pricing
- Regularly demonstrate work in-process to our tool stakeholders to ensure the outcome is in alignment with the business needs
Qualifications for excel VBA developer
- Experience developing/working within Financial Industry
- BS or MS in Computer Science, Management of Information Systems or comparable
- Perform analysis, design, coding and testing for Excel based applications
- Must be able to analyze, write code and do testing
- Must be able to do technical documentation like impact analysis, test cases
- Must have excellent programming knowledge of MS Excel VBA macros, excel functions and good general coding knowledge
2
Excel VBA Developer Job Description
Job Description Example
Our company is looking to fill the role of excel 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 excel VBA developer
- Integrate capability in Excel-based tools to both pull and push data from/to SQL Server
- Playing a crucial role on a cross-functional Scrum team
- Estimating, designing, and developing code solutions for existing and new projects
- Coding, testing, debugging, and documenting programs on complex projects
- Determines business requirements and department needs in terms of automations
- Ensures EUC requirements are met
- Review with the manager/team leader to prioritize the solution requirements that meets the needs of the department, assessing the current state of business to identify and recommend improvements
- Responsible for design, development and testing ( with or without support of the operational teams)
- Development, delivery and testing of custom dashboard applications and reports on ActixOne platform
- Provide solution to customers for their reporting needs
Qualifications for excel VBA developer
- Knowledge of statistics is desirable
- 5+ years of experience with Microsoft products including SharePoint and Excel, the sophisticated use of VBA development practices are required
- 5+ years’ experience with project management disciplines
- 2-4 year Degree with a focus in Information Technology or related discipline
- 3+ years SharePoint Development
- 3+ years’ Experience with report writing (SSRS, SSAS, QlikView, Sense)
3
Excel VBA Developer Job Description
Job Description Example
Our innovative and growing company is looking for an excel VBA developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for excel VBA developer
- Excellent Word, Excel, Visio, and PowerPoint skills
- Proven record of quick, insightful analysis and high-caliber reporting, delivered with compelling style
- Accustomed to working in a fast-paced market environment
- Work with team to produce technical documentation, test scripts and test cases from requirements
- Ability to recognize and solve problems efficiently and work effectively with a small team
- Completing all tasks accurately and in a timely manner
- Building and maintaining strong internal relationships across multiple teams / departments
- Identifying and building efficiencies into the Operations team processes
- Analysing client / internal team requirements and providing smart, automated solutions that will make the process more accurate and efficient by reducing manual errors
- Understanding key business issues and what solutions can be built using data to address them
Qualifications for excel VBA developer
- Proven background on MS Excel VBA Programming and coding
- Proven background completing projects under aggressive financial and time constraints
- Experience in .Net is a big plus
- Star schema structures knowledge is a plus
- Willing to learn and self-teach any new technology
- At least 3 years of programming / systems analysis experience
4
Excel VBA Developer Job Description
Job Description Example
Our company is looking to fill the role of excel 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 excel VBA developer
- Helping to grow team capability in data systems and solutions
- Working with Operations Associate Director and Data Sciences team to ensure that naming conventions and booking categories are standardised to enable ease of reporting
- Developing basic knowledge and understanding of all media
- Proactively contributing to team meetings, team initiatives and knowledge sharing
- Testing the dashboard and systems for all the different variables to ensure they provide accurate results under different conditions
- Understand, evaluate, and document business requirements
- Translate business requirements into specific solutions
- Develop robust spreadsheet models with clearly defined inputs, calculations, and final output
- Provide documentation including data flow mapping for new and existing spreadsheet models
- Develop automated and reusable routines for extracting information from various data sources
Qualifications for excel VBA developer
- Development tools (SVN, JIRA Maven )
- Ability to work independently great team player
- Minimum 3 years of programming / systems analysis experience preferred
- Underwriting and Actuarial prior experience preferred
- Working directly with Private Client Fund Managers and other business users to develop and enhance front office systems/macro based applications
- Developing and maintaining IT systems internally for the Investments business, where is it not practical for these to be supplied by third parties
5
Excel VBA Developer Job Description
Job Description Example
Our innovative and growing company is looking to fill the role of excel VBA developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for excel VBA developer
- Partner with the Operational Excellence Team and Lean Champions to formulate solutions for continuous improvement of order processing to reduce waste & increase efficiency
- Identify opportunities to implement Macros/VBA scripts or other technology to decrease manual order touches and automate processes
- Lead solution delivery of identified continuous improvement opportunities including analysis, design, development, testing, and implementation
- Document implemented continuous improvement solutions for effective maintenance and sustainability
- Ensure efficient execution of rule-based order processing with the development of scripts to automate repetitive tasks
- Produce and analyze Customer and Key Performance Indicator (KPI) reporting
- Identify opportunities to automate the production of Customer and KPI reporting for accessibility effectiveness
- Provide escalation support to Collaboration and Centralized teams for issues that require additional subject matter expertise to resolve
- Sarbanes Oxley Act Reporting (SOAR) reporting
- International Organization for Standardization (ISO)
Qualifications for excel VBA developer
- Working closely to understand the data and database schema held within the system so as to be able to lead data migrations to other systems
- Working with third party vendors on Support tickets and issues and following up for a timely resolution
- Working with external third party providers on data interfaces to be implemented between systems
- Working with Project teams as part of the delivery team, suggesting business solutions and seeing them through to implementation
- Advanced Excel VBA Programming skills
- Extensive expertise with stored procedure and function development, packages, triggers