Title: AASHTOWare Reports Analyst
Location: Remote
Length: Long term
Restriction: W2 or C2C

Description:

Interview Type: Webcam Interview *** Very long term project initial PO for 1 year, expect to go for 4+ years *** *** Remote ***

Short Description:

AASHTOWare Project Active Reports Developer and Data Analytics Technical Specialist

Job Description:

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 web based 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 post bid 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 NCDIT Transportation 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 in order for the LCS IT team to maintain the current level of support for these applications.

Required Skills:

General knowledge of certified payroll processes in a construction contractor or sub contractor context 3 Years
General knowledge of Transportation construction, bidding/letting, certified payroll, & Disadvantaged Business Enterprise (DBE) reports 3 Years
General knowledge of certified payroll processes in a construction contractor or sub contractor context 3 Years
General knowledge of software development methodology, enterprise systems and industry or professional standards 3 Years
Experience with writing technical documentation 3 Years
Excellent written and verbal communications easily understands and is easily understood by others in highly collaborative, fast paced teams 3 Years
Experience with using SQL for querying databases, analyzing data and exporting/reporting out results 3 Years
Experience using XML, especially in the context of modifying application user interfaces and editing exported system files 3 Years
Experience with supporting product changes/change management 3 Years
Experience with identifying, documenting, troubleshooting, validating, and resolving customer and system issues 3 Years
Experience reviewing/analyzing software technical specifications and identifying relevant support information 3 Years
Experience creating data visualizations using MS Power BI DAX, including experience using DAX programming language to clean & prep data 2 Years
Software Experience using Azure DevOps as part of an Agile team 3 Years
Experience with collaborative prototyping & demo for new solutions 3 Years
Experience writing training documentation for end users 2 Years
Experience with process engineering, and creating supporting visualizations 3 Years
Experience with MS Teams environment 2 Years
High Desired Skills:

General knowledge of IT technologies, architecture, infrastructure, and data center operations 3 Years
General knowledge of market analysis data analysis techniques and conventions 3 Years

Desired Skills:

Experience with designing application test suites, especially using Azure DevOps 3 Years

Nice to have:

Experience with project coordination 2 Years
Experience with large systems that require integration with other enterprise systems (legacy systems, SharePoint, SAP, etc.) 2 Years