Developer MS Excel Spreadsheet Relational Database VBA Reporting SQL Knowledge Work   Requirement id 132685 Job title Architect Job location in Madison, WI Skills required MS Access, Developer, MS Excel, Spreadsheet Relational Database VBA Repo Open Date 22-Mar-2022 Close Date Job type Contract Duration 24 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: MS Access, Developer, MS Excel, Spreadsheet Relational Database VBA Repo Start Date :04/11/2022 End Date :At least 2 Years from projected start date Submission Deadline: :3/24 at 4PM CST Client Info: DOC Note : * Interview Process: MS Teams-Video Description: Description of Duties: 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 2013and 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: 132685 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), MS Access job openings in Madison, WI Jobs List Application Architect I - 91745 - SP Create date: 01-Sep-2021 start date:09/20/2021 End date:At least 2 Years from projected start date submission deadline: 9/9 at 4PM client info : DOC Note: * Interview Process: MS Teams-Video * Working location: hybrid, Needs to reside in Wisconsin and in the Madison area. .... (This job is for - MS Excel Spreadsheet Jobs in WI Madison Architect - (in Madison, WI)) .NET Web Developer II - 91104 - SP Create date: 18-Aug-2021 start date:8/30/2021 End date: At least 1 Years from projected start date submission deadline:Aug 20 2021 at 4:00PM CST. client info : ETF Note: * Interview Process: 1 via Microsoft Teams * Duration: 1 year likely to extend. * Hybrid position Candidates should be local/live in.... (This job is for - SQL Jobs in WI Madison Developer - (in Madison, WI))    MS Access job openings in other states Jobs List Administrative Services Assistant -62323 Create date: 04-Mar-2024 start date : 03/11/2024 End date :07/11/2024 submission deadline :03/08/2024 client info : TN TDCI Note: * Position Location: Hybrid Description : 73162 Job Code 73162 Summary: under general supervision, is re.... (This job is for - job Jobs in TN Nashville Administrator - (in Nashville, TN)) Programmer/Analyst 3 - 62109 Create date: 19-Jan-2024 Start date :02/01/2024 End Date : 01/31/2025 Submission deadline : 01/23/2024 Client Info :TN AG Position Location : Hybrid Description : ------------------------------------------------------ 75523 Job Code 75523 Analyzes functional business requirements and design specifications .... (This job is for - UX Jobs in TN Nashville Analyst - (in Nashville, TN)) Business Analyst Jr - 61902 Create date: 10-Jan-2024 start date : 01/08/2024 End date :12/31/2024 submission deadline :01/19/2024 client info : CT DPH Note: * Position Location: Hybrid Description : Job Code 75601 The DPH Infectious Disease Section Inf.... (This job is for - Business Analyst Jobs in CT Hartford Analyst - (in Hartford, CT)) Program Monitor/Auditor - 61904 Create date: 05-Dec-2023 Start date : 12/29/2023 End date :07/31/2024 Submission deadline :12/18/2023 Client info : TN EC Note: * Position Location: Hybrid Description : As a member of the Tennessee State Parks Digital Marketing team, you will pl.... (This job is for - job Jobs in TN Nashville Consultant - (in Nashville, TN)) DATABASE ADMINISTRATOR - 10604-1 Create date: 20-Oct-2022 start date: 11/7/2022 End date: UP TO 6 MONTHS from the start date submission deadline: 10/27/2022 client info : SC Department of Childrens Advocacy Description: DAILY DUTIES / RESPONSIBILITIES: MAINTAIN AND ARCHIVE ACCESS DATABASE IN AD.... (This job is for - job Jobs in SC COLUMBIA Administrator - (in Columbia, SC))    MS Access job openings in WI Jobs List Cognos Reporting Specialist - 26410 Create date: 03-Aug-2017 Client Info : Case New Holland Job Description : Job Title: Cognos Reporting Specialist Start Date: ASAP Terms Of Contract: 6-12 months Job Description: This position will be responsible for creating Dashboards, Reports and Scorecards for the North American.... (This job is for - job Jobs in WI Racine Specialist - (in RACINE, WI)) (Architect: MS Access, Developer, MS Excel, Spreadsheet Relational Database VBA Repo in Madison, WI)

Featured Jobs Stakeholders Project Consultant (Jobs in Hartford, Connecticut) Cybersecurity SIEM Linux Analyst (Jobs in Jackson, Mississippi) VLAN Cisco Routers Routing Consultant (Jobs in Fairfax, Virginia) Project Consultant (Jobs in Lincoln, Nebraska) JavaScript Spring Analyst (Jobs in Richmond, Virginia) Strong Analyst (Jobs in North Chesterfield, Virginia) QA Testing Azure Analyst (Jobs in Lansing, Michigan) Quality Assurance UAT Analyst (Jobs in Madison, Wisconsin) Wireframes Analyst (Jobs in Richmond, Virginia) Change Consultant (Jobs in Raleigh, North Carolina)