Data Architect

Job Purpose/Reason:

This position will monitor, retrieve, and analyze student data for various reports and reporting requirements.

REQUIRED QUALIFICATIONS:

Bachelors Degree

EXPERIENCE & TRAINING:

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

OTHER:

Strong verbal and written communication skills; Proven analytical and problem-solving abilities; Keen attention to detail; organizational skills and the ability multi-task.

PRIMARY POSITION RESPONSIBLITIES :

Primary Functions

• 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.

This is not necessarily an exhaustive list of all responsibilities, skills, duties, requirements, efforts, or working conditions associated with the position. While this description is intended to be an accurate reflection of the current position, management reserves the right to revise the job or to require that other or different tasks be performed when circumstances change (e.g., emergencies, change in personnel, work load, rush jobs, or technological developments).

SECONDARY POSITION RESPONSIBLITIES :

• Performs additional duties as assigned.

PHYSICAL / MENTAL REQUIREMENTS:

Sitting for extended periods of time; Ability to operate a computer keyboard, mouse, and to handle other communication/ computer components; ability to lift up to 50 pounds.

APPLY HERE: https://www.applitrack.com/ccsdschools/onlineapp/default.aspx?Category=Non-certified Administrator

APPLICATION DEADLINE:

• Complete applications will be received until position is filled
• An application is not considered complete until your transcripts are uploaded
• Applications without verification of proper credentials will not be processed.
• Faxed, emailed, or mailed copies will not be accepted.

APPLICATION SCREENING:

• completed applications will be reviewed to determine which candidates meet the minimum requirements as identified on the job description.
• The candidates who meet the minimum requirements will be forwarded to the hiring manager for consideration.
• The hiring manager will review and select candidates to be interviewed for the position.
• All applicants may not be interviewed for this position.

CONFIDENTIAL REFERENCES:

• The District requests that you provide the names and email addresses of at least 2 individuals who are familiar with your work experience.
• A confidential reference from your current supervisor is not required in order for you to be considered for an interview, although it will be required in order to move forward in the hiring process should you be a finalist for this position.

Job Type: Full-time

Pay: $72,326.00 - $136,569.00 per year

Benefits:

• Dental insurance
• Health insurance
• Retirement plan
• Vision insurance

Work Location: In person

Salary : $72,326 - $136,569