VBA MS Excel Spreadsheet Relational Database Time Management Skills Architect (J   Requirement id 120265 Job title Architect Job location in Madison, WI Skills required Microsoft Access Database, VBA, MS Access 2010/2013, MS Excel Spreadsheet Relational Database Open Date 08-Nov-2021 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Microsoft Access Database, VBA, MS Access 2010/2013, MS Excel Spreadsheet Relational Database start date:11/29/2021 End date:At least 2 Years from projected start date submission deadline:11/16/2021 4:00:00 PM client info : DOC Note: * Interview Process: MS Teams-Video * Working location: hybrid, Needs to reside in Wisconsin and in the Madison area. The job is 100% remote, but may have to travel to the office or a DOC institution occasionally (1 – 2 times per quarter). Description: Microsoft Access Database Systems Analyst to develop, assess and analyze business and system database needs, exploring alternative options and provide consulting services to management. Can prepare 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. Additional Knowledge in SharePoint a plus. Skills and Competencies: • 3 years Microsoft (MS) Access 2013 and 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. 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.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 120265 while calling.   Other jobs in WI: De Pere (2), Green Bay (8), Kenosha (2), Madidson (1), Madison (36), Menomonee Falls (19), Milwaukee (59), Sun Prarie (1), Unknown (2), Waukesha (2),    Microsoft Access Database job openings in other states Jobs List Reporting Analyst - J-11-026-485 Create date: 06-Jul-2015 NOTE : START DATE : 07/21/2015 END DATE : 12/20/2015 SUBMISSION DEADLINE : 07/10/2015 CLIENT INFO : COMSYS DESCRIPTION : Reporting Analyst Local Resources Only: Austin, TX The Reporting Analyst is responsible for executing repeatable core business proc.... (This job is for - VBA Jobs in TX AUSTIN Analyst - (in Austin, TX)) Database Developer - TSS-001594 Create date: 18-Jun-2012 [**Note : Closing Date: 6/25/2012 5:00 PM**] [**Note : No of hours - 240 hrs only**] Description : Client is seeking to fill a short term (approx. 240 hrs) contractor position. The selected candidate will update and improve the existing Property Tax Distribution Access Database system. The application?s basic funct.... (This job is for - job Jobs in NC Raleigh Developer - (in Raleigh, NC))     (Architect: Microsoft Access Database, VBA, MS Access 2010/2013, MS Excel Spreadsheet Relational Database in Madison, WI)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)