Report/VBA Developer in Azusa, CA at ANCRA INTERNATIONAL, LLC

Date Posted: 3/21/2020

Job Snapshot

  • Employee Type:
  • Location:
    Azusa, CA
  • Experience:
    Not Specified
  • Date Posted:

Job Description

Essential Duties and Responsibilities:

• Review, analyze and evaluates business system and user needs.
• Develop SSRS Based Reports
• Gather and document customer and other requirements for the reports
• Implement analytical reporting using SSRS
• Perform gap analysis on existing state of requirements in conjunction with current business needs.
• Elicit requirements using various elicitation techniques such as Brainstorming, Data Mining, Document Analysis, Interviews with users, risk analysis to produce requirement artifacts such as Field Definition Matrix, Business Rules, activity diagrams and Wireframes.
• Participate in the review of current business processes and demonstrate improved processes.
• Possess strong knowledge of VBA/macro programming and security best practices.
• Using VBA security best practices, create solution with VBA/macro programming in Microsoft Access, Excel, and Word.
• Coordinate and provide end user training, solution, and training documentation.
• Work closely with other Business Systems Analysts, Process Owners and Development Teams as required on projects and initiatives.
• Possess strong organization, analytical, problem solving, and interpersonal skills. Self-motivated and able to develop rapport and positive working relationships with coworkers.

Qualifications and Skills:

• Review, analyze and evaluate user/system needs
• Strong business process analysis skills with the ability to translate requirements into solutions
• Strong troubleshooting and problem-solving skills.
• Initiative to be a self-starter and require minimal management and direction.
• Ability to multi-task and expand previous levels of knowledge.
• Willingness to learn and continue to improve.
• Perform Gap analysis
• Produce end user training artifacts.
• VBA/macro programming in Microsoft Access, Excel, and Word
• Analyzing functional/non-functional system requirements.
• Business processes Re-engineering
• End user training
• Proficient with Microsoft Word and Excel
• Organization skills
• Written and oral communication skills.


• VBA/macro programming: 8 years (Preferred)
• 2-3 years of development experience with SSRS
• Extensive knowledge of SQL queries
• Experience gathering and documenting requirements
• Experience coordinating multiple projects

• Bachelor's, a plus.