Senior Data Engineer in Minneapolis, Minnesota

Apply for Job Job ID364165 LocationTwin Cities Job FamilyInformation Technology Full/Part TimeFull-Time Regular/TemporaryRegular Job Code9703DE Employee ClassAcad Prof and Admin Add to Favorite Jobs Email this Job About 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 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. 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 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. Benefits Working at the University At the University of Minnesota, you’ll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work. The University also offers a comprehensive benefits package that includes: Competitive wages, paid holidays, and generous time off Continuous learning opportunities through professio al 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 Please visit the Office of Human Resources website for more information regarding benefits. 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 [email protected] or call (612) 624-8647. Diversity Employment 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). 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.