QA Analyst, Data Warehouse

Job Description

It’s Time For A Change...

Your Future Evolves Here

At New Century Health we are pioneering a new era of specialty care, focused on engaging with payers and providers to improve the quality of care for patients diagnosed with cancer and heart disease. Our evidence-based care delivery model supports patients during their most vulnerable times, a responsibility we are both humbled by and passionate about.

With nearly two decades of proven results in Oncology and Cardiovascular care, New Century Health improves quality and lowers costs for the 6M+ patients whose care we manage. Our approach is based on a proven clinical model that engages Oncology and Cardiovascular specialists through value-based care delivery. We believe the highest quality care is also the lowest cost care over time, improving outcomes and delivering financial savings to our partners. The New Century Health model has been proven across Medicare, Medicaid, and Commercial populations. New Century Health joined the Evolent Health family in 2018, joining the mission to change the health of the nation.

Are we growing? Absolutely. We have seen about 30% average growth over the last three years. Are we recognized? Definitely. We were named one of “Becker’s 150 Great Places to Work in Healthcare” in 2016, 2017, 2018 and 2019 and are proud to be recognized as a leader in driving diversity, equity and inclusion (DE&I) efforts. Evolent achieved a 100% score on the 2020 Human Rights Campaign's Corporate Equality Index, making us one of the best places to work for LGBTQ+ employees. We were also named on the Best Companies for Women to Advance List 2020 by Parity .org and we publish an annual Diversity Report to share our progress on how we’re building an equitable workplace and performing on various metrics. If you’re looking for a place where your work can be personally and professionally rewarding, don’t just join a company with a mission. Join a mission with a company behind it.

Who You'll Be Working With:

Our Technical team at New Century Health (wholly-owned subsidiary of Evolent Health) is looking for a QA Analyst to part of EDWBI platform team to help build data driven analytics apps leveraging existing EDWBI platform.

Successful candidates will be self-driven, curious, and ready to challenge their peers. Most work will be performed using MS SQL server-based tools, so knowledge of MS SQL 2016 is desired. Ability to define heuristic testing techniques for Data based applications and interconnected sub-systems to reduce risk and increase the confidence of clients and stake holders.

What You’ll Be Doing:

• You will be part of core EDWBI development team testing every code that is required to be released to production. Your QA sign-off will be required as part of release management.
• You will be championing Change Management processes by applying QA rigor for each development work ensuring high quality delivery.
• You will be preparing test plans and test cases for each development work to ensure quality and timely deliverable of the project.
• Your role would require tactical shrewdness to identify and introduce smart techniques to work closely with developers and find issues early in the development process. Relentlessly improve testing activities and automate as and when the opportunity and return on automation is beneficial.
• Use the mantra “all code is guilty until proven innocent” to motivate Test Driven Development (TDD), lean thinking and good programming practices. Use different problem-solving techniques to conduct root cause analysis of systemic issues and identify, prioritize and mitigate system bottlenecks, with the end goal of overall system optimization.
• Understand the importance of solving the business problem to accelerate the product delivery with approaches like test automation, continuous integration, delivery and deployment.
• Aptitude and attitude of thinking “Quality is not a separate phase, it’s a culture”. Be ready and willing to educate team members on quality standards and help them to apply quality gates right from requirements to delivery of the intended solution.

The Experience You’ll Need (Required):

• 4+ years of T-SQL experience in writing/maintaining stored procedures and complex queries.
• Experienced as a QA analyst in data warehouse development projects with knowledge of DW schema and methodologies.
• Expertise in Test Driven Development methodology and Agile development.
• Strong attention to detail, ensuring processes are followed and root cause remediation is planned and executed for each issue, and that actions are fully documented.
• Critical thinker with the vision to work both tactically and strategically.
• Exceptional verbal and written communication skills, ability to modify communication style to match the appropriate level of the audience targeted, with strong understanding of the impact of a message on the organization or customer.

Finishing Touches (Preferred):

• Healthcare industry experience with exposure to healthcare/authorization and claims and related data (desirable)
• Experience with QA processes alignment with SOX compliance would be huge plus.
• Prior experience as SQL/ETL developer will be a plus.
• Knowledge of performance tuning databases and SQL statements optimization would be a plus.
• Experience with QA testing of Business Intelligence Reporting

Technical requirements:

Currently, Evolent employees work remotely temporarily due to COVID-19. As such, we require that all employees have the following technical capability at their home: High speed internet over 10 MBPS and, specifically for all call center employees, the ability to plug in directly to the home internet router. These at-home technical requirements are subject to change with any scheduled re-opening of our office locations.

Evolent Health is an equal opportunity employer and considers all qualified applicants equally without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability status. Evolent Health maintains a drug-free workplace.
#LI-Remote