Jobs on Good Gear Guide.

IT - OTHER

Database Systems Analyst - Microsoft Access

Temporary
NSW, Sydney
Posted on 08.10.2017
450.00 -> 700.00 per day

Government Opoortunity
Great Work Envrionment & Project
Competitve Pay Rates

Our Client, NSW Government is seeking to appoint a Database Systems Analyst with experience in Microsoft Access on an initial three month contract basis, with opportunities for extensions possible based on performance and business requirements.

This Microsoft Access Database Systems Analyst role will assess and analyse business and system Database needs, involving exploring alternative options and provide consulting services to management.

The successful applicant will prepare high level and detailed technical specification, ERD and work flow diagrams and work collaboratively with the management team to determine the best mix of development, interfacing applications and solutions to meet business and project requirements.

Typical project scope is small to large database development or maintenance database projects.

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



    Selection Criteria:


    • 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)



    • Understand and use data types



    • VBA knowledge and application



    • 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



    • 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



    • Ability to create emails and attach reports to them



    • Ability to create ERD diagrams & Work Flow diagrams



    • Experience writing procedures



    • Experience manipulating data within Excel or other files to the correct format for Access to read. Such as comma delimited files.



How to Apply?

Click on the link below

Click here for more information about this job

Jobs you may also be interested in ...

Father’s Day Gift Guide

Most Popular Reviews

Join the newsletter!

Error: Please check your email address.

Latest Articles

Resources

PCW Evaluation Team

David Coyle

Brother PocketJet PJ-773 A4 Portable Thermal Printer

I rate the printer as a 5 out of 5 stars as it has been able to fit seamlessly into my busy and mobile lifestyle.

Kurt Hegetschweiler

Brother PocketJet PJ-773 A4 Portable Thermal Printer

It’s perfect for mobile workers. Just take it out — it’s small enough to sit anywhere — turn it on, load a sheet of paper, and start printing.

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?