Quality Assurance (QA) Engineer II - Data in Irving, TX at Cottonwood Financial

Date Posted: 5/6/2021

Job Snapshot

Job Description

Reporting to our Quality Assurance Manager, the QA Data Engineer II will be responsible for analyzing requirements and developing and executing test scenarios and test cases to support our custom-developed Data Warehouse, ETL, BI, Reports, and Point-of-Sale systems. This includes activities using Microsoft SQL (T-SQL), SSIS, reporting (SSRS), and analytics (SSAS). This person will also be responsible learn Cottonwood’s business model and database structures for new solutions. The test engineer will also be responsible to set up test data, execute test cases, and report/track software bugs to closure. Here at Cottonwood, we operate very quickly and time to market is imperative for projects that affect income. Using your experience in data engineering, you will execute test scripts that complement our existing test suite and leveraging existing test solutions. In addition, you will use your experience to support the systems development life cycle (SDLC) from the early stages in requirements gathering, to user acceptance and regression testing, through production release. We are seeking candidates that believe customer service is paramount and who want to be a part of a dynamic team delivering world-class results. If that describes you, we’d love to have you on the team. This position is based at our Administrative Office (HQ) in Irving (Las Colinas), Texas.

Key Responsibilities

  • Analyze requirements and decompose them into test scenarios
  • Create, maintain, and execute comprehensive test plans and test cases against our software platforms based on an analysis of requirements, user stories, use cases, and technical design specifications
  • Identify / Setup test data required to complete test execution
  • Identify, monitor, and track system bug and support resolution efforts promptly
  • Collaborate with product and integration development teams to enhance knowledge of business systems to better contribute to the backend, functional, and regression testing suites
  • Provide daily progress report and test results to effectively communicate software test results & bugs to invested stakeholders
  • Develop a deep understanding of business processes and integration points to provide a more robust end to end testing
  • Work with team leadership to develop test schedules and tasks to deliver high-quality products
  • Assure ongoing compliance with quality and industry regulatory requirements
  • Creates Requirements Traceability Matrix and Test Summary reports once testing is completed
  • Work closely with other team members, business analysts, support team, Data Warehouse, ETL, BI, Reporting, and data developers to deliver high-quality products in a timely and cost-effective manner
  • Foster a collaborative environment focused on continuous improvement

Requirements

  • Bachelor’s Degree or equivalent Military/other experience
  • At least 4 years of work experience in testing ETL, BI, Reports, Data Quality, and Data Governance for custom-built Data Warehouse systems
  • Knowledge of Relational and Dimensional data modeling
  • At least 3 years of work experience using any standard test management tool like TFS or Azure DevOps or ALM or Jira or any other tool for creating and maintaining test artifacts
  • At least 3 years of experience in writing and executing Microsoft SQL (T-SQL) queries for testing SSIS integrations, SSRS reporting, and SSAS analytics services or equivalent
  • Strong written and oral communication skills, with the ability to communicate with all levels within the organization
  • Customer service-oriented and self-starter

Preferred Qualifications

  • Any QA testing certification (like ISTBQ / CSTE) is a plus
  • Experience on any back-end test automation tool is good to have
  • Knowledge of Microsoft development tools SSIS, SSAS, SSRS is ideal
  • Experience testing data visualization, dashboards, and reports using tools such as Tableau, QlikView, or Power BI
  • Familiarity with Visual Studio 2013/2015/2017/2019
  • Experience working in cloud technologies, Azure/AWS/GCP
  • Experience with TFS Version control system/Git version control system, Test Explorer / DevOps
  • Experience in system testing, integration testing, end to end testing, and regression testing, is an advantage
  • Experience/Knowledge in Finance practice such as accounting and general ledger Agile methodology experience (Agile, Scrum, SAFe, etc.)
  • Strong technical troubleshooting, problem-solving, organizational, and critical thinking skills

Compensation

  • Annual salary of $77,000

Benefits

  • Medical, dental, and vision
  • Voluntary life/ AD&D
  • Short-term & long-term disability
  • 401K with company match
  • Paid vacation, holidays, and sick time
  • Paid maternity, paternity, extended medical leave, and jury duty
  • Corporate discount program on personal cell phone accounts with select providers
  • Business casual work environment

About Cottonwood

Founded in 1996, Cottonwood Financial is one of the largest privately held retail consumer finance companies in the United States.  We have zero debt, have been profitable every year since inception, and our growth is funded entirely through internally generated capital.  Headquartered in Irving (Las Colinas), Texas, we have company-owned locations, under our Cash Store brand, across the country.  Through this national brick-and-mortar footprint, we provide best-in-class customer service and offer an innovative mix of financial products and services to our customers.

We have been named several times to the Inc. 5000 list of America’s fastest-growing private companies, as well as to the Dallas 100 list of the fastest-growing private companies in North Texas.