Company Overview:
We are a leading healthcare technology company dedicated to improving patient care through innovative solutions. Our team focuses on ensuring accurate and efficient processing of revenue transaction reports from Electronic Health Record (EHR) systems. We are seeking a meticulous Quality Assurance Specialist to join our team and ensure the integrity of our data ingestion processes.
Job Summary:
The Quality Assurance Specialist will be responsible for validating the accurate ingestion of revenue transaction reports from various EHR systems into our financial databases. The ideal candidate will have a strong background in quality assurance, data analysis, and a solid understanding of EHR systems and healthcare revenue cycles. Proficiency in Microsoft Excel and strong mathematical abilities are essential for analyzing complex financial data.
Key Responsibilities:
-
Data Verification: Validate that revenue transaction reports are accurately ingested from EHR systems. Perform detailed data comparisons between source EHR data and ingested data using Excel and other analytical tools.
-
Quality Assurance Testing: Develop and execute test plans, test cases, and test scripts for data ingestion processes. Utilize Excel's advanced functions to analyze data sets and identify discrepancies. Identify, document, and track data discrepancies and defects.
-
Mathematical Analysis: Apply basic mathematical principles to assess data accuracy and financial calculations. Ensure numerical data integrity in financial reports and transactions.
-
Process Improvement: Collaborate with the development team to improve data ingestion processes. Recommend enhancements to QA methodologies and tools.
-
Documentation: Maintain comprehensive documentation of QA activities, test results, data mappings, and mathematical calculations. Prepare reports summarizing QA findings and present them to stakeholders.
-
Cross-Functional Collaboration: Work closely with IT, finance, and operations teams to ensure data integrity. Participate in meetings to discuss QA results and coordinate remediation efforts.
-
Compliance and Standards: Ensure all data handling complies with HIPAA and other regulatory requirements. Stay updated on industry best practices related to data quality and EHR systems.
Qualifications:
-
Education: Bachelor’s degree in Information Systems, Computer Science, Mathematics, Healthcare Informatics, or related field.
-
Experience: Minimum of 3 years of experience in quality assurance or data analysis. Familiarity with healthcare revenue cycle and financial reporting.
-
Technical Skills: Proficiency in Microsoft Excel, including advanced functions like VLOOKUP, pivot tables, macros, and data analysis tools. Strong mathematical and analytical skills to handle financial data. Proficiency in SQL and ability to write complex queries for data validation. Experience with QA tools and methodologies
-
Soft Skills: Excellent analytical and problem-solving abilities. Strong attention to detail and organizational skills. Effective communication skills, both verbal and written. Ability to work independently and as part of a team.
Preferred Qualifications:
-
Advanced proficiency in Microsoft Excel, including experience with complex data modeling and automation.
- Experience with data visualization tools (e.g., Tableau, Power BI).
- Mathematical or statistical background.
- Understanding of healthcare compliance standards and regulations.
- Experience with automated testing frameworks.
- Experience working with EHR systems (e.g., Epic, Cerner, Allscripts).
We are an equal opportunity employer. We are committed to providing equal employment opportunities regardless of sex, gender identity, race, religious creed, color, ancestry, age, disability, marital status, sexual orientation including being transgender and/or any other protected bases.
