Business Intelligence Analyst - Entry Level

Ohsu Portland , OR 97228

Posted 1 week ago

Department Overview

New hires eligable for up to $5,000 Sign on bonus

This position is part of Cascade Life Alliance, the region's Organ Procurement Organization.

Our mission is to save, enhance, and heal lives through organ donation and transplantation.

The Entry-Level Business Intelligence Analyst reports to the Business Intelligence Manager.

They are responsible for maintaining and distributing vital remote-use technology and equipment including, at a minimum, mobile printers, tablets, and laptops. This position will triage equipment failures and communicate with external parties including the United Network for Organ Sharing (UNOS) and the OHSU ITG department.

The assist in fulfilling the organization's mission by maintaining front-end Business Intelligence assets that are designed to serve the needs of the organization as well as local donation partners. They will occasionally be responsible for maintaining or upgrading performance of these assets as assigned by the Business Intelligence Manager. The position supports the organization by assisting with projects designed to continuously improve how available data informs training, data quality, and staff education needs.

They assist in maintaining employee access to several electronic platforms utilized by Cascade Life Alliance as well as by local donor hospitals.

Function/Duties of Position

  • Business Intelligence: Supports maintenance of the production database, the organ donor EMR replication database, and UNOS data systems using SSIS/ETL procedures and SQL. Uses various types of Business Intelligence software including, but not limited to, Tableau, Power BI, Crystal Reports, and SSRS. Assists in development of plans for emergency situations including testing, downtime, data breaches, and recovery activities/strategies of the database.

  • Programming: Gathers data into observations that help drive improvement initiatives through visualizations, KPIs, and education. Uses soft skills, analytical thinking, and database knowledge to inform Cascade Life Alliance leadership's data and mission goals. Programming responsibilities include logging new BI report requests, maintaining existing BI reports, and educating staff in other departments on the functions of user-friendly reports.

  • Security & System Administration: Assists in maintaining Cascade Life Alliance employees' access to the organ donor EMR and UNOS national organ allocation systems. May assist in granting and maintaining employee access to donor hospital EMRs. Troubleshoots electronic system errors encountered by Cascade Life Alliance staff during organ donor cases, as assigned by manager. Facilitates use and analysis of electronic assets, including tracking, usage statistics, license renewals, lost/stolen property procedures, asset leasing/returns, and long-term implementation planning.

  • Data Governance: Promotes data quality and governance. Educates staff on BI report request alignment with the Cascade Life Alliance mission as defined by manager. Collaborates with Quality Assurance (QA) to identify and assist in identifying documentation errors and inconsistencies. Collaborates with QA to uphold data governance as expected by Centers for Medicare & Medicaid Services (CMS), the Association of Organ Procurement Organizations (AOPO) and UNOS. Assists in retrieving data requested during surveys conducted by regulatory agencies.

  • Other Responsibilities: Assists in ensuring Cascade Life Alliance's adherence to regulatory reporting requirements pertaining to verification and submission of donor and referral data. May compile data and generate reports as needed for the Cascade Life Alliance Advisory Board, the Cascade Life Alliance Medical Advisory Committee, OHSU Central Financial Services, hospital teams across the donor service area, and other entities as requested by manager.

Required Qualifications

  • Bachelor's degree in computer science, a related field, or a clinical field and one year work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

  • Associate's degree in computer science, a related field, or a clinical field and two years' work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

  • Three years' work related experience in the information technology field or a combination of clinical or operational healthcare environments; OR

  • Equivalent combination of education and experience where one year of experience will be substituted for an Associate's degree and two years of experience will be substituted for a Bachelor's degree.

  • Experience using large relational databases;

  • Ability to query database using SQL or similar language.

  • Motivation to support a culture-oriented and team-based environment

  • Exceptional customer service skills

  • Experience using Business Intelligence software

  • Advanced skills in troubleshooting electronic equipment issues

  • Strong written and verbal communication skills, including the ability to read and communicate contents of a data model

Preferred Qualifications

  • Two years' experience with large relational databases

  • Two years' experience with T-SQL coding and tuning

  • Two years' experience with front-end reporting

  • Exposure to SSIS (or equivalent) development and management

  • Experience with Power BI, Epic Analytics, Business Objects, SSRS, and Tableau

  • Strong interpersonal skills involving delivery of delicate information

  • Experience communicating with regulatory agencies

Additional Details

  • This on-site position requires the ability to work a minimum of 40 hours per week in the Cascade Life Alliance office.

  • May include rare contact with human organs/tissue/blood.

  • Requires extended periods of time doing office-type work such as working with computer, keyboard, phone, and paper documents.

  • Requires the ability to physically install electronic equipment in various office settings.

All are welcome

