skip to main content

Important Notice

It appears you are using an older version of your browser. While some functions will be available, IllinoisJobLink.com works best with a modern browser such as the ones provided by:

Please download and install the latest version of the browser of your choice. We apologize for any inconvenience.



Quality Assurance Engineer

Click the Facebook, Google+ or LinkedIn icons to share this job with your friends or contacts. Click the Twitter icon to tweet this job to your followers. Click the link button to view the URL of the job, which then can be copied and pasted into an e-mail or other document.

Job Details
Job Order Number
6849780
Company Name
Vizient, Inc.
Physical Address
5250 Old Orchard Road, Suite 700
Skokie, IL 60077
Job Description

Perform validation of data quality relative to algorithms and complex comparative analytics using healthcare data from various sources. Test the application of business rules and logic to online product analytics portal. Create and maintain automation test suite in Visual Studio – Selenium, NUnit, SpecFlow, Gherkin and Cucumber to write business readable test automation scripts for testing validated via the front end of applications. Identify and implement opportunities to enhance and improve data quality. Design test plans, scenarios, scripts and testing procedures. Document software and data defects and report defects to impacted business members. Automate manual data calculations in Microsoft Excel into Macros – VBA. Evaluate complex data from both external and internal sources. Understand and build complex relational databases, architecture, ETLs and SSIS workflows. Utilize knowledge of SQL and .Net to create test scripts in Visual Studio and Microsoft SQL Server Management Studio (SSMS) to implement data quality improvement efforts that have been identified as valuable to overall testing effort and data quality outcomes. Create and maintain Alteryx workflows using Alteryx Designer and maintain Data-Depot Alteryx Gallery using Artisan privileges. Stay current and maintain thorough knowledge of both commercial and medicare claims data and regulations from multiple sources including CMS (Centers for Medicare & Medicaid Services), OptumInsight, Health Intelligence Company, LLC and IQVIA. Design and create re-usable components for testing which ensures that code is not duplicated or redundant and follow reusability concepts like Object Oriented Programming and design methodologies. Maintain and improve Continuous Integration (CI)/ Continuous Delivery workflows by creating and executing robust automated functional tests using GitHub, Team Foundation Server (TFS) and Microsoft Release Management which ensures that application is tested before deploying automatically to testing and production environments. Understand healthcare regulations and classification systems including Current Procedural Terminology (CPT) changes, International Classification of Diseases (ICD-9 & ICD-10), and Inpatient Diagnosis Related Group (DRG) to apply this knowledge to business rules and testing outcomes. Ensure that all data and information adhere to specific government regulations, including HIPAA (Health Insurance Portability and Accountability Act of 1996 from US Department of Health and Human Services) and HITECH Act (Health Information Technology for Economic and Clinical Health of 2009), specifically relating to ensuring privacy and secure concerns as defined under Subtitle D of HITECH Act by having a thorough understanding of these regulations. Utilize knowledge of encryption and decryption techniques to ensure that PHI (Patient Health Information) is stored and retrieved securely and ensure that data is accessible to authorized users only by performing security validation. In connection with above duties, utilize experience in performing functional, database and SAP front-end testing including writing test scripts, execution planning, test script execution and reporting defects using Microsoft Test Manager and JIRA; performing web-based testing and development experience using HTML, XML and JavaScript; managing Extract, Transform, Load (ETL) instance automation run using Control-M Enterprise Logon; troubleshooting, resolving and escalating Cloud-data and Dev-Ops related issues and validating data to improve data quality; testing complex ETL code and validating data integrity in an ETL that loads data from diverse set of source systems (SAP, Energy Components, OSI PI, P6 Analytics) to enterprise data warehouse; and optimizing/tuning several complex SQL queries and ETL schedule for better performance and efficiency. Also utilize experience in designing and leading in planning of test plan, scripts, scenarios and procedures; performing data validation of upstream and downstream data leveraging complex SQL queries using Microsoft SQL Server Management Studio(SSMS); Scrum and Agile Methodology in leading daily status calls and defect calls with stakeholders globally; data warehousing, Business Intelligence and OLAP; performing gap and root cause analysis on enterprise wide data including static master data and dynamic transaction data; and creating customer reports using SAP Business Objects.

Requirements: Master’s degree in Computer Science or Engineering, Information Technology, Software Engineering, or related field plus 6 months experience in job offered or 6 months experience in related occupation performing functional, database and SAP front-end testing including writing test scripts, execution planning, test script execution and reporting defects using Microsoft Test Manager and JIRA; performing web-based testing and development experience using HTML, XML and JavaScript; managing Extract, Transform, Load (ETL) instance automation run using Control-M Enterprise Logon; troubleshooting, resolving and escalating Cloud-data and Dev-Ops related issues and validating data to improve data quality; testing complex ETL code and validating data integrity in an ETL that loads data from diverse set of source systems (SAP, Energy Components, OSI PI, P6 Analytics) to enterprise data warehouse; and optimizing/tuning several complex SQL queries and ETL schedule for better performance and efficiency. Also requires 6 months experience in designing and leading in planning of test plan, scripts, scenarios and procedures; performing data validation of upstream and downstream data leveraging complex SQL queries using Microsoft SQL Server Management Studio(SSMS); Scrum and Agile Methodology in leading daily status calls and defect calls with stakeholders globally; data warehousing, Business Intelligence and OLAP; performing gap and root cause analysis on enterprise wide data including static master data and dynamic transaction data; and creating customer reports using SAP Business Objects. In lieu of Master’s degree, employer will accept Bachelor’s degree in above listed fields plus 5 years of progressive work experience in related occupation. Experience may be gained concurrently. Employer will accept any suitable combination of education, training or experience.


To view full details and how to apply, please login or create a Job Seeker account.