Chesterfield County's Department of Utilities is seeking a Principal Automation Analyst to analyze the department's 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 put 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 and modify existing SSRS reports. Provide work direction to the systems team and act as the team lead in the automation coordinators absence. Train and mentor other analysts and assist in the research and implementation of best practices for the department's database environment including maintenance issues, operation requirements, disaster recovery, and security. 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.
Principal Automation Analyst
Hiring Range: $64,456 - $98,664
Deadline: 11:59 p.m. September 20, 2020
Successful candidate will possess a bachelor's degree in information systems, computer science, or similar field with a minimum of five years of experience in computer field with experience geared toward application development in a relational database environment (seven years of experience preferred); or an equivalent combination of training and experience with an emphasis on technical and business analysis. 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, as well as, developing, testing, and maintaining reporting processes (SQL Server Reporting Services/SSRS). Ability to handle common database procedures such as an upgrade, backup, recovery, migration, etc., with experience in creating SQL Server database objects such as tables, views, procedures, functions, and triggers. Must have experience with Microsoft operating systems, servers and their environments, 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; excellent oral and written communication skills and ability to work independently with limited supervision. Ability to identify, research and recommend equipment and/or software improvements and upgrades.
Pre-employment drug testing, criminal background check and education/degree verification required.
PLEASE NOTE: Must maintain personal mobile technology as a condition of employment.
A Chesterfield County application is required and must be submitted online by deadline.
s to view instructions and to complete and submit an application. (804) 748-1551.
An Equal Opportunity Employer Committed to Workforce Diversity