Senior Automation Analyst
Hiring Range: $48,169 - $71,017
Deadline: 5pm May 31, 2018
Chesterfield County is seeking a Senior Automation Analyst to analyze the Department of Utilities' information needs and make recommendations for improvements. Develop, interpret and support relational database solutions in a Microsoft SQL Server environment that address critical business functions or needs for the department; identify and troubleshoot code-related issues. Extract data, present data, and enter data into spreadsheets. Create, modify, and test various SQL queries, stored procedures, and views for obtaining data. Create consistent and accurate technical documentation of implemented applications, databases, and systems. Create new and modify existing SSRS reports. Assist other analysts and the Automation Coordinator in tech research and implementation of best practices for the department's database environment including maintenance issues, operation requirements, disaster recovery, and security. Serve as back-up to the Utilities Database Administrator which requires routine exchange of all project requirements. Evaluate and propose the effectiveness of alternative approaches to user needs; assist in the training of department personnel in the utilization of computer systems and software. Perform other work as required.
Successful candidate will possess a bachelor's degree in information systems or an equivalent combination of training and experience with an emphasis on analysis, from a technical aspect, as well as a business/process point of view; minimum of five years of experience in computer field with experience geared toward application development in a relational database environment preferred. Transact SQL (T-SQL) experience in both creating and maintaining queries, views, and stored procedures in a multi-database environment required. Experience in relational database design, data analysis, and performance tuning. Experience in developing, testing and maintaining reporting processes (SSRS); ability to handle common database objects such as tables, views, procedures, functions, and triggers. Must have experience with operating system and their environment, as well as higher level database systems and structures. Ability to develop and organize high-quality technical system documentation. Detail oriented with ability to manage multiple projects with excellent oral and written communication skills. Ability to identify, research and recommend equipment and/or software improvements and upgrades. Good driving record required. Must not reflect a total accumulation of six or more demerit points within the twenty-four months preceding the anticipated hire date, or one major violation of six demerit points within the preceding thirty-six months.
Pre-employment drug testing, FBI criminal background check and education /degree verification required. A Chesterfield County application is required and must be submitted online by deadline. Visit careers.chesterfield.gov
to view instructions and to complete and submit an application. (804) 748-1551.
About this company
Chesterfield County Human Resources provides complete Human Resource services for approximately 3800 full time employees not including schools.
Location/Region: Chesterfield, VA (US - 23832)