Data Consultant II

ARUP Laboratories; Salt Lake City (UT); On-site; USD 65,000 - 95,000; Full time

Job summary

ARUP Laboratories in Salt Lake City is seeking a data analytics professional to translate client information needs into technical solutions. You will perform complex analyses on large clinical and financial data, support building dashboards and reports, and help optimize analytics processes.

Work with cross-functional teams on data governance, ETL, and data visualization using SQL Server, SSIS, Tableau, Python, and R.

Qualifications

• Requires ability to analyze large clinical and financial datasets.
• Experience designing and maintaining analytical processes.
• Familiarity with healthcare data concepts and confidentiality.

Responsibilities

• Translate client and user information needs into technical data solutions.
• Develop, implement, and maintain analytics reports and dashboards.
• Collaborate with clients and project teams to define analytical requirements.
• Oversee data gathering, transformation, and quality across databases.

Skills

Data analysis

SQL

Tableau

Python

R

JMP

Healthcare data

Tools

SQL Server

SSIS

Tableau

Python

R

Job description

Schedule

Monday – Friday (40 hrs/wk)

8:00 AM - 5:00 PM

Department

Customer Experience Product Team - 934

Primary Purpose

Assists in translating the client’s and user's information needs into technical solutions maximizing the use of technology while ensuring clear business benefits. Performs complex data analyses on large data files containing clinical and financial data. Supports designing, developing, implementing, and maintaining business solutions to optimize analytical processes and outcomes. Aids in the development of streamlined techniques for providing timely information resulting in improved client offerings and business development. Independently interprets results using a variety of techniques, ranging from simple data aggregation to complex data mining and statistical analysis. Works with clients, internal and external consultants, and project and business leaders to identify analytical requirements.

About ARUP

ARUP Laboratories is a national clinical and anatomic pathology reference laboratory and an enterprise of the University of Utah and its Department of Pathology. Based in Salt Lake City, Utah.

ARUP proudly hires top talent to create a work environment of diversity, professional growth and continuous development. Our workforce is committed to the important service we provide to over one million patients each month. We always strive for excellence and have a strong desire to have involvement with the advances in medicine and the role laboratory services plays within each patient’s life. We never forget that there is a patient behind every specimen we receive.

We are looking for individuals who want to contribute to ARUP's culture of accountability, integrity, service, and excellence. Consider joining our dynamic team.

Essential Functions

• Reviews, analyzes, and evaluates information needs and efficiency opportunities then creates, via technology-based applications, the reports, interfaces, and processes necessary to supply those needs and produce those efficiencies based on business needs and direction of clients and management.
• Oversees the quality and consistency of data gathering, transforming, reporting, and analysis.
• Support and manage respective data in multiple databases

Support And Manage

• Dashboards created as a product of Healthcare Advisory Services offerings
• Programs to automate the production of solutions for scalability
• Analysis templates
• Supports the processes, tools, security, and quality around client projects and business information systems.

Maintain Scalable User-friendly Solutions And Other Processes Using

• Relational databases in Microsoft SQL Server
• ETL processes with SSIS
• Tableau
• VBA, python, or other programming language
• Statistics using JMP, R, Anaconda, or other statistical analysis programs and packages
• Data architecture knowledge
• Healthcare software and data knowledge
• Interaction with clients through conference calls, web conferencing, and offsite or onsite meetings
• Actively seeks opportunities to advance their software knowledge, data manipulation, and understanding of the healthcare industry.
• Selection of and travel to meaningful conferences to advance skills in analytics and knowledge in healthcare software and data complexities.
• Other duties as assigned.

Physical And Other Requirements

• Stooping: Bending body downward and forward by bending spine at the waist.
• Reaching: Extending hand(s) and arm(s) in any direction.
• Mobility: The person in this position needs to occasionally move between work sites and inside the office to access file cabinets, office machinery, etc.
• Communicate: Frequently and effectively communicate with others.
• PPE: Biohazard laboratory environment that requires use of personal protective equipment in accordance with CDC and OSHA regulations and company policies.
• ARUP Policies and Procedures: To conduct self in compliance with all ARUP Policies and Procedures.
• Authorized to Work: Must be a citizen of the United States or authorized to work in the United States.
• Sedentary Work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
• Vision: Having close, far, and peripheral visual acuity to perform a variety of tasks such as make general observations of depth and distance.
• Fine Motor Control: Picking, pinching, typing or otherwise working, primarily with fingers rather than with the whole hand as in handling.
• Hearing: Perceiving the nature of sounds at normal speaking levels with or without correction. Ability to receive detailed information through oral communication, and to make the discriminations in sound.