Oregon Health & Science University values a diverse and culturally competent workforce. We are proud of our commitment to being an equal opportunity, affirmative action organization that does not discriminate against applicants on the basis of any protected class status, including disability status and protected veteran status. Individuals with diverse backgrounds and those who promote diversity and a culture of inclusion are encouraged to apply. To request reasonable accommodation contact the Affirmative Action and Equal Opportunity Department at 503-494-5148 or As an organization devoted to the health and well-being of people in Oregon and beyond, OHSU requires its employees to be fully vaccinated against COVID-19.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Analyst Customer Experience (Remote Option)

Unum Group

Posted 7 days ago

VIEW JOBS 11/21/2022 12:00:00 AM 2023-02-19T00:00 <p>Job Posting End Date: December 14</p><p>Unum is a company of people serving people. As one of the world's leading employee benefits providers and a Fortune 500 company, Unum's financial protection benefits help protect more than 36 million working people and their families from the financial impact of illness or injury. Unum's two distinct, but similarly focused US businesses - Unum US and Colonial Life - are each a market leader in making disability, life, accident, critical illness, dental, and vision insurance accessible in the workplace. Headquartered in Chattanooga, Tennessee, Unum also has significant US operations in Portland, Maine and Baton Rouge, Louisiana - and over 35 field offices nationwide. Colonial Life is headquartered in Columbia, South Carolina with over 40 field offices nationwide.</p><p>General Summary:</p><p>The Customer Experience Business Intelligence Analyst is responsible for simple to moderately complex data analysis, preparation and visualization. This role works within the Customer Experience Team with a mission to equip and rally Unum with actionable insights. They will use their technical and domain expertise to translate data into meaningful insights for teams and leaders to confidently take action on. The ideal candidate will be passionate about all things data and we seek a creative and analytical thinker to help us solve our most challenging problems. This position will represent the CX Team in working with Business Analysts, BI Analysts, Data Scientists, Data Engineers and directly with the business units for requirements gathering and validation.</p><p>There is flexibility in the opening, and we are evaluating individuals from entry to experienced levels.</p><p>Principal Duties and Responsibilities</p><ul><li><p>Conduct data profiling and analysis to evaluate data sources to determine the best source for business information</p></li><li><p>Acquiring, transforming and translating data into actionable dashboards, reports, algorithms or datasets with minimal support from mentor and manager</p></li><li><p>Performing statistical analysis and presenting findings to guide and advise leadership</p></li><li><p>Collaborate with data engineers to perform data validation and testing activities as appropriate</p></li><li><p>Continuously develop and build upon existing knowledge of the insurance industry</p></li><li><p>Continuously develop and build upon existing knowledge of data stored in company databases</p></li><li><p>Works directly with internal customers to refine requirements and validate output to ensure solutions will meet expectations</p></li></ul><p>Job Specifications</p><ul><li><p>Bachelors Degree preferred, and/or equivalent experience</p></li><li><p>2+ years experience with demonstrated success at an Associate level in a data analytics related field</p></li><li><p>Knowledge of analytics programming languages (SQL/R/Python)</p></li><li><p>Experience with modern BI toolsets (Tableau, Alteryx, PowerBI, or equivalent)</p></li><li><p>Understanding of data profiling, statistical analysis and data modeling concepts</p></li><li><p>Comfortable extracting and leveraging data out of data warehouse, transactional databases, object stores &amp; API based environments</p></li><li><p>Demonstrated ability to translate business needs into technical solutions</p></li><li><p>Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results</p></li><li><p>Demonstrated problem solving skills</p></li><li><p>Strong communications skills</p></li><li><p>Aptitude and drive to learn new technologies and analysis techniques</p></li><li><p>Strong team player; able to work effectively within a team and more broadly with people from a variety of backgrounds and areas across the organization.</p></li></ul><p>Our company is built on helping individuals and families, and this starts with our employees. We want employees to maintain a positive balance, which is why we provide access to the benefits and resources they need to invest in themselves. From our onsite fitness facilities and generous paid time off to employee professional development programs, we are committed to helping employees live and work their best - both inside and outside the office.</p><p>Unum is an equal opportunity employer, considering all qualified applicants and employees for hiring, placement, and advancement, without regard to a person's race, color, religion, national origin, age, genetic information, military status, gender, sexual orientation, gender identity or expression, disability, or protected veteran status.</p><p>Company:</p><p>Unum</p><p>In accordance with Colorado's Equal Pay For Equal Work Act, if you are a resident of the state of Colorado and wish to review the salary information for a role posted in Colorado, please fill out the form below and our Unum HR representative will reply to your inquiry within three business days.</p><p>Colorado's Equal Pay For Equal Work Act</p><p>In accordance with New York City Human Rights Law, if you wish to review the salary information for a role posted in New York City, please fill out this form and our Unum HR representative will reply to your inquiry within three business days.</p><p>New York City Human Rights Law</p><br> Unum Group Portland ME

Business Intelligence Analyst - Entry Level