Job ID: NC-742649 (97790730)
Remote AASHTOWare Project (AWP) Data Analyst with Labor Data Analytics, DBE reporting, Transportation construction, payroll, SQL, XML, Power BI DAX, Azure DevOps, Agile experience
Location: Raleigh, NC (NCDOT)
Duration: 12 Months
Position: 1(2)
Skills:
General knowledge of certified payroll processes in a construction contractor or sub-contractor context Required 3 Years
General knowledge of Transportation construction, bidding/letting, certified payroll, & Disadvantaged Business Enterprise (DBE) reports Required 3 Years
General knowledge of certified payroll processes in a construction contractor or sub-contractor context Required 3 Years
General knowledge of software development methodology, enterprise systems and industry or professional standards Required 3 Years
Experience with writing technical documentation Required 3 Years
Excellent written and verbal communications – easily understands and is easily understood by others in highly collaborative, fast-paced teams Required 3 Years
Experience with using SQL for querying databases, analyzing data and exporting/reporting out results Required 3 Years
Experience using XML, especially in the context of modifying application user interfaces and editing exported system files Required 3 Years
Experience with supporting product changes/change management Required 3 Years
Experience with identifying, documenting, troubleshooting, validating, and resolving customer and system issues Required 3 Years
Experience reviewing/analyzing software technical specifications and identifying relevant support information Required 3 Years
Experience creating data visualizations using MS Power BI DAX, including experience using DAX programming language to clean & prep data Required 2 Years
Software Experience using Azure DevOps as part of an Agile team Required 3 Years
Experience with collaborative prototyping & demo for new solutions Required 3 Years
Experience writing training documentation for end users Required 2 Years
Experience with process engineering, and creating supporting visualizations Required 3 Years
Experience with MS Teams environment Required 2 Years
General knowledge of IT technologies, architecture, infrastructure, and data center operations Highly desired 3 Years
General knowledge of market analysis data analysis techniques and conventions Highly desired 3 Years
Experience with designing application test suites, especially using Azure DevOps Desired 3 Years
Experience with project coordination Nice to have 2 Years
Experience with large systems that require integration with other enterprise systems (legacy systems, SharePoint, SAP, etc.) Nice to have 2 Years
Description:
This position will be serving as the Technical Specialist/Expert SME for AASHTOWare Project’s 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.