Programmer/Data Analyst - CJARS Job at University of Michigan - Ann Arbor in Ann

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

The Programmer/Data Analyst will work within a team of data processing staff to develop a codebase to wrangle large criminal justice databases and will have key roles including:

1. Contributing to a codebase of Stata and Python to manage, process, and harmonize large administrative criminal justice datasets.
2. Developing code in a team environment, reviewing code of other team members, and collaborating to solve data wrangling challenges. Managing codebases using git.
3. Testing and debugging code to address data quality issues.
4. Producing data visualizations using Stata and Python.
5. Reviewing data source information to inform coding and processing approaches.
6. Updating and maintaining metadata files in CSV and JSON formats.
7. Preparing documentation to support scripts developed for data processing.

Qualifications include:

• A bachelor’s degree in a relevant field or a combination of education and professional experience.
• 1 to 3 years of relevant professional experience.
• Proficiency in coding with software such as Stata, Python, SQL, R, SAS, etc.
• Experience with version control systems like Git.
• Experience processing and managing large datasets with Stata.
• Experience wrangling large databases and conducting statistical analyses on big data.
• Knowledge of the U.S. criminal justice system.

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