Systems Analyst

Wake County Public Schools; Raleigh (NC); On-site; USD 70,000 - 100,000; Full time

Job summary

Wake County Public Schools is seeking a Systems Analyst – Program Management to provide database management, analytics, application support, process improvement, and reporting to support the Building Program and Project Management objectives.

The role requires a Bachelor's degree in CS/IT or a technical field, at least three years of experience in enterprise reporting (SQL, Oracle), data analysis, and experience with web-based and client-based applications.

Qualifications

• Experience developing reports for Enterprise Database Management (SQL, Oracle).
• Proven ability to analyze and optimize data from web applications and to provide custom reports.
• Strong communication skills, both oral and written.
• Experience with data integration and high-volume project reporting.

Responsibilities

• Produces actionable reports using database knowledge and data tools.
• Interacts with users to ensure data availability and reporting needs.
• Performs proactive and reactive analysis, monitoring, and issue resolution in PCM, BI, and related apps.
• Analyzes data file characteristics to support timely loading into the PCM database.
• Installs software releases, tests, and resolves related problems.
• Creates business solutions and designs database approaches.
• Maintains data files and config to ensure data integrity.
• Develops interactive dashboards for internal use highlighting KPIs.
• Supports Building Program reporting on the external website backend.
• Creates and maintains documentation of business processes.
• Develops and enforces security policies for day-to-day system administration.
• Performs other related duties as assigned.

Skills

SDLC

Project management tools

Excel

PowerPoint

Word

Quantitative methods

Analytical ability

Data reporting

Stakeholder relations

Education

Bachelor's degree in CS/IT/Engineering/Math

3 years enterprise reporting (SQL/Oracle)

Web-based and client-based app experience

Tools

SQL

Oracle

Oracle BI Publisher

Primavera Contract Manager

P6

Google Drive

SharePoint

BI dashboards

Job description

The Facilities Design & Construction Department of Wake County Public Schools exists to support its mission to significantly increase achievement for all students by providing a world-class education that equips students with the knowledge and expertise to become successful, productive citizens.

Job Description

The Systems Analyst – Program Management provides database management, analytics, application support, process improvement, and reporting services to support Wake County Public School System’s (WCPSS) Building Program and Project Management objectives.

Qualifications

MINIMUM QUALIFICATIONS

KNOWLEDGE, SKILLS, AND ABILITIES:

• Working knowledge of systems development life cycle;
• Working knowledge of electronic project management tools;
• Extensive knowledge of Excel; strong PowerPoint and Word skills;
• Extensive theoretical understanding of quantitative methods;
• Proven innovative and analytical ability with implementation skills;
• Effective oral and written communication skills;
• Ability to analyze and optimize data from web applications that display complex data sets, to provide custom reports, to integrate with other existing systems, and to use best practices for high volume projects;
• Ability to establish and maintain effective working relationships with central services employees, contractors, and vendors.

EDUCATION, TRAINING, AND EXPERIENCE:

• Bachelor’s degree in computer science, information technology, or a technical field such as engineering or mathematics;
• Three years of experience in developing reports for Enterprise Database Management (SQL, Oracle);
• Experience in data analysis and in supporting web-based and client-based computer applications.

CERTIFICATION AND LICENSE REQUIREMENTS:

• Must hold and maintain a valid motor vehicle operator’s license according to the State of NC requirements.

PREFERRED QUALIFICATIONS

• Business Intelligence analytics experience on enterprise systems like SAP, SAS, Oracle;
• Experience working in an Oracle environment preferred, particularly Primavera Contract Manager, P6, and Oracle Business Intelligence (BI) Publisher platforms;
• Experience developing solutions within Google Drive, or other cloud-based collaboration/document management systems; Experience in Microsoft Sharepoint, including creating Web Parts and dashboards desired

RESPONSIBILITIES

1. Utilizes database knowledge, programming skills, and data manipulation/query tools to produce actionable reports.
2. Interacts with internal/external users regarding data availability, alternative data feasibility, report content/presentation, and potential issues with availability of comparative/historic data, to ensure users receive information in a timely, thorough, accurate, and repeatable manner Performs proactive and reactive analysis, monitoring, troubleshooting and resolution of issues in Primavera Contract Manager (PCM), Oracle Business Intelligence (BI), and other mission critical applications.
3. Analyzes the characteristics and potential error of data files to facilitate the timely loading of information into the PCM Database.
4. Installs new/updated software releases and system upgrades; tests, evaluates and installs service packs and resolves software related problems.
5. Creates business solutions, drives innovation, and designs and implements database approaches, including using moderately complex database-related analyses, coding and projects.
6. Maintains data files and monitors system configuration to ensure data integrity.
7. Contributes to development of interactive dashboards for internal use, highlighting progress/change along Key Performance Indicators.
8. Contributes to the back end database for Building Program reporting on external website.
9. Creates (as needed) and maintains accurate documentation on all assigned business processes.
10. Develops and maintains security policies on user administration for systems used by Facilities Design and Construction for day-to-day operations.
11. Perform other related duties as assigned.

Additional Information

This position is in Wake County Public Schools Technology Band 17.

All your information will be kept confidential according to EEO guidelines.