EDW QA Analyst

• US Anesthesia Partners is the highest-quality single-specialty anesthesia practice in the United States, with over 6,000 employees distributed across 12 states. Our clinical and non-clinical staff support each other as they work toward a common vision: Empowering people to advance exceptional care. The Enterprise Data Warehouse Quality Assurance Analyst would be responsible for the development of testing strategies, test plans, test cases, and SQL validation scripts to support testing of data integration solutions.This is a hybrid position based out of our Dallas, TX office location. No Visa sponsorship will be provided.

At this time, US Anesthesia Partners does not hire candidates residing in New York, California, Hawaii, or Alaska.

• ESSENTIAL DUTIES AND RESPONSIBILITIES:

(The ideal candidate must be able to complete all physical requirements of the job with or without a reasonable accommodation)

The IT - Data Warehouse Quality Assurance Analyst would be responsible for the development of testing strategies, test plans, test cases, and SQL validation scripts to support testing of data integration solutions. They work with internal business units, analysts, and key stakeholders to understand the requirements to provide required testing support in terms of data validation, data analysis, defect management and test results documentation.

• KNOWLEDGE/SKILLS/ABILITIES (KSAs):

Qualifications:

Education:

• Bachelor’s degree in computer science, Computer Engineering, Information Technology, Mathematics, Data Analytics, Business Information Systems or equivalent degree with relevant experience required.
• Should be able to work without visa sponsorship

Required Skills:

• 3 to 6 years’ experience working as an ETL/Data Warehouse Quality Assurance Engineer Required.
• Domain knowledge of Healthcare Industry strongly preferred.
• Experience with Data Warehouse testing using SQL to query, create tables, views, indexes, joins, user defined functions and stored procedures.
• Working experience on facts and dimension tables, star, and snowflake schemas
• Working experience on testing Power BI and SSRS Reports or similar BI solutions
• Experience with MS SQL Server, MS Azure or other similar DB platforms
• Experience using Azure DevOps preferred
• Experience working with Agile Methodology preferred
• Excellent verbal and written communication skills
• Excellent Data Analysis Skills
• Excellent Defect Management skills
• Ability to adapt to a quick paced environment that may include changing priorities
• Ability to trouble shoot data quality issues and identify root causes
• The physical demands described here are representative of those that may need to be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Occasional Standing
• Occasional Walking
• Frequent Sitting
• Frequent hand, finger movement
• Use office equipment (in office or remote)
• Communicate verbally and in writing