Healthcare Data Analyst II - Remote

UnitedHealth Group•Eugene, OR

1d•$72,800 - $130,000•Remote

About The Position

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. The Healthcare Data Analyst II will provide support and assistance to patient care teams by developing and maintaining databases, analyzing patient care data and providing reports to management and various patient care providers. The Healthcare Data Analyst II will work closely with staff and management of all levels to provide accurate and timely data and analysis. You’ll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

Requirements

2+ years solving complex problems using SQL and of Snowflake programming language(s)
2+ years as a programmer with extensive experience in SQL, Snowflake, Power BI and Excel reporting
Knowledge of EMR database and reporting
Fully understand EMR database complexity and be able to generate and format accurate reports, which requires the ability to investigate and aggregate data, and analyze resulting information to meet end-user criteria
Familiar with Snowflake and SQL Server Business Intelligence stack (SSRS, SSIS, SSAS, PowerBI and SQL Server)
Excellent report writing and presentation skills, utilizing Power BI, Microsoft SQL Server, Snowflake and other reporting tools
Proven ability to implement and troubleshoot programming changes and modifications
Proven ability to coordinate and conduct tests for system upgrades and quality check results
Proven ability to write and maintain technical and non-technical instructions in the use of programs/reports and/or program/report/ modifications, in addition to presenting results as needed
Proven ability to work with team members to scope, design, test, document, and maintain various applications and related systems, as assigned. Knowledge of customer service standards and procedures

Nice To Haves

EPIC and/or Athena One experience

Responsibilities

Participate in strategic design and maintenance of business intelligence applications
Assist in the evaluation of the use of business intelligence applications to enhance business decision making capabilities
Provide technical training to analysts
Perform reporting and analysis, primarily using SQL and other organizationally supported tools
Coordinate with external vendors and IT department project teams to interface and develop software with existing EMR
Establish datasets to provide meaningful healthcare data for planning, tracking, and identification of success criteria and metrics for various insurance and regulatory projects
Work with cross-functional organizational teams to develop and implement health management programs
Update or create documentation for existing processes and make suggestions for improvements, if needed
Perform reporting and analysis of various data (clinical, operational, quality, and billing healthcare data; utilizing HEDIS and CAHPS survey methodologies, etc.)
Create and run tests to find errors and confirm programs meet specifications. Analyze SQL and Snowflake code to identify causes of errors and revise programs. Analyze performance of queries and reports and take action to correct deficiencies based on consultation with users and approval of manager
Archive and store data for trending and compounded analysis
Assist with implementation of new software and systems (e.g., population health or patient registry software), involving planning, programming, testing, and implementing data conversion and data migration, as required
Refactor non-dynamic SQL code into a dynamic process that is sustainable and readable
Implement error handling for data and ETL processes
Help maintain and support data governance programs
Help the organization build a sustainable ETL process to store historical data and slowly changing dimensions
Maintain a broad knowledge of state-of-the-art technology, equipment, and/or systems
Analyze data and develop business dashboards for managers, providers, and executives
Maintain a high level of customer service with internal and external customers
Represent the goals and values of the organization
Maintain the strictest confidentiality
Perform other duties as assigned