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.
Primary 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
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.
Required Qualifications:- 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
Preferred Qualification:- EPIC and/or Athena One experience
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy
Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $72,800 - $130,000 annually based on full-time employment. We comply with all minimum wage laws as applicable.
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
