A cover letter is required for consideration of this position and should be attached as the first page of your resume. In your cover letter, please address how you meet the required qualifications and your interest in programming and data capture. Those who do not meet the minimum requirements nor submit a cover letter will not be considered. 

The Comprehensive Mobile Precision Approach for Scalable Solutions in Mental Health Treatment (COMPASS) project is looking for an Application Programmer for our new NIMH project. COMPASS is focused on the effects of machine learning, wearable and mobile technology to both reduce mental health symptoms and predict response to clinic-based treatments. The ideal candidate should be passionate about creating new databases and programs to assist in the collection and integration of complex data across multiple platforms, with a focus on research regulations. We are looking for someone who is detail oriented and will work to conceptualize, develop and implement complex program designs to assist with the study data collection, participant tracking, integration of electronic health records, and required sponsor funding reports.

This position will start mainly on the currently described project, with the potential to assist with other projects.

Our office is located at the University of Michigan's North Campus Research Complex. Due to COVID-19 and the remote nature of this project, most work is currently being conducted through telework. However, the programmer may need to come into the office for brief periods of time, observing the University of Michigan health and safety measures. 

Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally.  Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.

The Michigan Neuroscience Institute was established in 1955 to bring together investigators from across the University of Michigan campus to probe the mysteries of the brain on a cellular, molecular, and behavioral level. Its 140 faculty and affiliate members seek to understand the function and dysfunction of the human brain.

40% Code and documentation development: 

• Develop and improve processes for extracting, transforming and loading various complex data sources (SQL, EHR, wearable sensor data, etc.) into study data pipeline.
• Build, maintain, and update databases/scripts/programs aimed at tracking participant involvement and improving data cleaning processes by writing automatic scripts and templates (using .NET, C# and JavaScript (jQuery) or equivalency).
• Develop data documentation (codebooks, technical appendices, etc.) that includes key information for processing and analysis following standard guidelines.
• Identify opportunities to improve the efficiency and quality of data processing and analysis and collaborate with team members to implement solutions.
• Implement monitoring solutions to ensure data integrity and pipelines are operational.
• Investigate new technologies and share with the team.

30% Data cleaning and preparation: 

• Deliver analyzable datasets in multiple formats (Stata, SPSS, SAS, R, Excel, Power BI, etc) to staff and faculty.
• Perform data cleaning, quality checks, and merging procedures on and prepare data sets for different statistical analyses or sponsor reports.
• Work collaboratively with project managers, data analysts and Principal Investigators (PIs) to understand project goals, data requirements, and objectives.
• Answer questions about the structure and nature of datasets.
• Communicate proactively with project managers and PIs about data progress, timelines, and issues.
• Identify and resolve time-sensitive data issues.
• Implement data storage and retrieval solutions for efficient access by members of the research team.

15% Data visualization: 

• Develop data visualizations to effectively communicate data in reports, flowcharts, and dashboards.
• If the position is filled at the intermediate level, you will also support research design, determining and interpreting research results, and independently writing up results of analyses. 

5% Other tasks as needed:

For all titles:

• Proficiency using relevant tools (Python, SQL, etc).
• Web background with coding experience in .NET, C#, JavaScript (jQuery), Spring Boot/MVC or Java.
• Willingness to learn and quickly adjust to new tools and systems.
• Ability to manage multiple projects and assignments with a high level of autonomy and accountability for results.
• Capable of converting ambiguous problem statements into concrete project requirements. 
• Excellent verbal and written communication skills including the ability to communicate effectively and professionally with colleagues and stakeholders. 
• Ability to understand and explain technical concepts to non-technical stakeholders. 

Applications Programmer/Analyst Lead:

• Bachelor's degree in Computer Science, a related field OR equivalent experience. 
• 7-10 years of experience in systems analysis/programming.

Applications Programmer/Analyst Senior: 

• Bachelor's degree in Computer Science, a related field OR equivalent experience. 
• 5-7 years of experience in systems analysis/programming.

Applications Programmer/Analyst Intermediate:

• Bachelor's degree in Computer Science, a related field OR equivalent experience.
• 3-5 years of experience in systems analysis/programming activities.

• Familiar with Michigan Medicine data requirements and procedures
• Experience with EPIC Electronic Health Records
• Experience working with big data
• Experience working with PHI

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.

This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.

Michigan Medicine is firmly committed to advancing inclusion, diversity, equity, accessibility, and belonging, which are core to the culture and values of the Medical School Office of Research. Our community supports recruiting and cultivating a diverse workforce as a reflection of our commitment to serve the diverse people of Michigan and the world. We strive to create a work culture where each team member feels respected, valued, and safe. 

Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings.  Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.

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 anytime after the minimum posting period has ended.

The University of Michigan is an equal opportunity/affirmative action employer.