Data Analyst

• Develop, test, maintain, and troubleshoot software solutions and research data workflows using Python and SQL.
• Design, optimize, and support database queries, data integrations, and related processes for NIH-funded and privately funded research studies.
• Collaborate with investigators, research staff, and technical stakeholders to translate study requirements into secure, reliable, and maintainable technical solutions.
• Develop and support data pipelines, workflow automation, and analytics or reporting platforms.
• Help maintain the integrity, quality, security, and appropriate handling of research data.
• Document technical designs, data processes, software changes, and operational support procedures.
• Assist with troubleshooting and resolving software, database, and data-processing issues throughout the research lifecycle.

General Responsibilities

• Provide experienced analysis of existing data and data structures and satisfies ad-hoc reporting/analysis requests.
• Create reporting specifications for new reports/dashboards/analytical tools and perform testing/validation; ensures integrity, accessibility, and accuracy of reports/dashboards and data structures; review and approve user requests for access to reporting data and tools.
• Consult with faculty and/or staff to identify new business reporting needs and provide guidance and interpretation of complex environments and data.
• Document data analysis efforts (data sources, reporting specifications, tools, issue/problem resolutions).
• Perform experienced analysis to interpret and determine validity and quality of data.
• Perform migration and conversion of data as needed in support of analysis efforts.
• Research and stay up-to-date on emerging technologies and tools and make recommendations for implementation to improve data analysis services and approaches.

Combinations of related education and experience may be considered. Education beyond the minimum required may be substituted for work experience. Work experience beyond the minimum required may be substituted for education.

EDUCATION

Required

• Bachelor’s degree (preferably in computer science, information science, or related field).

WORK EXPERIENCE

Required

• 2 years of data analysis, reporting, or related experience.

Preferred

• Experience supporting research, healthcare, scientific, or other data-intensive environments.
• Experience with data integration, ETL/ELT processes, data quality practices, or automated data workflows.
• Experience working with sensitive or regulated data and following applicable security, privacy, and data-governance requirements.

SKILLS

Required

• Proficient communication skills.
• Maintains a high degree of professionalism.
• Demonstrates time management and priority setting skills.
• Demonstrates a high commitment to quality.
• Possesses flexibility to work in a fast paced, dynamic environment.
• Seeks to acquire knowledge in area of specialty.
• Highly thorough and dependable.
• Demonstrates a high level of accuracy, even under pressure.

Preferred

• Maintains a high level of self-direction by seeking out opportunities to add value, rapidly learning what is needed, and taking ownership for results.
• Experience developing software or data solutions using Python.
• Demonstrated proficiency with SQL, including writing, troubleshooting, and optimizing complex queries.
• Experience with one or more of the following database platforms: MySQL, PostgreSQL, or Microsoft SQL Server.
• Experience with the Apache suite (Airflow, Superset, Doris) is a plus.
• Experience with the SQL Server data management suite (SSRS, SSIS, SSMS) is a plus.

Working Conditions / Demands

This role requires the ability to effectively communicate and to operate a computer and other standard office productivity equipment. The position involves sedentary work as well as periods of time moving around an office environment and the campus. The person in this role must be able to perform the essential functions with or without an accommodation.

This is a fully remote position. However, this is subject to change in the future based on university policy and business needs.

Advertised Salary

$60,000.00 - 70,000.00 per year based on experience and internal equity within the department.

Benefits Overview

For full-time staff employees, Indiana University offers a wide array of benefits including:

• Comprehensive medical and dental insurance
• Health savings account with generous IU contributions
• Healthcare and dependent care flexible spending accounts
• Basic group life insurance paid by IU
• Voluntary supplemental life, long-term disability, critical illness, and supplemental accidental death & dismemberment insurance
• Base retirement plan with generous IU contributions, subject to vesting
• Voluntary supplemental retirement plan options
• Tuition subsidy for employees and family members taking IU courses
• 10 paid holidays plus a paid winter break each year
• Generous paid time off plans
• Paid leave for new parents and IU-sponsored volunteer events
• Employee assistance program (EAP)

Learn more about our benefits by reviewing the IU Benefit Programs Brochure.

Indiana University is an equal opportunity employer and provider of ADA services and prohibits discrimination in hiring. See Indiana University Notice of Non-Discrimination here which includes contact information.