University of Minnesota
Senior Data Engineer
University of Minnesota, Saint Paul, Minnesota, United States, 55130
Apply for Job Job ID 364165Location Twin CitiesJob Family Information TechnologyFull/Part Time Full-TimeRegular/Temporary RegularJob Code 9703DEEmployee Class Acad Prof and AdminAdd to Favorite Jobs Email this JobAbout the Job
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 insupport 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 andproducts. 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 developmentlifecycle.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.Qualifications
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 platformExperience with DatabricksExperience 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 EducationAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) aswell 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 and Benefits
Pay Range:
$113,000 - $123,000 (depending on qualifications); depending on education/qualifications/experienceTime Appointment:
100% AppointmentPosition Type:
P&A StaffPlease 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 offContinuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit ProgramLow-cost medical, dental, and pharmacy plansHealthcare and dependent care flexible spending accountsUniversity HSA contributionsDisability and employer-paid life insuranceEmployee wellbeing programExcellent retirement plans with employer contributionPublic Service Loan Forgiveness (PSLF) opportunityFinancial counseling servicesEmployee Assistance Program with eight sessions of counseling at no costEmployee Transit Pass with free or reduced rates in the Twin Cities metro area
How To Apply
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.Diversity
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.eduEmployment Requirements
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.About the U of M
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).
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 insupport 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 andproducts. 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 developmentlifecycle.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.Qualifications
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 platformExperience with DatabricksExperience 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 EducationAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) aswell 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 and Benefits
Pay Range:
$113,000 - $123,000 (depending on qualifications); depending on education/qualifications/experienceTime Appointment:
100% AppointmentPosition Type:
P&A StaffPlease 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 offContinuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit ProgramLow-cost medical, dental, and pharmacy plansHealthcare and dependent care flexible spending accountsUniversity HSA contributionsDisability and employer-paid life insuranceEmployee wellbeing programExcellent retirement plans with employer contributionPublic Service Loan Forgiveness (PSLF) opportunityFinancial counseling servicesEmployee Assistance Program with eight sessions of counseling at no costEmployee Transit Pass with free or reduced rates in the Twin Cities metro area
How To Apply
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.Diversity
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.eduEmployment Requirements
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.About the U of M
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).