Analyst Programmer, Lead

Georgia State University•Atlanta, GA

60d

About The Position

The Office of Institutional Effectiveness and Enterprise Data Management and Analytics (EDMA) is responsible for the collection, development, and maintenance of the university-wide data warehouse. This 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. For more information, please visit https://oie.gsu.edu/our-services/edma. 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:

Requirements

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

Nice To Haves

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.

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.