Job Description

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. The position involves designing, building, and maintaining centralized data storage systems, as well as documenting all related steps and outcomes. Key skills required for this role include creating data models, developing ETL (Extract, Transform, Load) processes, and integrating data. Additionally, strong coordination skills are essential, as the role requires collaboration with cross-functional and technical teams, such as database administrators, data stewards, and IT technicians. These responsibilities and techniques are aimed at effectively supporting the decision-making needs of the campus.

WHAT MAKES EDMA A GREAT PLACE?

· 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

HERE IS WHAT YOU WILL DO

The ideal candidate for this position Analyst Programmer, Lead


The essential duties and responsibilities of the Analyst Programmer, Lead are the following:

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


Disclaimer: This job requisition provides a high-level job definition. It is not intended to provide a comprehensive or exclusive list of job duties. As such, job duties and/or responsibilities within the context of this job requisition may change at the discretion the employee’s direct supervisor.

Qualifications:
Minimum Hiring Qualifications:

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

Preferred Hiring Qualifications:

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