Data Analysis BI Dash Board Analyst (Jobs in Tacoma, WA)   Requirement id 93970 Job title Analyst Job location in Tacoma, WA Skills required MS SQL Database, Drupal Website Development, Microsoft SQL Server, Data Analysis BI Dash Board Open Date 18-Jun-2019 Close Date Job type Not specified Duration 8 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: MS SQL Database, Drupal Website Development, Microsoft SQL Server, Data Analysis BI Dash Board Note: Email Submission Note: data analyst/architect needed. Submission Deadline: 7/12/2019 12 PM PT Start Date: 8/15/2019 End Date: 5/31/2020 Client: Department of Enterprise Services (DES) Description: Background The NWSA desires to make real-time and historic truck turn times and queue times available on our public nwseaportalliance.com website, including mobile/responsive designs, by the end of 2019 or early 2020. This will assist trucking companies in scheduling their trips to the Port and will identify opportunities for the NWSA and terminal operators to improve their operations. The NWSA currently has Radio Frequency Identification (RFID) sensors that detect when trucks pass receiver locations in six international terminals. When a truck passes a receiver, an event is logged that captures the receiver ID, time stamp, and truck ID. The NWSA maintains these event logs in a MSSQL database. There are multiple receivers at the entry and exit gates of each international container terminal at the Port of Seattle (North Harbor) and Port of Tacoma (South Harbor). There will soon be additional receivers on the streets, two queue lots (PCT and Lot F) and an additional entrance (East Sitcum) leading to the terminals that will provide data to use in calculating queue times. The data is currently stored in a very raw format in a MSSQL database. Data quality issues such as missing data and duplicate data will need to be handled by the solution that is developed. See Appendix A for data structure and samples. Goals for this Project: • Process the raw RFID data collected into a format that is usable for BI reporting and dashboard development. Quality issues such as missing data and duplicate data exist. Invalid data will need to be cleansed. For example, there could be an in-gate record without a corresponding out-gate record or visa-versa. Or, some records could be duplicated that will need to be discarded or ignored. • Develop BI Dashboards that are shown on internal websites as well as the public (external) nwseaportalliance.com website, including mobile/responsive designs. The Dashboards must include: o Display of truck turn times for North Harbor (Seattle) and South Harbor (Tacoma) international terminals on the NWSA Web site in Q4 2019 using RFID data. Displaying historical average turn times and current (near real-time) turn times for each applicable terminal is required. o Display truck queue times for North and South Harbor international terminals on the NWSA Web site in Q1 2020 using RFID data. Displaying historical average queue times and current (near real-time) turn times for each applicable terminal is required. b. Scope of Work Must-have: • Implement a solution that displays real-time and historic turn and queue times for international terminals on NWSA Web site. • Review and identify issues with the accuracy of the raw data and recommend improvements. • Build rules and logic based on physical locations of each reader along with unique situations per terminal to calculate start and end turn and queue times. • Using the previously developed rules and logic turn the raw RFID data that we are collecting into a format usable for real-time Power BI reporting and dashboards. • Dashboards should be displayed on the NWSAs Drupal-based Web site. • Management interface for the web dashboards so Port staff can be notified about data anomalies, adjust configuration, and enable/disable display of the dashboards. Out of scope: • Individual trip details, authentication and login info for truck drivers • Acquiring new tools for data analysis d. High-Level Requirements Below are the requirements known at this time. More detailed requirements will be gathered as part of the engagement. • Starting Q4 2019 display data on the NWSA Web site that assists truc   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 93970 while calling.   Other jobs in WA: Bellevue (2), Olympia (8), Seattle (18),    MS SQL Database job openings in other states Jobs List Programmer/Analyst III (Senior) - 20230120125750 Create date: 20-Jan-2023 start date:2/13/2023 End date: 10+Months submission deadline:1/27/2023 Note: * Job Site: Remote Description: TECHNICAL SKILLS: Must Have 3+ years experience with C# General database server configuration practices as it relates to MS SQL DB implement.... (This job is for - job Jobs in OH Columbus Analyst - (in Columbus, OH)) AGFC Database Migration Administrator (681149) Create date: 25-Apr-2022 Start Date:05/02/2022 End date:05/31/2023 Submission Date: 4/29/2022 Client Info: 0808 Description: AGFC is going through a major system conversion over the next 12 months. This position will be responsible for supporting the data migration for this project. They would be serving as a data subj.... (This job is for - job Jobs in AR LittleRock Administrator - (in Little Rock, AR)) Senior SQL Server DBA-10312-1 Create date: 17-Mar-2022 Start Date :04/4/2022 Submission Deadline: :03/24/2022 Client Info: Clemson University Note : * Interview Process (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Round 1 – Telephone interview conducted by the Director of Database Services and/or other project sta.... (This job is for - job Jobs in SC Columbia Consultant - (in Columbia, SC)) Doc175467 Application Development Analyst-1 -SP Create date: 02-Sep-2021 Bid URL: http://sourcing.myfloridamarketplace.com/Sourcing/Main/ad/webjumper?passwordadapter=SourcingSupplierUser&username=coolsoft1&itemID=hn4ng8.fd&awcharset=UTF-8 Note: One candidate can the vendor submit per position. Contract Exhibit G - Resume Acknowledgement Form must be submitted Submission Deadline: 9/8/2021 5:00.... (This job is for - MS SQL Server Jobs in FL Tallahassee Analyst - (in Tallahassee, FL)) ITSAC 30222CAPPSMule2 Software Developer 2 -SP Create date: 16-Aug-2021 Note: RTR form must be submitted. Note: Total estimated hours per Candidate shall not exceed 2000 hours. Submission Deadline: 8/19/2021 5:00 PM CT Start Date: 9/1/2021 End Date : 8/31/2022 Client: Office of the Attorney General of Texas (OAG) Description: 7 Required Experience progra.... (This job is for - Views Jobs in TX Austin Developer - (in Austin, TX))     (Analyst: MS SQL Database, Drupal Website Development, Microsoft SQL Server, Data Analysis BI Dash Board in Tacoma, WA)

Featured Jobs AWS .NET FRAMEWORK UI CSS Tester (Jobs in Little Rock, Arkansas) Microsoft Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) Written Specialist (Jobs in Salem, Oregon) VLAN Subnets Routing Engineer (Jobs in Staunton, Virginia) Training Specialist (Jobs in Atlanta, Georgia) Adobe Analyst (Jobs in Jackson, Mississippi) MS Office EHR Consultant (Jobs in Richmond, Virginia) Information Manager (Jobs in Madison, Wisconsin) Jira UFT Defect Tester (Jobs in Raleigh, North Carolina)