Job Description
This position reports to the Data Partnerships Director of Data and Analytics Platforms. This individual will be primarily responsible for the quality of the data ingested into the data lake and the data deidentification processes in the Federated Clinical Analytics Platform (FCAP), including providing quality assurance oversight of the data pipelines and REST APIs developed by the Data Partnerships Data Engineering team and the FCAP partner.
The candidate should be an expert in data profiling, root cause analysis, and strategies to ensure the quality of data being delivered through big data and analytics platforms. The QA analyst will be a member of a Data Engineering Scrum team that is delivering solutions focused on using state of the art data and analytics tools including traditional and near real-time data warehousing, big-data, relational and document-based databases using both extract, load, transform (ELT) toolsets as well as REST APIs and FHIR. The ideal candidate will be comfortable with data science platforms with proven experience leveraging DevOps and Test Automation tools.
Job Responsibilities:
* Measure data quality - Design, collect, analyze, and report on data quality assurance / production performance metrics
* Manage data quality documentation; define and maintain data standards, definitions, and models
* Identify incorrect data, documenting issues, patterns and gaps in the data and/or systems
* Provide accurate and appropriate interpretation of data, applying knowledge for evaluation, analysis, and interpretation of data
* Ensure data integrity by implementing quality assurance practices
* Perform root cause analysis on data issues and recommend data quality controls to resolve gaps/issues
* Provide quality assurance oversight of data flows and APIs
* Contribute to agile story refinement and estimation.
* Contribute as a member of the Data Engineering Scrum Team by developing and executing test cases during sprints to verify that the APIs and data pipelines developed meet defined acceptance criteria
* Collaborate with the Scrum Team and DevOps to automate test cases to be incorporated in the CI/CD pipelines
* Participate in the creation and maintenance of standards for coding, documentation, error handling, error notification, logging, etc.
Required Skills & Experience
* 3-5 years of data-focused QA experience using and testing the following software/tools:
o API testing experience with Postman
o Relational SQL and NoSQL databases, including Oracle, SQL Server, Postgres, and CosmosDB in Azure
o Data pipeline, workflow management, ELT tools such as Azure Data Factory and Synapse Pipelines
o Object-oriented/object function scripting languages such as Python or Java
o RESTful APIs and Web Applications
o Automating testing experience with Azure DevOps
* Bachelors Degree
Nice to Have Skills & Experience
* Python experience
* Prior experience in healthcare IT
* Data Lake & data ingestion experience
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.