Systems Analyst, Advanced Entry Level

Job Details

Title:

Systems Analyst, Advanced Entry Level

Job Category:

Staff

Description:

The USG System Office’s Information Technology Services (ITS) is accepting applications for a Systems Analyst, Advanced Entry Level position in USG Business Intelligence team. The Analyst is responsible for creating, revising, and supporting reporting needs from USG system offices and Colleges and Universities throughout the state of Georgia. Included in these duties are timely requirements gathering, analysis, design, development, testing and deployment activities in USG data warehouse environment, standard report and dashboard development in IBM Cognos, data extraction from complex databases for ad-hoc data request, and support for report users at all levels.

A successful candidate should have the following knowledge and skills:

• Understanding of relational and dimensional database concepts.

• Be able to gather and translate business requirements to technical specifications.

• Be able to gather and prepare data from multiple data sources to support business analytics.

• Be able to develop, produce and distribute reports, dashboards and other visualizations using a variety of reporting platforms (IBM Cognos, Tableau etc.).

• Be able to perform unit and integration testing, and report and data validation.

• Intermediate knowledge and skill in Oracle database, PL/SQL, and IBM Cognos.

Required Qualifications:

EDUCATION AND EXPERIENCE REQUIRED:

• Baccalaureate degree required.

• Over one year of related experience required.

• Or equivalent combination of education and experience.

KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:

• Knowledge of programming code language and logic.

• Knowledge of internet standards.

• Knowledge of change management processes.

• Knowledge of data storage systems.

• Knowledge of backup systems concepts.

• Knowledge of database development and management concepts.

• Knowledge of firewall and information security principles.

• Knowledge of server operating systems.

• Knowledge of industry best practices.

• Knowledge of system administration products and tools.

• Knowledge of application protocols, advanced networking and multi-tier application architecture.

• Skill in collaborating with multiple constituents.

• Skill in decision making and problem solving.

• Skill in the provision of support to end users.

• Skill in oral and written communication.

• Ability to respond diplomatically to sensitive and critical issues.

• Ability to effectively multi-task.

Desired Qualifications:

Strongly Preferred:

• Completion of a undergraduate degree (BA /BS) and 2-3 years of related experience; or equivalent combination of education and experience to include program certification.

• 2 Years of experience in report development and Business Intelligence technologies including IBM Cognos, Tableau and/or other similar tools.

• 3 years of experience in Oracle or SQL Server database, familiar with tools like SQL Developer or TOAD.

• 3 years of SQL experience.

• Strong data analysis, issues analysis and troubleshooting skills.

• Effective verbal and written communication skills

• Higher education working experience

Preferred:

• Understanding of Elucian Banner, PeopleSoft HR and PeopleSoft Finance

Posting Department:

7334000-Data Services

Location:

Athens

Regular/Temporary:

Regular

Minimum Hiring Salary:

$47,144

Open Date:

02/27/2017

Hours Per Week:

40 Hours Per Week-Must be able to work on a schedule that includes nights, weekends, or holidays when required to address escalated issues.

Required Documents Message:

Cover Letter, Resume