Healthcare SQL QA Analyst
6 month contract-to-hire (W2 or GC only. No 3rd parties/H4/H1)
100% remote
Must be vaccinated
QA Analyst with heavy SQL/Data warehouse testing experience in the Healthcare Industry
RESPONSIBILITIES:
Create Synthetic and/or Test Data using tools to validate functionality on the UI for which real test data is not yet available
Analyze large scale datasets, identify data quality issues
Design, implement, and improve data quality standards
Preparation of test cases and test plans to ensure high quality of data, requirements traceability matrix (RTM), and test execution reporting
Build tooling and solutions using frameworks for data profiling capabilities and data quality dashboards to monitor the quality of key datasets
Work within Agile, Kanban methodologies.
Partner with Product, Data Science, Analytics, and Engineering teams to identify and communicate issues/defects effectively
Manage data across relational SQL and data warehouse databases
Collect quality data and related KPIs to prepare and present test data reports and metrics to management
Document and execute tests based on BRD/FRD, application experience and expert understanding of the business.
Utilizes test techniques such as negative tests, boundary tests, systematic or strategic approaches to combination testing as well as some code inspection to isolate changes to be tested.
Performs expert risk analysis surrounding application builds, customer priorities and defect analysis. Offers solutions to meet both business and quality desires.
Effectively prioritizes work based on risk, quality expectations, timelines and customer needs.
Effectively prioritizes work on multiple projects.
Qualifications
Bachelors or Associates degree in Computer Science, Mathematics, Engineering, or related field preferred.
5+ years of experience in quality engineering with working experience in the Healthcare/Pharma Industry.
Proven ability to develop and execute Data and Analytics, SQL and ETL testing
Experience with the healthcare data assets and models with strong experience writing SQL queries and debugging.
Able to write moderate to advanced JOIN statements and aggregate data.
Experience in testing large scale enterprise data warehouses, ETL, data integration, data migration, and data quality verification exercises
Experience with testing data pipelines, warehouses, data bricks, data lakes using SQL and NoSQL stores and cloud technologies
Competent understanding of system architectures, include database servers, application servers, relational databases, and the interaction between these systems.
3+ years of equivalent or related experience in writing and debugging complex SQL and NoSQL queries and statements
Experience transforming data in various formats, including JSON, CSV, AVRO, PARQUET, XML, etc.
Experience in analyzing large scale complex datasets and identifying data anomalies and data patterns
3+ years of equivalent or related experience in data quality
Experience with continuous integration and deployment (CI/CD) pipelines and their enabling tools
Experience with building and updating macros.
Adherence to company, team and department guidelines, processes, methodologies
Utilization of approved testing tools including but not limited to: Defect Tracking / Test Case Management tools; SQL Server Management Studio; Remote Desktop Connection.
Completed tasks are of high quality.
Tasks are completed within a reasonable, agreed upon timeframe.
Responsible for ensuring all deliverables are high quality.
Software skills: Python, Java, JavaScript, SQL/Postgres/MySQL, Hive, Spark, Databricks, Cloud (Azure), Postman, JIRA, Confluence, Github, TFS, DevOps, Linux, Power BI, TOSCA, Selenium
#Dice-SPG
#CB-SPG
#IND-SPG
