Data Consultant II

Schedule:Monday – Friday (40 hrs/wk)8:00 AM - 5:00 PMDepartment: Customer Experience Product Team - 934Primary 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 offeringsPrograms to automate the production of solutions for scalabilityAnalysis templatesSupports 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 ServerETL processes with SSIS TableauVBA, python, or other programming languageStatistics using JMP, R, Anaconda, or other statistical analysis programs and packagesData architecture knowledgeHealthcare software and data knowledgeInteraction with clients through conference calls, web conferencing, and offsite or onsite meetingsActively 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.QualificationsEDUCATIONAssociates Degree or better in Computer Science or related fieldBachelor's Degree or better in Computer Science or related fieldEXPERIENCEBachelor's degree in computer science, mathematics, engineering, or related field Or Associates degree and 2 years of applicable work experienceOne year SQL experience in one or more database management programs (Microsoft, Oracle, etc.)Advanced experience in Excel to include Pivot tables, add-ins, and function library familiarityOne year data integration experience (ETL) One year experience in programming language such as VBA or pythonOne year experience in data presentation (Tableau, PowerBI, SSRS)Experience in healthcare and expertise in the related variety of IT applications, concepts, practices, and procedures. (Epic, Cerner) Experience in using statistics to solve business problems using JMP, R, Anaconda, or other softwareJob SummaryRequisition Number: DATAC022760Job Category: ProfessionalSchedule: Full-Time