Data Engineer

Please note, this position is not eligible for H-1B or Green Card sponsorship.

The University of Minnesota is committed to fostering local talent through employment opportunities. While this position utilizes a hybrid work modality, prospective applicants must be located either in the state of Minnesota or near the Wisconsin border OR otherwise open to relocation.

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 Data Engineer will be responsible for designing, building, implementing and maintaining data processing channels for data extraction, transformation, and loading to connect large data sets from a variety of sources. This individual will work with the University's Data Platform team utilizing Oracle GoldenGate, Oracle Cloud Infrastructure (OCI), Microsoft Azure and Databricks to orchestrate data flow from the University's ERP (PeopleSoft) to Databricks allowing users to consume and analyze data more efficiently. Additionally, they will prepare and manipulate data using best practices tools, languages, data processing frameworks, and databases. 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.

Job Responsibilities:

• Support and leverage change data capture techniques on the PeopleSoft Oracle database to feed ERP data into downstream systems.
• Create Data Pipelines into Databricks on the Microsoft Azure cloud platform.
• Model system agnostic data structures which are abstracted away from 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.
• Monitor and maintain production integrations and data flows.
• Mentor members of the University, as necessary, coaching on industry best practices for Databricks and 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 2 years of experience, or Master's degree.
• Experience with Cloud Infrastructure
• Experience with Cloud Computing/Cloud Storage
• Demonstrated experience building and optimizing data pipelines, architectures, and data sets.
  

Preferred Qualifications:

• Experience with Microsoft Azure and Databricks
• Familiarity with the Higher Education environment
• Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.
• Experience with relational SQL and NoSQL databases, including Postgres and Cassandra.
• Experience with data pipeline and workflow management tools.
• Experience with object-oriented/object function scripting languages.
• Experience working in an Agile development environment and following Scrum methodologies.
• Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

Pay Range: $102,000 - $112,000; depending on education/qualifications/experience

Time Appointment: 75%-100% Appointment

Position Type: Faculty and P&A Staff

Please visit the Office of Human Resources website for more information regarding benefit eligibility.

The University offers a comprehensive benefits package that includes:

• Competitive wages, paid holidays, and generous time off
• Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit Program
• Low-cost medical, dental, and pharmacy plans
• Healthcare and dependent care flexible spending accounts
• University HSA contributions
• Disability and employer-paid life insurance
• Employee wellbeing program
• Excellent retirement plans with employer contribution
• Public Service Loan Forgiveness (PSLF) opportunity
• Financial counseling services
• Employee Assistance Program with eight sessions of counseling at no cost
• Employee Transit Pass with free or reduced rates in the Twin Cities metro area

While our salary ranges provide a framework, it is important to note that most of the time, the initial pay may not reach the maximum of the range. This approach ensures that compensation reflects the value and unique contributions of each candidate while maintaining equity within our organization. As part of our commitment to fair and equitable compensation, please be aware that the salary offered to incoming candidates will be based on their individual credentials and experience.

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.

Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.

To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.

The University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.

The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.edu

Any offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.

The University of Minnesota, Twin Cities (UMTC)

The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.

At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America's Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).