Senior ETL Quality Assurance Engineer - KeHE Distributors, LLC

• 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

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!

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.

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.

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.