Youngstown State University is looking to solve the problem of integrating data from multiple sources for use in data analytics activities across business and academic functions, while ensuring data integrity and governance.
Requirements
- Knowledge of: ERP software solutions and third-party integrations, enterprise database management systems, SDLC methodologies, security practices, deployment and integration; application frameworks implementing the Java programming language.
- Proficient level experience in the following: coding using tools such as SQL, Power BI, and/or SQL Server Management Studio, ETL fundamentals and building efficient data pipelines, and/or using big data technologies, such as Snowflake, or similar.
- Experience in systems development working with larger enterprise systems and/or third-party applications or demonstrated proficiency with software applications, technical skills and/or business processes.
- Experience collaborating on data governance/data management capabilities that enable interoperability, decision making, and execution.
- Experience in data-modeling and data-architecture optimization for big data patterns, data warehousing, focusing on efficient storage and query performance.
- Experience working in a higher education environment; Ellucian Banner experience; working knowledge of the Ellucian ETHOS platform and integration experience with APIs; working knowledge of Oracle, SQL, and UNIX;
- Experience integrating outside applications (including cloud-based systems) with internal enterprise systems.
Responsibilities
- Designs and implements efficient data pipelines (ETLs) in order to integrate data from a variety of sources into YSU’s data warehouse.
- Performs requirement and data analysis in order to support warehouse project definition.
- Develops and maintains data standards to ensure data integrity.
- Implements data model changes that align with warehouse standards and data management processes.
- Develops and maintains inventory of the enterprise information artifacts, including authoritative systems, owners.
- Designs, implements, and optimizes automated methods for service delivery and support in stand-alone, client-server, web-based, hosted, cloud and/or other distributed technology environments.
- Manages installations, configurations, systems resources, solutions, and corrective actions for optimum performance and usability.
Other
- At least a bachelor’s degree and two years of demonstrated competency in a related role developing enterprise data solutions.
- Ability to succeed in a self-motivated, innovative, and team-oriented environment; effectively facilitate projects/initiatives using collaboration, dashboarding, and stakeholder management.
- Skill in: communication.
- Supervision may be exercised over student employees.
- Reports to: Associate Director
