Senior Data Engineer

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.

Responsibilities:
Data Pipeline Architecture and Development (80%)

• 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.
  

Project Leadership (20%)

• 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.

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

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.

Preferred Qualifications:

• Familiarity with Higher Education
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as
  well as working familiarity with a variety of databases.
• Working knowledge of message queuing, stream processing, and highly scalable 'big data' data stores.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• 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.
• Strong analytic skills related to working with structured datasets.

Pay Range: $113,000 - $123,000 (depending on qualifications); depending on education/qualifications/experience

Time Appointment: 100% Appointment

Position Type: 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

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).