Test Engineer Lead

Systems Engineering Services is seeking a Test Engineer Lead based out of the Chicago, IL area.

Top 5 Technical Skills:

1. 8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
2. 3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
3. Hands-on experience in at least one large-scale data migration or modernization program, ideally involving:
4. Migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake).
5. Hands-on experience with at least one large-scale ETL tool migration (e.g., Informatica to dbt or similar).

Key Responsibilities

• Define the test strategy, scope, objectives, entry/exit criteria, and quality gates across all phases (unit, system, SIT, UAT, performance, regression, cutover).
• Develop and maintain Test Plans and Test Approach documents aligned with program milestones.
• Standardize test processes, templates, and metrics (defect density, pass rates, coverage).
• Collaborate with architects, data engineers, and business SMEs to understand systems, data models, and business rules.
• Design and execute test scenarios, cases, and data requirements for migration and re-platforming.
• Implement data validation and reconciliation (row counts, aggregates, schema checks, business rules).
• Lead testing of Databricks pipelines, jobs, notebooks, workflows and dbt models/tests.
• Validate CDC and incremental load logic to ensure consistency and accuracy.
• Coordinate performance and load testing for Databricks and Snowflake.
• Manage test environments (Dev, QA, UAT, Pre-Prod) in Azure and Snowflake.
• Oversee test data management (anonymization, subsetting, refresh strategies).
• Align test execution with CI/CD pipelines for automated build and deployment workflows

Basic Qualification

• 8+ years of experience in software testing/QA, with strong focus on data warehouse, ETL, and analytics platforms.
• 3+ years of experience testing cloud data solutions (preferably Azure and Snowflake).
• Hands-on experience in at least one large-scale data migration or modernization program, ideally involving:
• Migration from an MPP appliance (Yellowbrick, Teradata, Netezza, etc.) to a cloud data platform (Databricks, Snowflake).
• Hands-on experience with at least one large-scale ETL tool migration (e.g., Informatica to dbt or similar).
• Ability to travel 50% when required

Jake Lutman

Technical Recruiter

Systems Engineering Services