ETL Test Engineer - Python/SQL

What we're 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



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/ .

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 can't 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.