ETL Test Engineer - Python/SQL

Post Date

Sep 09, 2024

Location

Chicago,
Illinois

ZIP/Postal Code

60603
US
Dec 09, 2024 Insight Global

Job Type

Contract

Category

QA

Req #

CHI-732313

Pay Rate

$40 - $50 (hourly estimate)

Job Description

What were looking for

8+ years in data engineering / ETL pipeline testing and Automation

5+ years of experience writing and executing SQL queries/python or pyspark

Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience

Sound knowledge of data flows, data architecture, data engineering / ETL and processing data

Sound knowledge of QA methodology and Agile frameworks

Strong communication skills and a keen eye for details

US work authorization

Someone who embodies being Oaky

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience

Description

Company: Oak Street Health

Title: Engineer II, Test Engineer - Data

Location: Chicago/Remote

Type: Contract

Rate: max 85 per hr

Interview process: 1 hr tech screen, 30 min behavioral

Candidates needed: 2



Role Description

The Test Engineer will be responsible for managing all functional and automated testing processes in support of business intelligence development efforts at Oak Street Health. From design to implementation, you will partner with our stellar engineering, product, and design teams in a fast-paced, agile environment to transform ideas into a reality. Utilizing modern methodologies and open source tools, you will be empowered to push the boundaries of Quality Engineering as we seek to deliver applications that will directly and immediately impact the experience of our teams and our patients. This role will handle the creation of all test scripts, the documentation of all test cases and identification of bugs across ETL development and reporting. The Test Engineer will manage the identification of bugs and assist in the prioritization of bug fixes.



There is no better time to join our rapidly growing team at Oak Street Health. We cant think of a mission any more motivating; and, with your help, we can drive change in healthcare for the patients that need us most.



Responsibilities

Contribute in all aspects of SDLC process( SCRUM, Design, Code, Test, Deploy & Maintain)

Review and analyze business and system requirements / specifications

Design test plans, scenarios, scripts, and procedures

Execute test cases (manual or automated) and log test results

Work with the development and product team to correct bugs / errors and identify requirement updates / clarifications

Support, design, develop, and enhance test processes and reporting for QA processes

Develop and maintain automation frameworks and solutions for ETL and data architecture

Automate tests to facilitate regression testing

Provide testing SME guidance to QA engineers

Other duties as assigned

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.