Healthcare Data Analyst II - Remote

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.

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 You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

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