Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Cloud SQLServer Data Analyst (193 views)

Salem, OR
December 27, 2021

***** 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


  • Microsoft SQL Server – Proficient (4-6 Years)
  • Azure DevOps – Proficient (4-6 Years)
  • Oracle SQL Developer – Proficient (4-6 Years)
  • Sharepoint – Proficient (4-6 Years)
  • SQL Server Reporting Services – Proficient (4-6 Years)
  • Microsoft office – Proficient (4-6 Years)
  • VisualStudio – Proficient (4-6 Years)

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus*******




PH: 470-410-5283 EX 110 /470-780-2413 EX – 104

Apply here or please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true

Twitter: https://twitter.com/SohanITInc1

Position Keywords: MS PowerPoint,MS Share Point,MS Office,SQL Server Management Studio,Oracle SQL Developer,MS Visual Studio,SSRS,DevOps,Azure,SQL Server,MicrosoftOffice

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 7 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 3770

Don't have time now?
Get a reminder in your inbox