PDReport .us



State of MichiganCivil Service CommissionPosition Code1. DEPTALTEA27YCapitol Commons Center, P.O. Box 30002Lansing, MI 48909POSITION DESCRIPTIONThis position description serves as the official classification document of record for this position. Please complete the information as accurately as you can as the position description is used to determine the proper classification of the position.2. Employee's Name (Last, First, M.I.)8. Department/AgencyEDUCATION3. Employee Identification Number9. Bureau (Institution, Board, or Commission)4. Civil Service Position Code Description10. DivisionDEPARTMENTAL ANALYST-EDivision of Educator, Student, and School Supports5. Working Title (What the agency calls the position)11. SectionEducation Staffing Longitudinal AnalystOffice of Educator Excellence (OEE)6. Name and Position Code Description of Direct Supervisor12. UnitBOSWELL GALLAGHER, KATELYN; EDUCATION CONSULTANT MANAGER-5Data and Accountability Unit7. Name and Position Code Description of Second Level Supervisor13. Work Location (City and Address)/Hours of WorkLAVAN, SARAH; STATE ADMINISTRATIVE MANAGER-2608 W. Allegan Street, Lansing / Monday-Friday 8-514. General Summary of Function/Purpose of PositionThis position is responsible for analyzing, compiling, and reporting education staffing data from the Michigan Statewide Longitudinal Data System (MSLDS) and the Michigan Online Educator Certification System (MOECS) in a manner that accurately portrays information on Michigan’s public education staff over time. The position follows the standards, policies, procedures and protocols related to quality assurance, data quality, reporting tools, and data manipulation techniques. The position supports the creation of an environment that encourages maximum use of staffing data for improving education policy decision-making while meeting federal and state data reporting requirements. This position works closely with staffing data users in the Center for Educational Performance and Information (CEPI) and the Michigan Department of Education (MDE) by responding to the data needs of the public, schools, state agencies, the federal government, and other stakeholders.15. Please describe the assigned duties, percent of time spent performing each duty, and what is done to complete each duty.List the duties from most important to least important. The total percentage of all duties performed must equal 100 percent.Duty 1General Summary:Percentage:55Provide data analysis and reporting services that support the day-to-day use of staffing data collected and maintained by the Michigan Department of Education (MDE) and Center for Educational Performance Information (CEPI)Individual tasks related to the duty:Collect detailed business requirements that enable the creation of comprehensive, logical reports to provide quantitative answers to policy questions for decision-making purposes.Create data dashboards, files, or reports that meet the stakeholder requirements using data from the Registry of Education Personnel (REP), MSLDS, MOECS, etc.Analyze data and generate reports including graphs, charts, and dynamic drill-through capabilities.Design custom queries and views of data to meet general and specific stakeholder requirements.Perform quality reviews of data, reports, and queries used by other employees to ensure quality, accurate data are provided from administrative staffing data.Assist in the delivery of web-accessible reports, data marts, and data dashboards or scorecards.Test alignment of data outputs with metrics reported on web portal and metrics reported elsewhere.Collaborate with stakeholders on report requirements including outputs, format, delivery methods, and frequency.Implement document change controls to maintain version control procedures.Develop reports, create ad-hoc data queries, resolve data-related reporting issues, and document report creation processes.?Analyze and document the impact of input changes that affect output.Duty 2General Summary:Percentage:40Provide user support, documentation, and training on the use of staffing data for business and technical users.Individual tasks related to the duty:Perform maintenance of a comprehensive data explainer document for MOECS staffing data usersDevelop a corresponding data explainer document for the Staffing Individual Table in the MSLDS and other research files generated by CEPI for MDE use.Develop, edit, and maintain data use manuals including complex scenarios for data input and outputs to support data refreshment cycles.Assist in tracking ad-hoc and recurring data reports related to educator staffing in OEE.Develop processes to eliminate redundant effort between OEE and CEPI.Assist in developing and maintaining data resource management, access, and use policies and procedures, including procedures for authorized use of data, and address needed confidentiality.Provide consulting and training services, where appropriate, on data use and interpretation and tool use.?Provide user support (ISDs, districts, schools, state agencies, researchers, etc.) for the appropriate use of business intelligence and reporting tools related to the creation of standard reports, customized data imports, exports, and ad-hoc queries of staffing data, in order to provide meaningful information to education policymakers and comply with federal and state reporting requirements.Duty 3General Summary:Percentage:5Other duties as assignedIndividual tasks related to the duty:Other job-related duties as assigned.16. Describe the types of decisions made independently in this position and tell who or what is affected by those decisions. In accordance with the policies and procedures relating to the design, development, documentation, integration, analysis, and reporting of longitudinal education data, the analyst is authorized to use independent analytical and problem-solving skills to resolve stakeholder issues.?Present process, policy, and procedure recommendations to supervisor in order to achieve greater efficiencies and effectiveness toward the success of agency goals.17. Describe the types of decisions that require the supervisor's review. The supervisor will approve of all policy or procedural changes, in accordance with agency standards. Any deviations from recognized processes, policies and/or procedures should be brought to the supervisor’s attention prior to implementation.18. What kind of physical effort is used to perform this job? What environmental conditions in this position physically exposed to on the job? Indicate the amount of time and intensity of each activity and condition. Refer to instructions.Physical activities: primarily sitting and occasionally standing, stooping, bending, reaching, and lifting. There are no hazardous environmental conditions present on this job.19. List the names and position code descriptions of each classified employee whom this position immediately supervises or oversees on a full-time, on-going basis.Additional Subordinates20. This position's responsibilities for the above-listed employees includes the following (check as many as apply):NComplete and sign service ratings.NAssign work.NProvide formal written counseling.NApprove work.NNApprove leave requests.Review work.NApprove time and attendance.NProvide guidance on work methods.NOrally reprimand.NTrain employees in the work.22. Do you agree with the responses for items 1 through 20? If not, which items do you disagree with and why?Yes23. What are the essential functions of this position?This position is responsible for analyzing, compiling, and reporting education staffing data from the Michigan Statewide Longitudinal Data System (MSLDS) and the Michigan Online Educator Certification System (MOECS) in a manner that accurately portrays information on Michigan’s public education staff over time. The position follows the standards, policies, procedures and protocols related to quality assurance, data quality, reporting tools, and data manipulation techniques. The position supports the creation of an environment that encourages maximum use of staffing data for improving education policy decision-making while meeting federal and state data reporting requirements. This position works closely with staffing data users in the Center for Educational Performance and Information (CEPI) and the Michigan Department of Education (MDE) by responding to the data needs of the public, schools, state agencies, the federal government, and other stakeholders.24. Indicate specifically how the position's duties and responsibilities have changed since the position was last reviewed.This position is being updated due to the Section name from Office of Educator Talent to Office of Educator Excellence and the Unit name has also changed from Educator Effectiveness Unit to Accountability Unit.? Additionally, the box #25 has been updated to reflect the change in the?function of the office.25. What is the function of the work area and how does this position fit into that function?The Office of Educator Excellence serves the community by providing whole-child centered resources to ensure every student in the P-20 system has equitable access to a high-quality, barrier-free system of education professionals.? This is accomplished by the recruitment, preparation, certification, development, support, retention, and recognition of educators through collaboration with internal and external partners. This position provides analysis, compiling and reporting of educator workforce data critical to meeting federal reporting requirements, making policy decisions and supporting internal and external constituents.? 26. What are the minimum education and experience qualifications needed to perform the essential functions of this position.EDUCATION:Possession of a bachelor’s degree in any major.EXPERIENCE:Departmental Analyst 9No specific type or amount is required.Departmental Analyst 10One year of professional experience.Departmental Analyst P11Two years of professional experience, including one year of experience equivalent to the intermediate (10) level in state service.Experience in the development, enhancement, and maintenance of complex data sets/systems desired. KNOWLEDGE, SKILLS, AND ABILITIES:Ability to utilize large, complex, relational databases and experience in connecting data longitudinally desired.Knowledge and experience working with SQL Server, SAS Enterprise Guide, other reporting tools are highly desirable.Experience with metadata, web portals, dashboards, web technologies, and/or report generation tools.Ability to analyze data and produce ad-hoc reports or answer questions using data.Ability to create SAS Information MAPSAbility to design data dashboards and scorecards.Ability to create SAS Web Report Studio reports.Ability to communicate with stakeholders such as program office analysts, researchers, and other data users.Ability to organize, analyze, and assess data quality.Ability to organize, evaluate, and prepare documentation and reports in relation to complex, interrelated, and independent data systems.?Ability to interpret laws, rules, and regulations as they relate to system and reporting requirements.CERTIFICATES, LICENSES, REGISTRATIONS:NoneNOTE: Civil Service approval does not constitute agreement with or acceptance of the desired qualifications of this position.I certify that the information presented in this position description provides a complete and accurate depiction of the duties and responsibilities assigned to this position.SupervisorDateTO BE FILLED OUT BY APPOINTING AUTHORITYIndicate any exceptions or additions to the statements of employee or supervisors.Please update.I certify that the entries on these pages are accurate and complete.JENNIFER GRAY3/27/2019Appointing AuthorityDateI certify that the information presented in this position description provides a complete and accurate depiction of the duties and responsibilities assigned to this position.EmployeeDate ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download