Apply on Employer Site

Charleston County School District · 2 days ago

Data Architect

Charleston, SC

Full-time

Onsite

Mid Level

3+ years exp

Charleston County School District (CCSD) is a nationally-accredited school system dedicated to providing equitable and high-quality education for over 50,000 students. The Data Architect role involves monitoring, retrieving, and analyzing student data for various reports and reporting requirements, while managing data quality and developing applications for data interaction.

Education Management

H1B Sponsor Likely

Responsibilities

Manage data imports and exports using SQL Server Integration Services

Manage and backup copy of PowerSchool 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 (PowerSchool) for evaluation reports, annual reports and other special reports

Coordinates data collections and review for Graduation Rate, Dropout Rate, Teacher Attendance, and School Climate Survey, Civil Rights Data Collection

Qualification

SQL ServerStatistical Analysis SystemCold FusionData analysisK-12 education practicesData quality managementWeb application developmentData reporting

Required

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

Experience in software development using Cold Fusion and SQL Server

Experience with and knowledge of K-12 education business practices related to data driven decision making models and procedures

Company

Charleston County School District

Glassdoor3.4

CCSD is committed to providing equitable and quality educational opportunities for all of its students.

Charleston, South Carolina, USA

5001-10000 employees

https://www.ccsdschools.com/

H1B Sponsorship

Charleston County School District has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (1)

2020 (1)