Apply on Employer Site

Inside Higher Ed · 3 weeks ago

Analyst Programmer, Lead

Atlanta, GA

Full-time

Onsite

Mid, Senior Level

3+ years exp

Inside Higher Ed is associated with Georgia State University, specifically within the Office of Institutional Effectiveness and Enterprise Data Management and Analytics. The Analyst Programmer, Lead will provide technical expertise in developing and maintaining the university-wide data warehouse, ensuring data accuracy and security while supporting decision-making processes across the campus.

Digital MediaEducationHigher EducationJournalismRecruiting

Responsibilities

Provides strategic, analytical, governance, and systems support for a data warehouse aimed at optimizing the utilization of Georgia State University’s data resources

Assists in analyzing business processes and evaluating user requests for new or modified programs. Provides support to end users regarding data definitions and usage. Helps end users write queries against warehouse tables

Assists in developing the warehouse data dictionary and the documents of warehouse business practices. Assists in a Data Governance project in the role of a functional and technical writer

Provides support for Pentaho servers and client environments

Assists in source-to-target mapping data. Assists in building data modeling by designing rules and key constraints

Tests, documents, and performs quality assurance on code. Assists in peer code review

Qualification

Data warehousingOracle PL/SQLSQLPentaho Data IntegrationData modelingData managementBusiness intelligence toolsAnalytical skillsCollaboration skillsTechnical writing

Required

Bachelor's degree and three years of related experience; or a combination of education and related experience

Preferred

Work experience in higher education, particularly institutional data warehousing, is highly desirable

Advanced knowledge of relational database design and Oracle PL/SQL and SQL

Extensive experience in Hitachi Vantara Analytics platform, especially in PDI (Pentaho Data Integration) and Spoon client components

Knowledge in Ellucian Banner student systems, PeopleSoft Human Resource Systems, and PeopleSoft Financial Systems

Experience in data management in higher education. In-depth knowledge of database and data warehouse structures, as well as business intelligence tools and system implementation

Experience with reporting application Argos and BI application Oracle Apex is a plus