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

Sr. Data Architect (248 views)

Salem, OR
December 9, 2021

***** Direct Client Requirement*****

Title                                    : Sr. Data Architect

Location                             : Salem, OR

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

Duration                             : 12 Months

Interview Type                   : Skype or Phone

Job Type                            : C2C, C2H, W2

Experience                        : 9 Years

Job Description:

  • Designs and builds relational databases for data storage or processing. Develops strategies for warehouse implementation, data acquisition, and archive recovery. Cleans and maintains the database by removing and deleting old data. May evaluate new data sources for adherence to the organization’s quality standards and ease of integration. Requires a bachelor’s degree in area of specialty and at least 9 years or equivalent experience in the field or in a related area. Familiar with a variety of the field’s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. May lead and direct the work of Contractor staff. A wide degree of creativity and latitude is expected.
  • The purpose of this request is to procure Applications Senior Data Architect services for ODOT Transportation Applications Development (TAD) within the Information Systems Branch (ISB).
  • TDS is currently tasked with ensuring the Americans With Disabilities Act (ADA) related assets and highway network within TransInfo can be captured, managed and reported on, supporting ODOT’s compliance with a current legal settlement. Additionally, TDS is responsible for enhancing existing systems to allow the management of ODOT’s highway asset data and data in support of existing and new federal Map-21 Act and FAST Act requirements.
  • To successfully complete these efforts, ODOT has a significant need for services, including the review, analysis and design for new and modified assets and reporting. Services may include requirements, architecture, design specifications, testing documentation, and implementation materials for these and other related ODOT assets in support of TDS asset management priorities.

 The scope of services under this WOC is as follows:

  • Provide consultations and solution recommendation for ODOT’s Bentley Assetwise (TransInfo) implementation or data models
  • Understand Transportation data and Linear Reference System/Measurement (LRM).
  • Identify, define and determine the requirements for TransInfo network and asset data architecture.
  • Conduct and support data cleanup activities
  • Publish and/or present design reports
  • Identifying areas for improvement in current systems
  • Coordinating with other team members to reach project milestones and deadlines
  • Provide consultation and data analysis to support data integrity and reporting
  • Create and support the creation of functional specifications for interfaces data models, extracts and reports
  • Prepare test data, write queries, and support testing activities including creating test plans and test cases; test the new system
  • Contribute to data integration activities
  • Create implementation documentation and support the implementation process.
  • Understand the business requirements and translate them into Conceptual, Logical and Physical models
  • Uses a variety of information gathering techniques (e.g., interviews, facilitation, diagrams) to gather complex business data requirements from Business teams
  • Coordinate data models, data dictionaries, and other database documentation across multiple applications
  • Leads design reviews of data deliverables such as models, data flows, and data quality assessments
  • Perform data analysis, discovery, profiling and identify the cause of data issues and work with the broader team to resolve
  • Develop a solid understanding of the various source data sets and assist in laying out the overall data design solutions
  • Represent the organization to engage with internal & external stakeholders to develop optimal data strategy
  • Effectively leverage various data technologies in addressing specific business problems and integrate into overall data architecture
  • Engage and build strong working relationships with IT, Business and Sourcing partners

Data Modeling is mandatory

  • Ability to communicate clearly verbally and in writing.
  • Demonstrated capability to interact with customers, clearly understand customer needs and document those needs.
  • Understand System Development Lifecycle methodology. Specifically Requirements Management, Data Management, Functional Specification writing, all forms of testing procedures, and end user training delivery.
  • Has experience with requirements management and perform analysis within source code if needed.
  • Ability to write technical documentation, but also documentation for executive level.
  • Write and troubleshoot SQL in both Oracle and SQL Server environments


  • Data Analysis – Expert (10+ Years)
  • Oracle – Advanced (7-9 Years)
  • SQL – Advanced (7-9 Years)
  • Familiarity with DOT Linear Reference Systems – Advanced (7-9 Years)
  • Business Process Analysis – Advanced (7-9 Years)
  • Familiarity with Bentley Software Products – Advanced (7-9 Years)
  • Communication skills both verbal and written – Advanced (7-9 Years)
  • Team work – Advanced (7-9 Years)
  • MicrosoftOffice – Advanced (7-9 Years)

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




PH: 470-480-2407 EX 101

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: SQL,Oracle,SQL Server,DOT,Microsoft Office,Warehouse,Data Analysis,Data Integrity,Data Flow,Data Architecture

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

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 3731

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