What are the responsibilities and job description for the Coordinator - Business Information Systems position at Clayton County Public Schools?
Applicants: Please ensure that you upload all necessary documents and include all relevant information related to the position you are applying for. Please make sure that you are reading the job description in its entirety to align your documents and relevant information with the requirements.
POSITION SUMMARY:
The Coordinator of Business Information Systems plans directs and coordinates daily activities of the Department of Technology’s Database Administrators, provides leadership and support for District database environment including oversight, development, organization, assessment and implementation of data warehouse. Ensures the operational efficacy through monitoring, tuning and planning for future expansion data requirements and data modeling with the use of business intelligence tools. Review workflow charts developed by business analyst and programmers. Develop methods for integrating different products, including customization. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Assist in troubleshooting operational and development errors regarding data to ensures user experience is most productive. This position reports to the Director of Enterprise Information Systems.
KEY RESPONSIBILITIES:
Designs and documents database architecture using logical and physical data modeling tools and utilities. Creates, tests, and executes data management languages. Analyzes and sustains capacity and performance requirements. Monitors systems and platforms; oversees backup, clustering, mirroring, replication and failover. Trains and develops technical staff to better utilize on-line processing databases environment. Designs and executes the test scripts and test scenarios.
Performs daily system monitoring and back-up operations, verifies the integrity and availability of all hardware, server resources, systems and key processes; reviews system and application log. Collaborates with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs. Acts as a liaison between the business units, technology teams and support teams.
Develops, designs, and maintains Extraction Transformation Loading (ETL) solutions to seamlessly integrate District infrastructure. Develops, designs, delivers, and maintains enterprise-reporting methods utilizing District Data Warehouse. Develops, designs, and maintains database solutions using SQL, functions, procedures, views and other RDBMS techniques.
Investigates, documents, and recommends new solutions to improve the District Technology. Assists system administrators securing access, with application, data loads; storage and performance strategies and implementations.
All other duties, as assigned and required, in order to perform the above services.
KEY JOB REQUIREMENTS:
One of the following must be met with equivalent work experience:
- High School diploma or GED
- Associate’s or Technical Degree in related field
- Bachelor’s Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology, or related field
Experience as a Database Administrator using Microsoft SQL Server in a clustered environment required for the following number of years:
- Minimum of five (5) years with Bachelor’s degree
- Minimum of ten (10) years with Associate’s or Technical degree
- Minimum of fifteen (15) years with High School diploma
Strong understanding of database structures, theories, principles and visualization; Microsoft Power BI.
Requires district coordination; makes decisions and recommendations, which affect District employees, students, parents and constituents.
Microsoft Certified Solution Developer (MCSD) or Microsoft Certified Applications Developer (MCAD) preferred.
Analytical: supervisor is available to review established broad objectives; independent judgment is required to review and approve major recommendations.
Requires excellent interpersonal skills, regular, frequent contact with internal and external personnel of influence and decision-making responsibility to discuss issues of moderate importance; requires occasional contact with officials at higher levels.
Responsible for multiple functions in developing solutions with high-level accountability for effective operation and results.
Normal office setting.
Moderate travel across the district with occasional travel for off-site training.
Light duty - On most occasions sitting at a desk or table; intermittently sitting, standing, or stooping.
Light lifting or carrying; twenty (20) lbs. or less.
NOTE: This is a Grade 30, 225-day position that pays for experience up to a Step 8.
Salary : $78,571 - $96,631
