User avatar
Negotiable
Contract Remote
Anywhere
13 days ago
Job Description Job Description ***** Direct Client Requirement***** Title Cloud SQLServer Data Analyst Location Salem, OR Rate DOE /If your experience and skills match call us immediately for submission Duration 7 Months Interview Type Skype or Phone Job Type C2C, C2H, W2 Experience 8 Years Job Description Computer systems specialists provide technical guidance for the development and troubleshooting of computer systems. They identify system data, hardware or software components required to meet user needs. They also develop guidelines for implementing secure systems to customers or installation teams. May require a bachelor's degree in a related area with at least at least 6 years or equivalent experience in the field or in a related area. The purpose of this request is to procure Analyst services for ODOT Technical Services Branch (Tech and Data Unit - TDU). The primary tasks the contractor shall perform are as follows: Provide consultations and solution recommendations for ODOT’s asset management software, data store and field-oriented GIS tool Create as-is and to-be process documentation Use a variety of information gathering techniques (e.g., interviews, facilitation, diagrams) to gather, define and document complex business data requirements from Business teams Identify areas for improvement in current systems Collaborate with business partners and stakeholders in the development and improvement of business processes in relation to asset management Conduct, document and present impact analyses Create and manage requirements traceability matrix Create and support the creation of functional specifications for data models, customizations, extracts, and reports Create implementation documentation and support the implementation process Develop design changes in the asset management software and development and testing environments and collaborate integration into the existing business production environment with the rest of the team Plan and support data cleanup activities Prepare test data, implement and support test activities including the creation of test plans and test cases; test enhancements and track results Create and implement regression test plan and test cases Plan and support user acceptance testing Coordinate with other team members to reach project milestones and deadlines Engage and build strong working relationships with IT, Business and Sourcing partners Create training materials for Business and technical audiences, including User Guide, Job Aids, PowerPoint presentations and training data Conduct in-person and remote training (for Business and technical audiences) Troubleshoot issues, determine causes and provide options for fixing the issues Experience with asset management software (specifically, Bentley’s TransInfo software) Understand Transportation data and Linear Reference System/Measurement (LRM) Business analysis skills Strong communication skills (verbal and written) Development and systems/data analyst skills for release development tasks Testing/analysis skills for the release development tasks and release acceptance testing tasks Ability to produce business analysis deliverables: business process and workflow diagrams, system requirements, design specifications, and training and testing materials to facilitate implementation activities Ability to complete work without direct supervision Proficient in soft skills with an emphasis on customer relations, time-management, critical thinking and organizational skills Intermediate level skills in: SharePoint, MS Office, Microsoft SQL Server Management Studio, Oracle SQL Developer, Visual Studio, SQL Server Reporting Services, Azure DevOps Type Category Qualification Competency Skills Database Microsoft SQL Server Proficient (4-6 Years) Skills Others Azure DevOps Proficient (4-6 Years) Skills Others Oracle SQL Developer Proficient (4-6 Years) Skills Others Sharepoint Proficient (4-6 Years) Skills Others SQL Server Reporting Services Proficient (4-6 Years) Skills Tools MicrosoftOffice Proficient (4-6 Years) Skills Tools VisualStudio Proficient (4-6 Years)
Negotiable