Data Analyst

Summary

Indiana University is one of the first human genetics departments in the country, specializing in genetics and genomics. They are seeking a Data Analyst to develop and maintain software solutions, support data workflows, and ensure the integrity of research data.

Responsibilities

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

Skills

• Bachelor's degree (preferably in computer science, information science, or related field)
• 2 years of data analysis, reporting, or related experience
• 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
• 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
• 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

Qualifications

Must Haves

• Bachelor's degree (preferably in computer science, information science, or related field)
• 2 years of data analysis, reporting, or related experience
• 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

Nice to Haves

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

Benefits

• 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)