Letting Data Analyst I:Performs moderately complex data analysis in support of the level letting activities risk analysis process in the Design division. Work involves conducting detailed analysis, and interpretation to identify high-risk projects, potential replacement projects, and make recommendations to meet level letting criteria. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Serves as primary coordinator with districts for level letting initiatives changes. Work requires extensive contact with department staff, management, and external governmental agencies and organizations. Works under general supervision, with limited latitude for the use of initiative and independent judgment.Letting Data Analyst II:Performs complex data analysis in support of the level letting activities risk analysis process in the Design division. Work involves conducting detailed analysis, and interpretation to identify high risk projects, potential replacement projects, and make recommendations to meet level letting criteria. Responsible for using standard statistical tools, methods and techniques to translate data into actionable insights using data visualization software. Serves as primary coordinator with districts for level letting initiatives changes. Work requires extensive contact with department staff, management, and external governmental agencies and organizations. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.Essential Duties:Letting Data Analyst I:Designs, develops, and maintains visualizations and reports utilizing data visualization tools and best practices.Interprets results to identify significant differences in data.Develops reports, dashboards and interactive visualizations using different components of Tableau software including Tableau desktop, Tableau Prep, and Tableau server.Prepares and makes presentations.Analyzes reports and dashboards to identify high risk projects and mitigate risk.Monitor dashboards and project information for trends and identify business needs.Monitors and balances letting process schedule challenges for quality, risk mitigation and successful delivery.Develops tools, dashboards, and processes to facilitate the risk mitigation process and competing interests.Coordinates with divisions to confirm proposed replacement projects meet level letting criteria.Communicates and coordinates with internal stakeholders and senior leaders to implement mitigation plans.Plans and coordinates activities associated with the delivery of highly complex business and information analyses, information repositories, and reporting/dashboarding applications.Identifies business process improvement initiatives and makes recommendationsPerforms other job responsibilities as assigned. Letting Data Analyst II:All of the above and:Provides decision makers with options how to level letting; Provides back-up plans for high-risk projects going into letting.Provides training to other staff members on the use of systems and dashboards to improve their efficiency.