Apply on Employer Site

Charleston County School District · 19 hours ago

Data Architect

Charleston, SC

Full-time

Onsite

Mid Level

3+ years exp

Charleston County School District is seeking a Data Architect to monitor, retrieve, and analyze student data for various reports and reporting requirements. The role involves managing data imports and exports, maintaining data quality, and developing web applications for data collection and reporting purposes.

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; and

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

Qualification

SQL ServerData analysisCold FusionStatistical Analysis SystemK-12 education practicesAnalytical skillsCommunication skillsProblem-solvingAttention to detailOrganizational skills

Required

Bachelors Degree

3 + years of management experience/training

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 Servicer

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

Strong verbal and written communication skills

Proven analytical and problem-solving abilities

Keen attention to detail

Organizational skills and the ability to multi-task

Benefits

Dental insurance

Health insurance

Retirement plan

Vision insurance

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)