- This is position is currently funded for two-years. While we anticipate it continuing longer, that is dependent on continued grant funding.
- A cover letter and resume are required for consideration for this position. The cover letter should be included in the same document as your resume and should specifically address your interest in this position and highlight related skills and experience.
- A fully-remote appointment (within the U.S.) may be considered.
The University of Michigan is looking for a Database Analyst/Programmer to become an active member of the Education Policy Initiative and the Michigan Education Data Center. We offer the opportunity to employ a broad set of data science and data engineering skills in support of critical research that aims to improve education for all students. If you are interested in data warehousing, ETL development, object-oriented programming, systems administration, high-performance computing, and impactful research, then this position in a faculty-led research shop is for you.
The Education Policy Initiative at the Ford School of Public Policy brings together nationally-recognized scholars focused on the generation and distribution of policy-relevant education research. We work in partnership with schools, districts, and state agencies to conduct research that inform both policy and practice. Large-scale administrative data from multiple government agencies, nonprofits and other sources is the basis of all of our research.
The Michigan Education Data Center manages and distributes education data owned by the State of Michigan to researchers nationwide. Managing the acquisition, organization, warehousing, documentation, security, and distribution of this data is the central task of the Database Analyst.
The Database Analyst/Programmer will work at the Ford School of Public Policy and report to the Senior Data Architect. You will have responsibility for managing, processing, and analyzing the large-scale administrative data sets central to our work.
- Perform a wide range of data extraction, intake, and cleaning procedures, which prepare data to be used by researchers for different kinds of statistical analyses
- Contribute to the maintenance and improvement of a large SQL Server instance used to warehouse administrative education records
- Conduct internal reviews of data for quality, integrity and reasonableness, making suggestions for ways to improve processes (e.g. look for anomalies in the data and address)
- Produce and update standard codebooks and other technical data documentation
- Respond to data requests and provide support to all partners
- Analyze complex data sets statistical techniques to provide critical information to stakeholders
- Develop and maintain API wrappers used for access controls, data ingestion and reporting
- A bachelor’s degree in data/information science, statistics, information, computer science or relevant social science field or equivalent professional experience
- At least two years of experience gathering, processing, merging, managing and archiving data including combining data from different sources, producing reports, cleaning and preparing data for analysis
- Proficient in at least one programming language, such as Python, R, Stata, or SQL
- Understanding of basic to intermediate programming concepts. Experience or training in object-oriented programming, API use, debugging and version control
- Experience with complex data structures and linkages between data sources
In addition to a career filled with purpose and opportunity, The University of Michigan offers a comprehensive benefits package to help you stay well, protect yourself and your family and plan for a secure future. Benefits include:
- A retirement plan that provides two-for-one matching contributions with immediate vesting
- Many choices for comprehensive health insurance
- Long-term disability coverage
- Flexible spending accounts for healthcare and dependent care expenses
The University of Michigan is an equal opportunity/affirmative action employer.
U-M COVID-19 Vaccination Policy
COVID-19 vaccinations are now required for all University of Michigan students, faculty and staff across all three campuses, including Michigan Medicine. This includes those working or learning remotely. More information on this policy is available on the Campus Blueprint website or the U-M Dearborn and U-M Flint websites.
