Systems Analyst

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

Utilizes database knowledge, programming skills, and data manipulation/query tools to produce actionable reports. 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. Analyzes the characteristics and potential error of data files to facilitate the timely loading of information into the PCM Database. Installs new/updated software releases and system upgrades; tests, evaluates and installs service packs and resolves software related problems. Creates business solutions, drives innovation, and designs and implements database approaches, including using moderately complex database-related analyses, coding and projects. Maintains data files and monitors system configuration to ensure data integrity. Contributes to development of interactive dashboards for internal use, highlighting progress/change along Key Performance Indicators. Contributes to the back end database for Building Program reporting on external website. Creates (as needed) and maintains accurate documentation on all assigned business processes. Develops and maintains security policies on user administration for systems used by Facilities Design and Construction for day-to-day operations. 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. #J-18808-Ljbffr Wake County Public Schools