QA Manager, Reporting Data Analysis
All Care To You
full-time
Posted on:
Location Type: Remote
Location: Remote • California • 🇺🇸 United States
Visit company websiteSalary
💰 $90,000 - $130,000 per year
Job Level
SeniorLead
Tech Stack
AzureSQL
About the role
- Provide a functional manager role for all QA reporting data staff.
- Conduct QA reviews and test work items before user acceptance testing and final approvals by key stakeholders.
- Prioritize work items and requests from key stakeholders.
- Create and update Azure DevOps board tickets to improve reporting automation for manual steps.
- Identify any data quality/process improvement points, and create new or update SQL queries and stored procedures.
- Develop, implement and oversee the use of data analysis and quality assurance tools.
- Establish data quality standards (units, variable names) and develop policies and procedures for higher quality.
- Analyze QA data to identify root causes of quality issues, track metrics, and predict future trends.
- Design and implement data testing procedures, validating datasets and identifying inconsistencies.
- Build and maintain reporting master document for each health plan and report by lines of business.
- Review all currently implemented compliance reporting technical specification documents and report template instructions to ensure current reporting logic and data definitions align with those requirements.
- Review all compliance report output to make sure the data aligns with the templates, all required information is complete, and data is in the correct format for each field.
- Check all compliance reports to confirm all ran on time and without error.
- Run any compliance reports manually ad-hoc as needed.
- Create SOPs and documentation for running each report manually.
- Complete any manual steps to correct or make reports accurate.
- Identifies and corrects corrupt or inaccurate records.
- Drive process improvement of quality across all deliverables.
- Running data queries to identify coding issues and data exceptions, as well as cleaning data.
- Revise our procedures and documentation that govern our internal and external policies and processes.
- Investigate and resolve questions and issues raised by audit activities.
Requirements
- 10+ years’ experience analyzing healthcare data for quality assurance and testing.
- 5+ years’ healthcare administration experience.
- 2+ years’ experience leading and supervising other staff and stakeholders.
- SQL experience required.
- Proficiency writing up SQL queries and stored procedures.
- Proficiency using Azure DevOps, Outlook, Microsoft Teams, Zoom, Microsoft Office (including Word and Excel) and Adobe.
- Demonstrated experience in analytical/problem solving, data visualization/reporting, and strong communication with agile mindset.
- HMO/Medical Group experience preferred.
- EZ-Cap experience preferred.
- Detail oriented and highly organized.
- Strong ability to multi-task, project management, and work in a fast-paced environment.
- Strong ability in problem-solving.
- Ability to self-manage, strong time management skills.
- Ability to work in an extremely confidential environment.
- Strong written and verbal communication skills.
Benefits
- 100% employer paid medical, vision, dental, and life coverage for our employees.
- Additional employee paid coverage options available.
- Paid holidays.
- Birthday off.
- Unlimited PTO.
- 401k plan.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata analysisquality assurancereporting automationdata testing proceduresdata quality standardsdata visualizationproblem solvingdata cleaningcompliance reporting
Soft skills
detail orientedhighly organizedmulti-taskingproject managementstrong communicationself-managementtime managementagile mindsetanalytical thinkingleadership