Analyst Programmer, Lead

Atlanta, GA - USA

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Minimum Hiring Qualifications:

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

Analyst Programmer Lead

Georgia State University

The Office of Institutional Effectiveness and Enterprise Data Management and Analytics (EDMA)

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

To be fully considered for this position all candidates must submit the following at the time of submission:

A complete and accurate GSU application Resume Cover Letter (Recommended)

Finalcandidates must provide three professional references.

#LI-KH1

Required Experience:

Minimum Hiring Qualifications:Bachelors 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 relatio...