Subject Matter Expert - K12 BI Analyst Team Lead and LEA Liaison
Our client, the Maryland State Department of Education (MSDE) has assumed a progressive stance in the collection, validation and reporting of education accountability data.
With the increase in reporting requirements for Federal, and State longitudinal student data, MSDE is increasing the kinds of student data collected and analyzed. To help MSDE achieve this aim, The Division of Accountability and Assessment is modernizing and enhancing its;
(1) Educational Data Warehouse (EDW) and
(2) associated data collection systems.
As a result of a multitude of new projects within DAA, there is an increased need for additional specialized database and application administrator services to maintain, upgrade, install, patch, monitor, and participate in the enhancement of the existing servers, databases, ETL programs, Erwin ERDs and dimensional models, and data dictionaries that support, but not limited to, the following systems; .
ALTEK is assisting the State of Maryland to acquire the short-term services of One (1) K12 BI ANALYST TEAM LEAD AND LEA LIAISON with SEA, LEA, SAS, and K12 BI metrics experience.
Team Management - Direct and track assignments given to the BI team by the project manager
LEA and MSDE Division Liaison - Work with LEA and MSDE Divisions to design and develop accountability and performance reports, dashboards, and educational KPIs
BI Requirements - 1.4.1.1 Review and document business needs, KPIs, report data, and data quality processes of the educational reporting requirements
BI Design - 1.4.1.2 Participate with the MLDS team to design user interface analytics, dashboards, data structure and analytical processes
I Development - 1.4.1.4 Define, prepare, and develop (1) data sets from SAS and data sets from Oracle tables, (2) KPIs, (3) dashboards with graphics, (4) analytics, (5) alerts, (6) reports and graph formats, and (10) OLAP cubes for educational data
BI Testing - 1.4.1.4 Create BI test plan cases for each KPI, dashboard, analytics, and report.
BI Testing - 1.4.1.4.4 Assist in testing of BI test cases, and prepare test result and error reports.
Implementation - 1.4.1.4.5 Assist in preparing conversion schedules, cut-over procedures, and cut-over component checklists. Implement OBIEE dashboards, BI Publisher reports, and Oracle OLAP cubes in a production.
Rollout - Prepare and developing training, and make arrangements for training delivery to end users.
Preferred candidates will meet the following criteria:
1. Education – MS IN Education; pH.D or ED.D in EDUCATION PREFERRED
- Minimum of seven (7) years working in a K12 environment performing achievement and accountability analyses with experience in NCLB, AYP, benchmarks, and growth models.
- Minimum of seven (5) years experience performing multidimensional analyses or statistical analysis with k12 data with experience in statistical methods, and evaluation designs
- Minimum of five (5) years experience with Maryland secondary education system working in a LEA.
- Minimum of five (5) years experience as a teacher.
- Minimum of five (5) year using SAS as data analysis tool.
Communication Skills: Fluent in speaking and writing English.
