KeHE Distributors logo

Senior ETL Quality Assurance Engineer

Location
Naperville, IL
Other
Tech
Why Work for KeHE?
  • Full-time
  • Pay Range: $89,114.00/Yr. - $115,000.00/Yr.
  • Shift Days: , Shift Time:
  • Benefits on Day 1
    • Health/Rx
    • Dental
    • Vision
    • Flexible and health spending accounts (FSA/HSA)
    • Supplemental life insurance
    • 401(k)
    • Paid time off
    • Paid sick time
    • Short term & long term disability coverage (STD/LTD)
    • Employee stock ownership (ESOP)
    • Holiday pay for company designated holidays

    Overview

    Good people, working with good people, for our common good.

    Sound good?

    KeHE-a natural, organic, specialty and fresh food distributor - is all about "good" and is growing, so there's never been a more exciting time to join our team. If you're enthusiastic about working in an environment with a people-first culture and an organization committed to good living, good food and good service, we'd love to talk to you!

    Primary Responsibilities

    The Senior Quality Assurance Engineer will lead comprehensive testing efforts on the business intelligence side. This role serves as the technical expert in ETL testing using AWS, SSRS, and dashboard testing, as well as API and performance testing. Responsibilities include ensuring that KeHE products meet established quality standards and regulatory requirements and identifying potential risks to product quality. As with all positions at KeHE Distributors, we expect that all actions will be consistent with KeHE's Mission, Vision, and Values.

    Essential Functions

    DUTIES, TASKS AND RESPONSIBILITIES:
    • Establish and maintain quality assurance standards and procedures.
    • Design, create, implement, and write detailed and comprehensive test plans for products.
    • Conduct tests to identify software defects and ensure product quality standards are met.
    • Perform inspections and audits to ensure compliance with standards.
    • Oversee the entire testing lifecycle from start to finish and perform manual and automated testing.
    • Document test cases, test results, and quality standards along with preparing and present reports on quality metrics.
    • Maintain detailed records of tests and inspections and implement corrective actions to address quality issues.
    • Collaborate with development teams to resolve issues.
    • Analyze data to identify areas for quality improvement and recommend and implement process improvements.
    • Design test cases based on functional and non-functional requirements.
    • Conduct regression testing to ensure changes were implemented.
    • Review design specifications for testability and participate in code reviews.
    • Set up test environments (software configurations) at various levels of testing.
    • Manage testing tools and ensure their proper utilization.
    • Communicate effectively with developers, product managers, and other team members.
    • Participate in project meetings to provide quality assurance insights.
    • Other duties and projects as assigned.

    Minimum Requirements, Qualifications, Additional Skills, Aptitude

    SKILLS, KNOWLEDGE AND ABILITIES:
    • Ability to communicate effectively both verbally and written with all levels at the organization.
    • Strong understanding of business intelligence and ETL processes and requirements.
    • Proficiency in understanding ETL data flow and mapping documents.
    • Ability to utilize extensive SQL queries to validate data across source, staging, and target systems.
    • Understanding of ETL testing processes, testing, and how to evaluate results.
    • Ability to work independently and in a team environment.

    EDUCATION AND EXPERIENCE:
    • Bachelor's degree in Information Technology or a related field.
    • Minimum of 7+ years of experience in ETL testing.
    • Experience in testing SSRS reports, BI dashboards, and similar tools.
    • Experience in API testing using tools such as Postman or similar and defect management tools such as JIRA.
    • Experience working with ETL tools such as AWS Glue, Informatica, Ab Initio, SSIS, or DataStage (or similar tools).
    • Experience automation data testing using Java (BDD Framework), Python or equivalent.
    • Certifications such as AWS, CSTE, CSQE, or CCP are preferred.

    PHYSICAL REQUIREMENTS:
    • These physical demands are representative of the physical requirements necessary for an employee to successfully perform the essential functions of the job.

    Requisition ID
    2024-23878
    Equal Employer Opportunity Statement
    KeHE Distributors provides equal employment opportunities to all employees and applicants for employment and prohibits all forms of discrimination and harassment on the basis of race, color, religion or faith, sex, gender, age, ancestry, national origin, mental or physical disability or medical condition, sexual orientation, gender identity or expression, marital status, military or veteran status, genetic information, or any other category protected under federal, state, or local law. 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 as well as the administration of all Human Resources and Talent Acquisition processes.