Data Analyst/ETL Support

About Us
The primary aim of the Clinical Informatics Shared Services (CISS) is to provide state-of-the-art centralized clinical informatics services for the support of Masonic Cancer Center operations, research, and quality of care improvement effort. As a member of this staff, the successful candidate will have the following responsibilities:

Principle Duties

Informatics Infrastructure and Report Support: Maintain and enhance existing code, process, and infrastructure

• Maintain and support existing ETL code by identifying the issue and reporting to Senior developers or handling it per outlined process or direction.
  • This also requires off hours support.
• Develop documentation to show dependencies within our Oncology business layer and also create support documentation.
• Design and Develop SSRS reports for automation.
• Maintain and support existing databases by leading the upgrade efforts, answering user specific questions, communicating with vendors etc.
• Be the first point of contact for any issues related to the database(s) and ensure that their questions are answered in a timely manner.
• Become a subject matter expert in data and tools to efficiently support any data mapping efforts needed by other team members for dashboards etc.
• Advocate best practice policies and procedures for data handling.
• Identify and assess performance tuning opportunities.
• Create data dictionary and document dependencies by reverse engineering from existing code and data.

Technical: Extract, integrate, format, and deliver data as per project needs

• Run feasibility analysis to ensure project requirements can be processed through offered informatics services.
• Assess raw data/primary data availability and quality. Work with users to transfer raw data into required format for project purpose.
• Query, extract, integrate, format, deliver and analyze data as per project needs.
• Explore and investigate various ways of identifying patients when data elements are not clear or available. Propose alternatives to users and clarify key points of each alternative.
• Work closely with other team members to review execution plans and request support.
• Continually seek to improve knowledge of new clinical databases.
• Identify informatics infrastructure enhancement opportunities that could benefit the larger research community.
• Extract and/or create reports needed for departmental Operations or Regulatory needs (such as FDA reporting or Industry sponsor reporting etc.,)

Informatics Consultation: Ensure that all informatics Services follow team and university policies and operating procedures

• Create consultation reports that capture project requirements and your implementation plan. Update the report as per continuous communication with investigators.
• Capture requirements for various types of projects (research, quality and operational projects, study recruitment, etc.).
• Ensure that all informatics activities meet various compliance standards, IRB, data security, and contractual obligations of the University of Minnesota.
• Follow operating procedures, forms, and policies of the team. Discuss enhancement opportunities with team management.
• Strive for best quality of service experience and excellent user satisfaction feedback.
• Follow-up with investigators and staff to ensure delivered services meet users' expectations. Assist with refinements when requested.
• Train users on data access methods, analysis tools, and informatics infrastructure.

Communication: Work with investigators, research personnel and other stakeholders to promote informatics services and represent the team.

• Keep investigators and staff informed on offered CTSI Informatics services.
• Coordinate user testing/usability evaluation of offered services and capture needs for potential future enhancements.
• Ensure service delivery progress concerns, delays and issues are regularly communicated with team management.
• Represent the team in various meetings, such as: IRB, Office of Compliance, Data Stewards, Research Committees, and technical Infrastructure.
• Communicate with data stewards from different organizations to most effectively deliver data as per project requirements.
• Initiate regular user group meeting to discuss departmental needs.
• Attend vendor based conferences or meetings at times to better support databases.
• Work as a liaison between the team and other units on selected informatics components and databases, recommend standardized data collection process for automatic data extraction, provide requirements for automation etc.

Work location: Hybrid with onsite location on the Twin Cities campus in Minneapolis, MN.

Salary: $70,000 - $75,000, commensurate with experience

Qualifications

All required qualifications must be documented on application materials.

Required Qualifications

• BA/BS and 5+ years of relevant analytical or quantitative work experience, or an advanced degree with a minimum of 4 years of experience in areas directly related to the position.
• Experience must include a minimum of three years ETL support (willingness to do off hours support).
• Proficiency in SQL with demonstrated query development using MS SQL Server, T-SQL programming using cursors, dynamic sql, server connectivity, PL/SQL and Oracle tools etc.
• Experience in report writing using SSRS (SQL Server Reporting).
• Good understanding of relational database modeling and access management and experience working with MS Access.
• Experience in creating technical documentation to show dependencies within ETL code.
• Experience working with healthcare data.

Preferred Qualifications

• Knowledge of working with Snowflake data model is highly preferred.
• Knowledge of working with Oncore or Clinical Trial Management System.
• Experience querying, extracting, formatting, and analyzing healthcare research data for Operational reporting, etc.
• Knowledge of clinical trials, research and operations.
• Experience working with research lab data and Biospecimens.
• Experience working with version control tool like Tortoise SVN.
• Knowledge of healthcare data management concepts and regulatory/compliance policies (HIPAA, IRB, etc.).
• Knowledge of clinical data and healthcare code sets (ICD9/ICD10, NDC/RXNorm, LOINC, etc.).
• Strong customer-facing experience, preferably with Clinical Trials office leaders, study team supporting trials, investigators, faculty/academic and research support staff.
• Skills in data visualization.
• Research experience in statistics, data science or related fields is a plus.
• Experience with basic machine learning or statistical analysis using R, Matlab, or Python is a plus.
• Comfortable following directions/instructions from supervisors and senior staff.
• Superior human relation skills, such as, the ability to use positive language communications to serve and influence our customers and stakeholders, work well with the team.
• Ability to support multiple projects simultaneously, Prioritize assignments and work under limited supervision.
• Experience working with messy real-world data.
• Comfortable providing rapid and timely response to urgent requests that impact clients.

About the Department

The University of Minnesota Clinical and Translational Science Institute (CTSI) mission is to accelerate and improve clinical and translational science research, education and improve health. CTSI provides consultation, training, support, and services to researchers and research teams across the translational continuum. CTSI is part of the national, NIH-funded Clinical Translational Science Award (CTSA) program/consortium that works together to improve the efficiency, quality, and impact of clinical and translational research and science.

Benefits

Working at the University

At the University of Minnesota, you'll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work.

The University also offers a comprehensive benefits package that includes:

• Competitive wages, paid holidays, and generous time off
• Continuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit Program
• Low-cost medical, dental, and pharmacy plans
• Healthcare and dependent care flexible spending accounts
• University HSA contributions
• Disability and employer-paid life insurance
• Employee wellbeing program
• Excellent retirement plans with employer contribution
• Public Service Loan Forgiveness (PSLF) opportunity
• Financial counseling services
• Employee Assistance Program with eight sessions of counseling at no cost

Please visit the Office of Human Resources website for more information regarding benefits.

How To Apply

Applications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.

Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.

To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.

Diversity

The University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.

The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.edu

Employment Requirements

Any offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.

About the U of M

The University of Minnesota, Twin Cities (UMTC)

The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.

At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America’s Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).