Systems Analyst
Apply NowCompany: Wake County Public Schools
Location: Raleigh, NC 27610
Description:
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.
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.