SoluStaff

  • VBA Developer/Analyst

    Job Locations US-PA-Philadelphia
    Posted Date 11 months ago(11/29/2017 12:20 PM)
    ID
    2017-1384
    # of Openings
    1
  • 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

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed