Applicants are required to submit a (1) cover letter, (2) resume, and (3) example code via the UM Careers website as one combined electronic document. The cover letter should explain how your skills and experience align with the job requirements and why you are applying for the position. Please include all relevant experience and education in your resume. Example code should not exceed 5 pages in length and should showcase your skills in cleaning, restructuring, and/or merging databases, or be an example of another relevant exercise.

The Criminal Justice Administrative Records System (CJARS) is a next-generation criminal justice data platform designed to improve policy-relevant research on the U.S. justice system. To date, the project has amassed a substantial amount of criminal justice data, including 3 billion lines of raw data, which come from 38 states and cover over 200 million criminal justice events. CJARS was recently awarded a $6 million grant from Arnold Ventures to expand project operations over the course of the next three years. We are seeking applications for a Programmer/Data Analyst to join our expanding team and contribute to the production of the CJARS data infrastructure. As a Programmer/Data Analyst, you will work within a team of data processing staff to develop a codebase to wrangle large criminal justice databases. 

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.

The Programmer/Data Analyst will engage in a number of activities that support the development and expansion of the CJARS data infrastructure.

The Programmer/Data Analyst will have a number of key roles, including:

• Contribute to a codebase of Stata and Python to manage, process, and harmonize large administrative criminal justice datasets to produce the CJARS data infrastructure.
• Develop code in a team environment, review code of other team members, and collaborate with other team members to solve new data wrangling challenges. Manage codebases using git.
• Test and debug code as needed to address the causes of data quality problems.
• Produce data visualizations using Stata and Python as needed.
• Review information available on data sources (e.g., criminal justice agency websites) to collect information to inform best approaches to coding and processing data.
• Update and maintain metadata files stored in CSV and JSON formats.
• Prepare documentation files that support and provide context for scripts developed to process data.
   

• A bachelors degree in a relevant field. A combination of education and professional experience may be considered in lieu of a bachelor's degree.
• 1 to 3 years of relevant professional experience.
• Ability to code using common statistical/data management software programs, such as: Stata, Python, SQL, R, SAS, etc.
   

• Experience writing and documenting high-quality code using version control systems such as Git.
• Experience using Stata to process and manage data.
• Experience wrangling large databases.
• Experience conducting statistical analyses on big data.
• Knowledge of the U.S. criminal justice system.
   

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.

The position is in-person in Ann Arbor, Monday through Thursday. Friday is an optional work-from-home day.

The salary range for this position is $64,600 to $80,000.

As one of the world's great liberal arts colleges, LSA pushes the boundaries of what is understood about the human experience and the natural world, and we foster the next generation of rigorous and empathetic thinkers, creators, and contributors to the state of Michigan, the nation, and the world.

To learn more about LSA's Mission, Vision and Values, please visit https://lsa.umich.edu/strategicvision
 

The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third-party administrator to conduct background checks.  Background checks are performed in compliance with the Fair Credit Reporting Act.

Job openings are posted for a minimum of seven calendar days.  The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled any time after the minimum posting period has ended.

The University of Michigan is an equal employment opportunity employer.