QA Analyst (ETL, Visualization Testing, Data Quality, SQL)

Ellucian West Sadsbury Township, PA 2019-06-17

Employee Type: Full - Time

Ellucian designs technology that powers the educational mission of colleges and universities around the world. Inspired by that goal, Ellucian employees thrive as part of a high-performing global team committed to delivering a modern, connected, industry-leading experience for today’s students and higher education institutions. More than 2,500 institutions in 50 countries around the world look to Ellucian for the ideas and insights that will move education forward, helping people everywhere discover their futures through learning.

Job Responsibilities & Requirements

  • Design, plan, and execute product testing - including functional testing, system integration testing, regression testing, and performance testing - for an analytics product including data visualizations and ETL
  • Estimate, plan, and coordinate testing activities for analytics content
  • Design, write, and execute effective manual and automated test cases and create test data as needed
  • Discover, reproduce, prioritize, retest, and clearly document system defects
  • Develop, update, and maintain relevant test metric reporting
  • Perform test coverage analysis and requirement tracing
  • Actively participate with the team in software requirements, design, and code reviews to provide early and continuous quality feedback
  • Work with the team to continually improve test processes and practices based on inspection/adaption of previous iterations and to ensure adherence to process, tools and metrics standards within the project team
  • Be a self-starter and possess the ability to research issues and improve processes
  • Manage multiple tasks and adjust to shifting priorities, as necessary
  • Understand data flow and test strategy for ETL and visualization testing
  • Write advanced SQL queries for ETL/data warehousing/visualization testing

Required Skills / Knowledge / Experience

  • 3+ years of in-depth experience and demonstrated proficiency with QA methodology, process and deliverables
  • Work experience in an agile environment that employs continuous integration processes and automated testing
  • Strong SQL skills and experience with relational databases
  • Experience in ETL and data warehouse testing
  • Experience in BI reporting tool testing such as Tableau
  • Experience in testing source to destination data movement and transformation
  • Knowledge of data modeling, data warehousing and visualization concepts
  • Demonstrated ability to learn a new domain rapidly
  • Demonstrated ability to write and execute effective manual and automated test cases and test plans
  • Display a high-level of initiative and troubleshooting skills
  • Strong work prioritization, planning, and organizational skills
  • Strong interpersonal and communication (both written and verbal) skills
  • Experience working in a team using Agile Scrum development process
  • Experience with ETL and visualization test automation tools
  • Experience with test management tools such as ALM or TFS

Desired Skills / Knowledge / Experience

  • Higher education domain and system experience
  • Working knowledge of Ellucian products such as Ellucian Banner, Ellucian Colleague, CRM Recruit, CRM Advance
  • Experience with performance testing
  • Experience with accessibility testing
  • Experience with repository management tool such as GIT


Ellucian provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, Ellucian complies with all laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Ellucian expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Ellucian employees to perform their job duties may result in discipline up to and including discharge.

Apply This Job

People Also Viewed