EXPERIENCE
8 years of progressively responsible experience in data engineering, enterprise data warehousing, ETL development, analytics engineering, or equivalent.
KNOWLEDGE, SKILLS, AND ABILITIES - The following are essential:
- Experience designing and supporting enterprise data warehouses, operational data stores, and cloud-based analytics platforms.
- Experience supporting hybrid cloud and on-premises enterprise data ecosystems.
- Ability to architect scalable enterprise data solutions.
- Strong understanding of enterprise integration patterns and data lifecycle management.
- Experience with Oracle Database and PL/SQL development, or SQL Server and T-SQL development, or equivalent tools and technologies.
- Experience with database performance tuning, SQL query tuning and optimization.
- Experience with data modeling and schema design.
- Experience building and supporting Enterprise Data Warehouse (EDW), Operational Data Store (ODS) and Data Lakes using ETL/ELT methodologies.
- Experience using Cloud & Integration Platforms such as Oracle Cloud Infrastructure (OCI), Oracle Integration Cloud (OIC), SnapLogic, SSIS, API integrations (REST/SOAP) and SFTP and file-based integrations.
- Experience with analytics & reporting such as Power BI, Oracle Analytics Cloud (OAC) or equivalent.
- Understanding of SDLC and Agile methodologies
- Understanding of version control and DevOps practices.
- Understanding of cloud security concepts.
- Strong analytical and problem-solving skills.
- Ability to communicate technical concepts to both technical and non-technical stakeholders.
- Strong organizational and project management skills.
- Ability to manage multiple priorities in a complex enterprise environment.
- Commitment to customer service and continuous improvement.
- Ability to use a personal computer and other office equipment, including related university software and email.
Desirable Skills & Abilities
- Experience with Oracle Fusion Cloud ERP/HCM integrations and reporting.
- Experience with higher education platforms such as Ellucian Colleague, Ellucian Banner, Oracle Fusion Cloud, Oracle EBS, PeopleSoft Campus Solutions, Workday Student or equivalent systems.
- Experience with Oracle Autonomous Database (ATP/ADW).
- Experience with OCI Data Integration, OCI Object Storage, or OCI Analytics services.
- Experience with data quality, data governance and metadata management
- Relevant Oracle, Microsoft, or cloud certifications preferred.
- Experience working in a higher education environment.
- Knowledge of IPEDS reporting.
- Knowledge of FERPA and HIPAA.