Data Architect

Charleston County School District

Charleston County School District (CCSD) is a nationally-accredited school system dedicated to providing equitable and high-quality education for over 50,000 students. As the second-largest school district in South Carolina, CCSD spans 1,300 square miles and includes a unique mix of urban, suburban, and rural schools. The district comprises 87 schools, offering a wide array of programs including STEM, arts, career and technical preparation, international baccalaureate (IB), magnet, Montessori, and charter schools.

CCSD is committed to fostering diverse educational opportunities that meet the needs of its student population.

To monitor, retrieve, and analyze student data for various reports and reporting requirements.

Bachelor's Degree

Three (3)+ years management experience/training;

Three (3)+ years of experience in computer statistical applications (e.g Statistical Analysis System) or other computer software for data analysis and reporting; and

Experience in software development using Cold Fusion and SQL Servicer;
Experience with and knowledge of K-12 education business practices related to data driven decision making models and procedures.

• Manage data imports and exports using SQL Server Integration Services;
• Manage and backup copy of Power School data within SQL Server Management Studio every quarter;
• Create and maintain table indexes;
• Create and modify SQL queries to improve web application performance;
• Build applications that will allow users to interact with date and perform basic functions such as add, update, and delete;
• Assist with maintaining data quality as well as SQL Server to store and retrieve date;
• Assist with collecting and analyzing data for federal and state reporting purposes;
• Advise and train middle and high school on dropout and graduation;
• Review and update graduation rate file, including reviewing documentation for adherence to State guidelines;
• Compile and analyze data for outside vendors for use of their software using SSIS and SQL programming language;
• Compile and validate data as requested by different departments within CCSD as well as board members, grant requests and FOIA request using SSIS and SQL programming language;
• Design and maintain the relational database structure for Data Central web applications;
• Develop and maintain new web applications and SQL Server Report Builder reports for district projects and state data collection/report card data;
• Map and design data extracts from student information system as well as other data sources such as Excel and text files for import into the SQL server data warehouse;
• Design SQL Server Report Builder reports and gather report requirements for internal web application ( Data Central);
• Defines data extractions of student Data from Student information system (Power School) for evaluation reports, annual reports and other special reports; and
• Coordinates data collections and review for Graduation Rate, Dropout Rate, Teacher Attendance, and School Climate Survey, Civil Rights Data Collection.