VBA MS Access Developer Analyst

Our client is currently seeking a VBA MS Access Developer Analyst.
Position Summary: This position is responsible for diagnosing issues with existing reports and developing long term solutions: either by making the existing process to generate the report more stable or migrating the source data into temp SQL tables and building out the downstream reporting. This position will work closely with different department leaders to design, develop and support existing reports in a more robust long term solution.
1. Consulting with internal and external clients to model data solutions.
2. Reverse engineer the current process to build out the report in the VBA program.
3. Develop and maintain the data solution via improved macros or temp tables with dashboard/reporting
4. Develop and maintain the appropriate operational documentation for reports
5. Develop complex reporting information and present results to management and customer.
6. Utilize, update and manage BI tools such as SQL, SSRS, Power BI, Business Analytics
7. Ensure the accuracy, performance and consistency of the data
Knowledge, skills and abilities required:

  • Strong VBA skills with MS Excel and MS Access.

  • Skilled in MS SQL

  • Strong skillset as business analyst. Communicate with internal customers independently to understand requirements

  • Excellent interpersonal skills and ability to work with all levels of personnel individually and within teams. Good communication skills, both verbal and written.

  • Excellent project, organization, and change management skills.

  • Maintain library of model documents, templates, or other reusable knowledge assets.

Judge Group Job Order ID: 565030
Salary: Open
Company Description:

Working at the crossroads of people and transformative technologies, The Judge Group delivers innovative business solutions €“ powered by top talent €“ to help organizations reach their strategic goals and realize opportunities now and in the future.

The Judge Group is a leading professional services firm specializing in technology, talent, and learning solutions. Our services are successfully delivered through a network of more than 35 offices in the United States, Canada, China, and India. The Judge Group serves more than 40 Fortune 100 companies and is responsible for the placement of more than 4,500 professionals annually across a wide range of industries. To learn more, visit www.judge.com.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.