Position Summary

The Department of American Indian Studies at the University of Minnesota is seeking a temporary student SQL Programmer for the Ojibwe People's Dictionary ( https://ojibwe.lib.umn.edu ). This is an online, searchable, talking dictionary that reaches 50,000 - 60,000 monthly visitors including scholars, Ojibwe community members, and the Minnesota public who benefit from this heritage language. This position supports a one-year project grant focused on enhancing public access, streamlining and speeding the editorial workflow, and creating a new avenue for community-engagement.

A successful candidate will bring development capabilities to best support the design, implementation of design, and migration of data to a MySQL database that will allow the Ojibwe People's Dictionary to improve access and services to the dictionary. Demonstrable experience with structured query language (SQL) is necessary. The candidate needs to understand these aspects of SQL: data definition language (DDL), data manipulation language (DML), and data query language (DQL) is required for this project.

This project was made possible in part by the people of Minnesota through a grant funded by an appropriation to the Minnesota Historical Society from the Minnesota Arts and Cultural Heritage Fund.
Job Responsibilities

The student SQL programmer will be responsible for writing SQL using DDL, DML, and DQL to create and interact with a new database in a MySQL environment. The programmer will write SQL scripts to migrate data from the existing database into the newly designed database by reading and following detailed instructions (e.g. software requirements document, database design document) to properly map old data to new tables. The programmer will work with existing staff, other student programmers and UMN systems to create and configure the database to support the larger project and will respond to testing feedback and ensure completeness of project technical documentation.

• NOTE: This undergraduation job is hourly only -- no tuition benefits are included. Student will work up to 20 hours per week through the grant period until June 30, 2025.

Qualifications

Cultural Heritage Fund through the Minnesota Historical Society.
Required Qualifications

• Demonstrated proficiency with scripting in SQL.
• Experience using MySQL.
• Completion of CS4707 or similar relational database design experience.
• GitHub proficiency, and demonstrated ability to write informative comments for repo pushes.
• Strong written and verbal communication skills.
• Demonstrated ability to document SQL code with comments for future reference.
• Can read and understand formal design documentation.
• Must be an undergraduate student enrolled at the University of Minnesota - Twin Cities campus for academic year 24-25.

Preferred Qualifications

• Experience with Python or another scripting language.
• Can read and understand Ruby on Rails code; no programming will be done in Ruby on Rails.

About the Department

The Department of American Indian Studies at the University of Minnesota strives to cultivate Native leaders
and allies by providing a critical and comprehensive education in the field of Native American and Indigenous
Studies. American Indian Studies majors receive training in contemporary Native literary and artistic
expression, legal and political issues, and historical experiences.
This critical and comprehensive education prepares our students to pursue a multitude of career paths in policy,
education, community development, as well as cutting edge graduate programs. Our nationally-renowned
faculty are committed to challenging conventional academic approaches while also giving students strong
backgrounds in in critical areas of policy, law, history, social theory, education, literary criticism, film, and
environmental studies. All of this is complemented by a thriving Native community on campus, in the Twin
Cities, and throughout the state of Minnesota.

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

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

How To Apply

Student positions are a form of financial support while pursuing an education at the University of Minnesota.

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will have the opportunity to complete an online application for the position and attach a 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.edu

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