Data Analyst & Developer - Remote

About the Role

Key Responsibilities

• Partners with business teams to gain a thorough understanding of data requirements and expertly navigates complex datasets to define data relationships and lineage
• Conducts deep analysis of data sources and the data/system landscape related to medical claims and adjacent member, clinical, or financial domains
• Provides expert data quality and data review services, ensuring the reliability and accuracy of UHC's integrated healthcare data warehouse, reports, and analytical solutions
• Strategically develops and executes end-to-end data quality testing, crafting comprehensive test scenarios and testing strategies
• Architects, develops, and implements scalable automated testing frameworks to enhance testing efficiency and coverage
• Analyzes test results with a focus on business impact and established quality standards, identifying critical issues and recommending effective solutions
• Leverages analytical skills to proactively identify data anomalies and defects, performing in-depth root cause analysis to improve overall data quality
• Conducts thorough data quality audits, ensuring strict compliance with regulatory requirements such as HIPAA
• Designs, develops, and implements cutting-edge automated testing frameworks and solutions, adhering to enterprise standards and operational best practices
• Articulates technical data quality findings and recommendations clearly and concisely to diverse audiences, including customers and leadership
• Transforms intricate data quality concepts into easily understandable and actionable insights
• Mentors and guides junior quality analysts, promoting knowledge sharing and professional growth within the team

Requirements

• 3+ years of data analysis, quality assurance, or reporting experience
• Experience and ability to work well in a fast-paced environment
• Experience with Snowflake or Azure cloud data warehouse technologies
• Experience in designing, developing, and executing automated test scripts for data validation and quality assurance
• Snowflake testing experience
• Familiarity with data movement processes and ETL development lifecycle methodologies
• Intermediate or advanced SQL skills (Snowflake, Oracle, SQL Server, ANSI SQL)
• Proficiency in SQL with a solid understanding of complex queries, SQL joins, subqueries, and troubleshooting complex SQL code
• Experience developing end-to-end ETL/ELT pipelines using Azure Data Factory across Azure and hybrid cloud ecosystems
• Statistical analysis skills

Nice to Have

• Healthcare industry or data experience (claims, clinical, calls outreach data)
• Tableau, Power BI, and/or data visualization experience
• Experience with Agile methodology
• Experience with Python, DevOps, CI/CD tools, Git, especially in cloud environments
• Familiarity with data warehouse concepts
• Basic understanding of data science concepts and their use in solutions
• Proven team-oriented, communicative, and proactive attitude

Qualifications

• Formal educational background is implied through experience, but specific qualifications are not explicitly listed

Benefits & Perks

• Competitive salary range of $71,600 to $140,600 annually based on full-time employment
• Comprehensive benefits package
• Incentive and recognition programs
• Equity stock purchase
• 401k contribution
• Various other benefits and incentives subject to eligibility