GENERAL RESPONSIBILITIES

The Reporting Lead Analyst will:

• Interpret ad hoc data requests and develop custom reports using SQL, SSRS, and Excel.
• Collaborate with the Accountability & Strategic Initiatives team to understand data needs, deliver accurate data, and contribute to data analysis initiatives.
• Ensure the successful completion of state and federal reporting, meeting deadlines and accuracy standards.
• Work with the Department of Technology and the SIS Lead Analyst to ensure accurate data availability and assist with database process maintenance and troubleshooting.
• Manage enterprise data and databases using Microsoft SQL Server and Visual Studio.
• Collaborate with colleagues, vendors, and VDOE partners to resolve identified issues.
• Provide accurate and reasonable timelines and effectively assist/lead simultaneous projects with established deadlines.
• Document procedures and guidelines.
• Provide formal and informal staff training on reporting and other data-related processes.
• Apply industry-standard best practices.
• Perform other duties as assigned.

KNOWLEDGE, SKILLS AND ABILITIES

Required:

• Proficiency in SQL
• Advanced Excel skills

Preferred:

• Knowledge of relational database design concepts
• Experience with report writing software (SSRS)
• Knowledge of state and federal reporting mandates
• Experience with student information systems
• Previous work experience in education
• Process documentation skills
• Office 365

EDUCATION AND EXPERIENCE

Bachelor's degree in computer science, information systems, data analytics, or related field plus 3-5 years of relevant experience, or combination of education and experience that enables successful performance of key responsibilities.

PHYSICAL REQUIREMENTS

Some standing, walking, moving, climbing, carrying, bending, kneeling, crawling, reaching, handling, pushing, and pulling. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential tasks.

RCPS is an Equal Opportunity Employer and does not discriminate on the basis of race, color, national origin, sex, disability or age in its programs and activities.  The following person(s) has been designated to handle inquiries regarding the non-discrimination policies: Hayley Poland – Title IX Coordinator (540) 853-1393.