Title: Senior Data Engineer
Salary: $113,000 - 123,000 (depending on qualifications)
Consider a career with one of the nation’s largest Universities! The Office of Information Technology (OIT) develops and maintains mission-critical applications for the University of Minnesota. The Cloud Engineer will be responsible for working with our Data Platform and Cloud Enablement teams to implement a multi-container OCI environment in support of an Oracle GoldenGate implementation as well as an Oracle Analytics Cloud implementation. The ideal candidate is an experienced Oracle Cloud Infrastructure Engineer with experience establishing all aspects of the OCI architecture. Candidates will be expected to work with multiple teams supporting the needs of those teams, systems and products. The ideal candidate will have experience in Higher Education and be excited by the prospect of assisting with the implementation of the University’s data architecture to support our next generation of products and data initiatives.
We Offer:
- University paid contribution (10% of your salary) to your retirement account - vested immediately.
- 22 paid vacation days per year, in addition to sick leave and 11 paid holidays.
- Reduced tuition opportunities covering 75% - 100% of eligible tuition.
- Excellent and affordable health care benefits.
- Wellness program with opportunity to earn lower health care rates.
- Free disability insurance.
- Annual merit increase program.
Responsibilities include:
80% Data Pipeline Architecture and Development
- Support and leverage change data capture techniques on the PeopleSoft Oracle database to feed ERP data into downstream systems.
- Create Azure Data Pipelines using the Microsoft Azure toolkit. Model system agnostic data structures based to abstract away PeopleSoft specific source data structures.
- Implement data structures (SQL and no-SQL) on Oracle and Microsoft Azure data platforms.
- Implement and maintain data security activities including role, account, and secret management as well as regular access review.
- Design, develop and deploy new APIs, event streams, and file based integrations using Dell Boomi, Oracle SQL, Apache Kafka, Amazon SQS, and other data integration technologies.
- Monitor and maintain production integrations and data flows.
20% Project Leadership
- Mentor members of the team, as necessary, working on all phases of the application development lifecycle.
- Provide Subject Matter Expertise on Change Data Capture and Databricks implementation practices.
Required qualifications:
- BA/BS plus at least 4 years of experience, or master’s degree plus 2 years of experience.
- Experience with the Microsoft Azure platform
- Experience with Databricks
- Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets.
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.