NCDOT - Technical Specialist- AWP Data Analytics and Active Reports

AASHTOWare Project Active Reports Developer and Data Analytics Technical Specialist

This position will be serving as the Technical Specialist/Expert SME for AASHTOWare Projects ActiveReports tool and Data Analytics module and responsible for defining system specifications that migrate the existing DOT processes and legacy applications to a modern webbased solution. This individual should have a strong general knowledge of application development and architecture principals and will serve as an expert on AWP modules/products. They are responsible for ensuring team comprehension of technical and functional concepts for this individual will support the team Product Managers and document NCDOT use cases specific to any AWP module or Business Use Case that requires reporting or other analytics tools. They will perform this work by developing Use Cases Test Cases Test Scripts UX modifications using XML reporting using SQL using the AWP embedded version of the Grape City development tool in an Agile development team that uses AzureDev/Ops software. This position will be responsible for governance of quality for the reports and Data Analytics tools/queries and dashboards and any associated visualizations as assigned ensuring the highest possible quality outputs and reducing technical debt through adherence to AWP implementation Best Practices and Standards provided by AASHTO and its vendor. This person will provide technical research troubleshooting and support for the development team and DOT Businesses related to their work products and collaborate with the development teams on integrations with other legacy NCDOT applications and systems (SAP/SharePoint etc.) This position will be responsible for meeting with NCDOT leaders to gather intelligence and demonstrate system capabilities and support. This position is responsible for working with other analysts to break down the design into milestones and work items tracking status managing communication and dependencies both to the technical team and to the business customer. This individual will also coordinate test validation and rollout for functional components ensuring customers are informed & trained with sufficient help& training materials. Our preferences are for familiarity and experience with AASHTOWare Project Preconstruction CRL and Data Analytics modules DOT preconstruction letting certified payroll processes and postbid market analysis considerable experience building complex analytics queries and building analytics dashboards business analysis agile development conventions such as SCRUM and general familiarity with Agile development lifecycle in a state level Department of Transportation(DOT). This individual will work directly for the NCDITTransportation Letting and Compliance Systems (LCS)manager and be responsible to the respective team leads for daily work assignments. It is critical this position be filled as soon as possible inorder for theLCS IT team to maintain the current level of support for these applications.

Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceGeneral knowledge of certified payroll processes in a construction contractor or subcontractor contextRequired3YearsGeneral knowledge of Transportation construction bidding/letting certified payroll & Disadvantaged Business Enterprise (DBE) reportsRequired3YearsGeneral knowledge of certified payroll processes in a construction contractor or subcontractor contextRequired3YearsGeneral knowledge of software development methodology enterprise systems and industry or professional standardsRequired3YearsExperience with writing technical documentationRequired3YearsExcellent written and verbal communications easily understands and is easily understood by others in highly collaborative fastpaced teamsRequired3YearsExperience with using SQL for querying databases analyzing data and exporting/reporting out resultsRequired3YearsExperience using XML especially in the context of modifying application user interfaces and editing exported system filesRequired3YearsExperience with supporting product changes/change management Required3YearsExperience with identifying documenting troubleshooting validating and resolving customer and system issuesRequired3YearsExperience reviewing/analyzing software technical specifications and identifying relevant support informationRequired3YearsExperience creating data visualizations using MS Power BI DAX including experience using DAX programming language to clean & prep dataRequired2YearsSoftware Experience using Azure DevOps as part of an Agile teamRequired3YearsExperience with collaborative prototyping & demo for new solutionsRequired3YearsExperience writing training documentation for end usersRequired2YearsExperience with process engineering and creating supporting visualizationsRequired3YearsExperience with MS Teams environmentRequired2YearsGeneral knowledge of IT technologies architecture infrastructure and data center operationsHighly desired3YearsGeneral knowledge of market analysis data analysis techniques and conventionsHighly desired3YearsExperience with designing application test suites especially using Azure DevOpsDesired3YearsExperience with project coordinationNice to have2YearsExperience with large systems that require integration with other enterprise systems (legacy systems SharePoint SAP etc.)Nice to have2Years
Questions
No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirementQuestion2All work must be completed virtually using your own personal internet computer and other equipment to connect to NCDOT virtual environments. Do you accept this requirementQuestion3Please list candidate s email address and city and state of residence. Question4Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.Question5Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirementQuestion6Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirementQuestion7Candidates submitted above the rate of will not be considered. Do you accept this requirement Question8Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirementQuestion9Please confirm you have thoroughly validated and attest to the accuracy of the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS009440. Do you confirm