Sr. Integration Engineer- ODS - Education domain (100% Remote)

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.