SoluStaff

Returning Candidate?

VBA Developer/Analyst

VBA Developer/Analyst

ID 
2017-1384
# of Openings 
1
Job Locations 
US-PA-Philadelphia
Posted Date 
11/29/2017
Category 
..

More information about this job

Overview

SoluStaff is actively recruiting a full-time VBA Developer/Analyst for a client based in Philadelphia. This position will support a Database system, which runs on a SQL Server 2008 backend with an Access 2016 user interface. Primarily used to track internal workflows and permit compliance data, the database represents a core critical function of our customer’s business. The VBA Developer/Analyst will be responsible for ensuring continued system functionality through routine maintenance and updates in order to support the needs of several user groups. The VBA Developer/Analyst will facilitate the implementation of any necessary modifications or upgrades to the database that may be required to guarantee the successful launch of an enterprise data warehouse/business intelligence system.

The VBA Developer/Analyst will also act as a subject matter expert to support the redevelopment of the system as a web-based application. This will include requirements gathering, competitive bidding and evaluation and the contracting of resources to develop and implement the new system. In this role, the VBA Developer/Analyst will provide technical expertise on the current system and attend meetings as-needed with the project team.

Responsibilities

  • Maintain and update the existing Microsoft Access UI and SQL Server 2008 database
    • Developing system modifications and upgrades
    • Modifying and maintaining ODBC connections
    • Provide detailed documentation of upgrades and modifications
  • Troubleshoot and correct program and user issues
  • Identifying and packaging fixes
  • User support
  • Meeting attendance
  • Implementation documentation
  • Testing
  • General technical support and guidance
  • Updates to projects, meetings, and status export routines
  • Development and integration of expedited review tracking
  • Integrate numeric values into summary views
  • Development and integration of an enforcement tracking stage
  • Update migration routines
  • Expand standardized reporting queries
  • Establish and implement user groups
  • Ensure ongoing compatibility with RamSys DW/BI solution
  • Monthly progress reports
  • Technical documentation

Qualifications

  • 3 -5  years of SQL / ETL and/or database administration, including of data architecture management
  • A Bachelors Degree in Information Technology, Computer Science, Mathematics or equivalent is required
  • SQL Server 2008
  • Extensive Advanced Experience in Microsoft Access 2010
  • Microsoft Visual Basic
  • ODBC Connections
  • Active Directory