Company Description

Amwell digitally empowers payers, providers and innovators, enabling an ecosystem of care that spans across in-person, virtual and automated care.

Amwell provides a leading hybrid care enablement platform in the United States and globally, connecting and enabling providers, payers, patients, and innovators to deliver greater access to more affordable, higher quality care.

Amwell believes that hybrid care delivery will transform healthcare. The company offers a single, comprehensive platform to support all digital health needs from urgent to acute and post-acute care, as well as chronic care management and healthy living.

With nearly two decades of experience, Amwell powers the hybrid care of more than 55 health plans, which collectively represent more than 90 million covered lives, and many of the nation’s largest health systems, representing over 2,000 hospitals, have access to Amwell solutions.

For more information, please visit Amwell.com.

Brief Overview:

The Data QA Engineer will be responsible for testing and maintaining test cases on the Data Platform team. They need to verify data mappings and reports on our reporting tool and should be well versed with ETL process. Should be able to understand reporting requirements and write test cases and execute them in a timely manner. Perform Regression during releases and UAT demos to the Product team.

Core Responsibilities:

• Validating ETL results, data completeness, and data integrity against established business requirements and data definitions
• Create, test and maintain the test case and test plan documents to inspect and verify multiple client implementations according to specifications.
• Prepare SQL queries to test the data accuracy and quality
• Conduct regression and functional testing to ensure the quality of production data sources
• Contributing to the improvement of the quality assurance processes
• Ensure that tested functionalities are well documented
• Translate business requirements into test scenarios and test cases
• Being proactive and taking initiative by engaging with business stakeholders and team members to comprehensively understand issues and propose solutions.
• Understanding of the SDLC (Software Development life cycle) and Knowledge of Scrum, Agile

Qualifications:

• Bachelor’s Degree or equivalent experience is required. Preferred in Computer Science or related degree
• 5+ years of Software Quality Assurance testing experience.
• At least three years of experience in the QA field with focus on testing data mappings/ETL flow and reports.
• Working knowledge of any reporting tool (looker) is required.
• Strong experience with SQL is a must. Good to have PL/SQL knowledge as well.
• Working knowledge of AWS and GCP cloud platforms.
• Hands on experience writing simple/complex queries on Bigquery and Redshift databases.
• Ability to read and understand Python scripts is good to have.
• Good understanding of QA processes and methodologies - test planning, test cases, bug tracking systems and software development life cycle
• Knowledge of CI/CD, source control tools is required.
• Strong analytical skills and keen understanding of business processes.
• A degree in Computer Science, Mathematics, Business Administration, or a related field
• Excellent written and verbal communication skills in English and ability to demo the reporting requirements and outcomes to the Product team.
• Good understanding of data warehouse architecture and ETL processes
• The capability to tackle problems independently as well as collaboratively within a team.
• Down-to-earth, creative, self-driven and friendly personality

Job Level: P3

Working at Amwell:

Amwell is changing how care is delivered through online and mobile technology. We strive to make the hard work of healthcare look easy. In order to make this a reality, we look for people with a fast-paced, mission-driven mentality. We’re a culture that prides itself on quality, efficiency, smarts, initiative, creative thinking, and a strong work ethic.

Our Core Values include One Team, Customer First, and Deliver Awesome. Customer First and Deliver Awesome are all about our product and services and how we strive to serve. As part of One Team, we operate the Amwell Cares program, which brings needed assistance to our communities, whether that be free healthcare for the underserved or for people affected by natural disasters, support for equality, honoring doctors and nurses, or annual Amwell-matched donations to food banks. Amwell aims to be a force for good for our employees, our clients, and our communities.

Amwell cares deeply about and supports Diversity, Equity and Inclusion. These initiatives are highlighted and reflected within our Three DE&I Pillars - our Workplace, our Workforce and our Community.

Amwell is a "virtual first" workplace, which means you can work from anywhere, coming together physically for ideation, collaboration and client meetings. We enable our employees with the tools, resources and opportunities to do their jobs effectively wherever they are!

Additional Benefits

• Medical Plan Coverage provided by Colmédica
• ► 100% paid by Amwell for employee coverage
• ► 50% paid for spouse or dependent coverage Life Insurance
• Plan Coverage provided by Pan American
• ► Paid 100% by Amwell for 12 monthly salaries
• Hybrid Allowance
• ►311,850 COP provided by Amwell
• Paid Time Off
• ► 20 days of Annual Leave
• ► 4 Mental Health Days
• ► 1 Day of Service/Volunteering
• ► 1 Day for Birthday (taken within birthday month)
• ► 1 day of family day per 6 months
• Maternity Leave 18 weeks
• ►paid by Amwell Paid
• Parental/Paternity Leave 2 mandatory weeks + 4 weeks
• ►paid by Amwell for a total of 6 weeks paid by Amwell
• Mental Health and Resiliency
• ► You have access to Calm at no cost
• Virtual Second Opinion with the Cleveland Clinic Coverage
• ►provided by Amwell at no cost for employees
• LinkedIn Learning
• ►Provided by Amwell at no cost
• Rewards and Recognition
• ►Employees will be eligible to participate in Amwell’s recognition program, Bucketlist
• Service Anniversaries
• ►Employees will receive recognition and points via Bucketlist for service milestones
• Annual Bonus
• ►Employees will be eligible for Amwell’s Corporate Performance Bonus Program
• Referral Program
• ►Employees may be eligible for a referral bonus for referring candidates to open role