What are the responsibilities and job description for the Data Engineering Lead (Migration - Oracle ODS/ODI Microsoft Fabric) - Chicago, IL ( Need locals) position at Pioneer Corporate Services Inc?
Position: Data Engineering Lead (Migration - Oracle ODS/ODI Microsoft Fabric)
Location: Chicago, IL (Locals only, Onsite Role)
Job Type: Contract Role
Job Description:
Mandatory Skills:
- Hands-on experience with MCD in their High-ed division.
- Good exposure to full migration of Banner ODS into Fabric.
- Domain: Higher Education experience, having worked with a University.
- Should be familiar with the banner to ODS refresh process and the overall data movement architecture.
- Experience with ODI (Oracle Data Integrator) is preferred but optional.
- The candidate should have knowledge of the Banner/ODS modules, including:
- Awareness of the key modules in use
- Understanding of how these modules work
- The type of data each module contains
- Familiarity with module related tables
- Should understand how data is refreshed for these modules and how the refresh process is managed.
Description:
We are seeking a Data Engineering Lead to drive the migration of enterprise data pipelines and data storage from Oracle ODS to Microsoft Fabric. This role requires strong experience with Ellucian Banner SIS and Banner ODS, along with hands on cloud data engineering leadership.
Key Responsibilities
- Lead modernization and migration of Oracle ODS/ODI workloads (part of Ellucian Banner ODS) into Microsoft Fabric (OneLake, Data Factory, Lakehouse, Warehouse).
- Redesign ETL/ELT processes and data models for Fabric-native architecture.
- Analyse integrations and data flows from Ellucian Banner SIS and Banner ODS to Fabric.
- Manage offshore data engineers deliverables, set standards, and ensure delivery quality.
- Partner with functional and technical teams to support reporting and analytics continuity
Required Qualifications:
- 8 10 years data engineering experience, including cloud migrations.
- Strong hands-on knowledge of Oracle ODS, ODI, SQL, PL/SQL, and Python.
- Expertise with Banner SIS and Banner ODS (must-have).
- Expertise with Cognos/Argos: Commonly used reporting tools to query the ODS/EDW.
- Experience with Microsoft Fabric, Azure Data services, Power BI and modern data pipelines.
- Solid understanding of data modelling, warehousing, and ETL architecture.
- Experienced in managing offshore resources and delivering projects in a offshore model
Experience:
- Required- Higher education technology background.
- Experience with Power BI, CI/CD (Azure DevOps/GitHub), and governance frameworks.