Connecting...

MS Access Database Systems Analyst

Location:

New South Wales

Work type:

Contract

Classification:

Information & Communication Technology

Salary:

Competitive

Job reference:

JO-1708-511952

Start date:

2017-08-11

Contact email:

pinki.verma@talentinternational.com

Advertiser:

Pinki Verma

 
  • Government Client
  • 3 months contract with a view to extend
  • Sydney CBD Location
  • Competitive Daily Rates
  • Immediate Start!!!
  
Talent International is working in partnership with a large government organisation to assist in sourcing the "MS Access Database Systems Analyst' to develop, assess and analyse business and system database needs, exploring alternative options and provide consulting services to management. Prepares high level and detailed technical specifications, ERD and work flow diagrams. Works collaboratively with the management team to determine best mix of development, interfacing applications and solutions to meet business requirements and project objectives. Typical project scope is small to large database development or maintenance database projects. Emphasis is on Microsoft Access Database experience, VBA/SQL knowledge and incorporating systems solutions that will benefit the business.
 
Skills and Competencies:
  • Microsoft (MS) Access 2007 or higher developer experience
  • Experienced in MS Excel and spreadsheet development and analysis.
  • Relational database design (unique identifiers, relational table creation)
  • Advanced Form creation for adds, edits, deletions, Advanced reporting knowledge.
  • Ability to create complicated IF statements and calculated fields
  • Knowledge of using multiple functions within fields such as datepart, min, max, avg,
  • Ability to create macros, create ERD diagrams & Work Flow diagrams
  • Knowledge of importing and linking various sources of data such as Excel and Access.
  • SQL knowledge to create Select, Update, Delete, Union, Append queries. Outer joins, Equal joins
  • Experience writing procedures, manipulating data within Excel or other files to the correct format for Access to read. Such as comma delimited files.
 
 
Key Accountabilities:
  • Technical skills and expertise to assess, research and analyze business and system needs
  • Organized with good time management skills - Business acumen
  • Strategic influencing - Can deal with ambiguity and manage change effectively
  • Comfortable in high pressure, deadline-oriented environment
  • Ability to adapt quickly; function independently
  • Creative thinker, breakthrough, innovative, out of the box thinker
  • Team player, cooperative with good interpersonal skills.
 
 
If you would be interested in this role please submit your application in Word format only by clicking the "APPLY NOW" button below or pinki.verma@talentinternational.com.
 
 

Share this job:

help your friends find their dream job: