TEKsystems · 4 hours ago
Data Architect
Charleston, SC
Full-time
Onsite
Mid Level
$72K/yr - $137K/yr
3+ years expTEKsystems is a leading provider of business and technology services, and they are seeking a Data Architect to monitor, retrieve, and analyze student data to support district reporting requirements and data-driven decision-making. This role involves designing and maintaining data systems, ensuring data quality, and developing applications and reports to meet various needs.
Information Technology
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 the organization 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
Required
Bachelor's degree
3+ years of data management experience
3+ years working with statistical applications (e.g., SAS) or similar tools
Experience in software development using ColdFusion and SQL Server
Knowledge of K–12 education business practices and data-driven decision-making models
Preferred
Master's degree
Benefits
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Company
TEKsystems
At TEKsystems, they understand people. Every year they deploy over 80,000 IT professionals at 6,000 client sites across North America,
10001+ employees
H1B Sponsorship
TEKsystems 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
2025 (46)
2024 (52)
2023 (33)
2022 (22)
2021 (36)
2020 (53)
Funding
Current Stage
Late StageLeadership Team
Ryan Skains
Vice President, TEKsystems Global Services
Recent News
2025-11-19
2025-10-29
Company data provided by crunchbase