Sr Quality Assurance Engineer - Analytics

03 Jul 2024

Vacancy expired!

Overview

Here at Discount Tire, we celebrate the spirit of our people with extraordinary pride and enthusiasm. Our business has been growing for more than 60 years and now is the best time in our history to join us. We are opening more locations every year and we are always looking for qualified individuals to join us in our growth. We are a company that promotes from within, both in our retail and corporate operations.

Under minimal supervision performs validations of the various components of the Analytics environment including but not limited to, the data lake, enterprise data warehouse and BI Applications. Focused on manual QA validation and automation of routine quality assurance processes. Ensures the accuracy of data flowing through each stage of the development process, fulfillment of requirements including adherence to the Company's Business Intelligence (BI) guidelines.

Responsibilities

  • Executes on and makes recommendations to improve the end-to-end quality assurance support of data platform, enterprise data warehouse, data science solutions/algorithms, business intelligence solutions including, but not limited to, reports, dashboards and mobile applications
  • Work with BI developers to test highly complex reports, dashboards and mobile applications, using both manual and automated methods
  • Develops, execute and evangelizes testing frameworks and testing strategy including test plans, test scenarios, test cases, test data and test scripts for manual and automated testing
  • Identify risks to inform resource allocation, prioritization, and target areas for automated coverage and ongoing monitoring
  • Analyzes more complex business requirements, design documents for completeness and testability
  • Manages and reports on defects, performs root cause analysis of the defects; collaborates with development team to resolve defects
  • Collaborate with data engineers, BI developers and data scientists to identify, document, resolve defects
  • Collaborate with team members in code reviews, discovering better practices and patterns and continuous improvements
  • Helps drive automation of regression and integration testing across entire data environment
  • Works with Data Engineers and Data Scientists to develop automated scripted tools (i.e.: Python, R, Bash) to test and validate data science models, data and pipelines
  • Analyzes manual test cases and functional specifications; determines best approach for the development of automated testing and reporting
  • Writes and executes complex SQL queries or Python code; validates actual test results match expected results
  • Defines, develops and implements monitoring solutions for production environments
  • Perform, document, maintain and report on functional, regression, integration, and acceptance testing
  • Stay current with QA best practices, methodologies and technologies, and continue to improve the QA processes across the team
  • Innovate constantly and maintains the technical edge
  • Assists employees, vendors or other customers by answering questions related to analytics quality processes, procedures and services
  • Completes work in a timely and accurate manner while providing exceptional customer service
  • Other duties as assigned

Qualifications

  • 5 years big data/ business intelligence / data engineer QA Engineer or Developer experience.
  • Proven experience designing and implementing automated testing solutions is essential.
  • Intermediate understanding of data lake/ big data concepts required.
  • Experience with data warehouse tools (Teradata, Oracle, Netezza, SQL, NoSQL etc.) as well as cloud-based data warehouse tools (Snowflake, Redshift, AWS Athena, AWS Dynamo DB, Google BigQuery) is required.
  • Experience with ETL/ELT tools such as Matillion, Informatica, AWS GLUE and understands the pros/cons of transforming data in ETL or ELT fashion required.
  • Solid foundation of data modeling/dimensional modeling concepts of schemas, tables, views, materialized views, stored procedures, and roles/security is required.
  • Adept at building processes to support data transformation, data structures, metadata, dependency and workload management preferred.
  • Experience with BI tools such Tableau, PowerBI, Cognos and Microstrategy required.
  • Advanced to expert level experience SQL/TSQL is required.
  • Experience scripting in Python, R, or Bash is required.
  • Experience and knowledge in: HTML, SQL/TSQL, JavaScript Object Notation (JSON) and Xpath is preferred.
  • Experience with automated scheduling tools such as Skybot, Control-M, or Unix Cron is preferred.
  • Familiarity with statistical modeling concepts is preferred.
  • Experience with cloud technologies like AWS, Azure, or Google Cloud is preferred.
  • Experience with UI/UX automated testing tools such as Selenium and Appian is preferred.
  • Experience with various integration techniques, such as streaming, CDC, bulk loading, is required.
  • Understanding of the advanced Testing Life Cycle concepts is necessary.
  • Experience with the review of requirements documents, risk analysis and specification documents is necessary.
  • Understanding of Functional, Non Functional, System Integration and Regression testing principles is essential.
  • Knowledge of defect management tools is necessary.
  • Knowledge of change management source control tools such as SVN, Git is necessary
  • Understanding of Software Development Life Cycle (SDLC) methodologies such as Agile and Waterfall is needed.
  • Advanced level computer experience, including skills in Microsoft Word and Excel and is necessary .
  • The ability to multi-task, and manage multiple projects to meet various deadlines simultaneously is required.
  • The ability to work efficiently under pressure, accurately meet deadlines, present a professional demeanor and work well independently is essential.
  • Customer service skills, including the ability to manage and respond to different customer situations while maintaining a positive and friendly attitude are essential.
  • Maintaining confidentiality, treating others with respect, and upholding Company values are key attributes.
  • In addition, organizational and problem solving skills, a can-do attitude, and the ability to adjust to changing requirements are essential.

Educational Requirements:
  • This position requires Bachelors Degree in Computer Science, Mathematics, Statistics, Engineering or equivalent technical trainings.
  • ISTQB or CSTE Foundation Certification preferred.
#LI-GW1

  • ID: #43787297
  • State: Arizona Scottsdale 85250 Scottsdale USA
  • City: Scottsdale
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-07-03
  • Deadline: 2022-08-31
  • Category: Et cetera