Analyst Programmer, Lead
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.
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.
Benefits
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Educational Services
Number of Employees
5,001-10,000 employees
