Systems Analyst

Company 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

• Project management experience.

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. Performs other related duties as assigned.

Additional Information

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

Please include a resume and cover letter in your reply.

https://www.applitrack.com/wcpss/onlineapp/default.aspx?AppliTrackJobId=19964

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