Jobs › Medical College of Wisconsin

This position has closed. Medical College of Wisconsin removed this listing from their careers page on Oct 6, 2026. The interview prep below is still useful, and there are similar open roles at the bottom of this page.

Business Analyst III, CTSI Data Warehouse

Medical College of Wisconsin · Milwaukee, WI · Full time

Posted Aug 18, 2026 · We last checked this listing on Oct 4, 2026

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a time you bridged a gap between researchers and technical staff.

What they are checking: Liaison skills, which the posting describes as central to the job.

Tell me about a project you managed with many stakeholders and a tight timeline.

What they are checking: Project management at moderate to high complexity, including on enterprise-wide initiatives.

What would you do

A sponsor needs a feasibility answer in two days, but the data is messy. What do you do?

What they are checking: Balancing speed with honesty about limitations when trial start-up times matter.

How would you design an intake process for research informatics requests?

What they are checking: Process thinking that reduces back-and-forth and speeds up clinical trial initiation.

A researcher is frustrated because the tool keeps giving different counts than they expect. How do you handle it?

What they are checking: Patient troubleshooting and clear explanation of data differences without getting defensive.

About the work

An investigator asks how many patients at Froedtert match their trial criteria. How do you turn that into a computable phenotype?

What they are checking: Ability to translate eligibility criteria into codes, labs and logic that the data can actually answer.

How do you validate that a phenotype is finding the right patients?

What they are checking: Understanding of chart review, precision and recall, and why unvalidated counts mislead sponsors.

What do you know about tools like i2b2, TriNetX or OMOP, and how have you used them?

What they are checking: Familiarity with standard research informatics platforms used for cohort discovery.

How do you make sure a data request is covered by the right IRB approval before you release anything?

What they are checking: Compliance awareness, since the role ensures IRB compliance for research data access.

How do you document a phenotype so someone else can reuse it next year?

What they are checking: Commitment to reusable, well-documented work, which the posting emphasizes.

Practice this interview out loud.

Offer builds a real interview for this exact role at Medical College of Wisconsin from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Medical College of Wisconsin.

Summary Plays a key role in optimizing clinical trial initiation times across the institution. Leads a full range of activities that ensure access to and compliant, effective use of research informatics systems to support a wide variety of research use cases. Guides the design, documentation, testing, implementation, and evaluation of reusable computable phenotypes for clinical trial feasibility and cohort discovery using standardized research informatics systems and workflows to improve institutional efficiencies and optimize resources. Primary Responsibilities • Translates sponsor and/or investigator project requirements into actionable knowledge • Acts as liaison between research teams and biomedical informatics staff to curate reuseable computable phenotypes to ensure clinical trial feasibility requirements and turnaround times are met. • Works closely with research stakeholders to evaluate clinical trial requirements, ensure IRB compliance, and make timely decisions on project feasibility. • Coordinates intake for research informatics systems access, user experience troubleshooting, and other day to day activities within the department to ensure optimal uptake and use of research informatics tools. • Manages projects/tasks of any scale with moderate to high complexity while representing the department on larger enterprise-wide project initiatives as needed. • Monitors process efficiency metrics to support specific institutional goals. • Provides team updates regularly to review project deliverables and deadlines. • Shares expertise regarding the various trial feasibility techniques used to elicit, analyze and deliver requirements across a wide variety of clinical research areas. • Participates in research informatics systems upgrade/conversion testing. • Leads end-user training and support. • Recommends solutions to meet research core business needs and coordinates the planning, development, and implementation of these solutions. Knowledge – Skills – Abilities • Knowledge of computers, web-based user interfaces, health care data, clinical research databases, clinical trial recruitment, IRB and HIPAA compliance, and data security. • Customer support, systems analysis, troubleshooting, problem solving, and listening skills. Qualifications Appropriate experience may be substituted for education on an equivalent basis. Minimum Required Education: Bachelor’s degree Minimum Required Experience: 5 years in clinical research and/or healthcare Preferred Experience: i2b2 and/or TriNetX; Epic Clarity, Caboodle, Cosmos and/or SlicerDicer; Healthcare revenue cycle operations; Clinical trials feasibility/operations; Medical terminology Required Certification/Licensure(s): Preferred Certification / Licensure(s): CCRC, Medical Coding Certification #LI-FL1 Physical Requirements Work requires occasionally lifting moderate weight materials, standing, or walking continuously. Work Environment Occasional exposure to dust, noise, temperature changes, or contact with water or other liquids. Work is performed in an environmentally controlled environment. Sensory Acuity Ability to detect and translate speech or other communication required. May occasionally require the ability to distinguish colors and perceive relative distances between objects. Why MCW? • Outstanding Healthcare Coverage, including but not limited to Health, Vision, and Dental. Along with Flexible Spending options • 403B Retirement Package • Competitive Vacation and Paid Holidays offered • Tuition Reimbursement • Paid Parental Leave • Employee & Family Assistance Program (EFAP) • Pet Insurance • On campus Fitness Facility, offering onsite classes • Additional discounted rates on items such as: Select cell phone plans, local fitness facilities, Milwaukee recreation and entertainment etc. For a brief overview of our benefits see: Benefits Overview For a full list of positions see: MCW Careers At MCW all of our endeavors, from our internal operations to our interactions with our partners, are driven by our shared organizational values: Caring – Collaborative – Curiosity – Inclusive – Integrity – Respect. We are committed to fostering an inclusive environment that values diversity in backgrounds, experiences, and perspectives through merit-based processes and in alignment with all applicable laws. We believe that embracing human differences is critical to realize our vision of a healthier world, and we recognize that a healthy and thriving community starts from within. Our values define who we are, what we stand for and how we conduct ourselves at MCW. If you believe in embracing individuality and working together according to these principles to improve health for all, then MCW is the place for you. For more information, please visit our institutional website . MCW as an Equal Opportunity Employer and Commitment to Non-Discrimination: The Medical College of Wisconsin (MCW) is an Equal Opportunity Employer. We are committed to fostering an inclusive community of outstanding faculty, staff, and students, as well as ensuring equal educational opportunity, employment, and access to services, programs, and activities, without regard to an individual's race, color, national origin, religion, age, disability, sex, gender identity/expression, sexual orientation, marital status, pregnancy, predisposing genetic characteristic, or military status. Employees, students, applicants or other members of the MCW community (including but not limited to vendors, visitors, and guests) may not be subjected to harassment that is prohibited by law or treated adversely or retaliated against based upon a protected characteristic.