Analyst Programmer, Lead

Analyst Programmer, Lead – Georgia State University

Position in the Office of Institutional Effectiveness and Enterprise Data Management and Analytics (EDMA) which is responsible for the collection, development, and maintenance of the university-wide data warehouse. The office provides streamlined resources that serve as a foundation for data analysis, reporting needs, and support for strategic planning and policy‑making processes at Georgia State University. EDMA ensures the flow of accurate and timely information at all levels of management, helping them obtain and interpret data effectively.

This position involves providing technical expertise in planning, developing, testing, and documenting integrated computer application programs for the enterprise data warehouse, ensuring data accuracy and security. The responsibilities of this role include gathering and analyzing business processes from varied GSU application systems, designing, building, and maintaining centralized data storage systems, and documenting all related steps and outcomes. Key skills include creating data models, developing ETL (Extract, Transform, Load) processes, integrating data, and coordinating with cross‑functional teams such as database administrators, data stewards, and IT technicians to support decision‑making needs of the campus.

• Generous benefits, including health, dental, vision, tuition assistance, retirement, etc.
• A knowledge‑sharing organization that works collaboratively with diverse partners.
• Professional development opportunity and mentorship
• A rapidly growing center within an academic setting

• 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.

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

• 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, People Soft Human Resource Systems, and People Soft 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.

Location:

Atlanta Campus