The Sr. Data Analyst role will work within the UnitedHealthcare STARS & Quality team and be responsible for development of world-class data quality, data analysis, and test automation within a continuous delivery lifecycle. You will be accountable for ensuring the proper Quality Assurance controls are adhered to for inbound data, internal analytics and outbound results for customers while ensuring operational excellence.
Primary Responsibilities:- Create and execute test cases within an ETL, data warehouse, and report application environment.
- Responsible for data profiling and system integration testing of ETL, batch processes, reporting deliverables, and user interface applications with an emphasis on data quality.
- Understand and create SQL queries with the ability to troubleshoot issues found in stored procedures and/or customer data. Perform exploratory analysis and queries to identify issues that are not covered by automation.
- Support implementation of software, tools and capabilities to automate system integration testing and continuous delivery / DevOps agenda in a Data Warehouse environment.
- Generate and maintain quality metric reports. Analyze and optimize QA business processes. Monitor and report quality metrics for the UHC STARS & Quality team.
- Collaborate and communicate effectively across teams throughout the QA lifecycle. Share and communicate ideas both verbally and in writing to staff, business sponsors, managers, and technical resources in clear concise language that is appropriate to the target audience.
- Use database statistics and data trending to compare data between deliveries to identify issues.
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:- Bachelor's Degree in Computer Science, engineering or analytics
- 5+ years of experience performing ETL testing and source-to-target validation
- 5+ years of experience writing SQL queries which include aggregate functions, joins, and conditional logic
- 5+ years of experience working with large data volumes (1+ million) performing data profiling, root cause data analysis, and debugging stored procedures or complex SQL queries in Snowflake or similar environment
- 3+ years of experience in a Quality Assurance or Data Quality role within a data warehouse environment
- 1+ years of experience developing or testing front end reporting such as SSRS, Power BI, Tableau, or a similar application
Preferred Qualifications: - 3+ years of experience performing data analysis in a Snowflake environment
- Knowledge of HEDIS and Star Quality Specifications
- Experience within the healthcare industry
- Demonstrated self-motivation and initiative
- Strong verbal and written communication skills
- Experience and proficiency with data quality and QA processes.
*All Telecommuters 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 hourly pay for this role will range from $91,700 to $163,700 per hour based on full-time employment. We comply with all minimum wage laws as applicable.
Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.
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.