QA Automation Engineer / Enterprise ETL Tester
Posted Updated
QA Automation Engineer / Enterprise ETL Tester
ROLE
We need an experienced QA Automation Engineer at the Securities and Exchange Commission (SEC). This role supports the SEC's Enterprise Qualitative Support Services (EQSS) contract, providing independent verification and validation across the agency's growing cloud and data analytics environment. In this role, you will perform system analysis, verification, and validation across software and data workflows supporting IV&V activities, conduct software QA and defect evaluation, process and validate structured and semi-structured data including XML, JSON, and fixed width formats, develop SQL scripts and tests for Oracle, PostgreSQL, and Iceberg environments, build automation and validation scripts using Python, and support data warehousing and data lake testing activities within AWS using Redshift, Glue, and S3. This is a full-time opportunity. We can offer a competitive salary, and a comprehensive benefits package.
RESPONSIBILITIES
REQUIRED SKILLS/EXPERIENCE
PREFERRED SKILLS/EXPERIENCE
REQUIRED EDUCATION / CERTIFICATIONS
LOCATION
CLEARANCE
CLIENT
WORK HOURS
EMPLOYMENT CLASSIFICATION
RELOCATION
COMPENSATION
West 4th Strategy is an Equal Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, gender, sexual orientation, ancestry, national origin, age, marital status, mental disability, physical disability, medical condition, pregnancy, political affiliation, military or veteran status, or any other basis prohibited by federal or state law.
Other Considerations: applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 80% of the time.
ROLE
We need an experienced QA Automation Engineer at the Securities and Exchange Commission (SEC). This role supports the SEC's Enterprise Qualitative Support Services (EQSS) contract, providing independent verification and validation across the agency's growing cloud and data analytics environment. In this role, you will perform system analysis, verification, and validation across software and data workflows supporting IV&V activities, conduct software QA and defect evaluation, process and validate structured and semi-structured data including XML, JSON, and fixed width formats, develop SQL scripts and tests for Oracle, PostgreSQL, and Iceberg environments, build automation and validation scripts using Python, and support data warehousing and data lake testing activities within AWS using Redshift, Glue, and S3. This is a full-time opportunity. We can offer a competitive salary, and a comprehensive benefits package.
RESPONSIBILITIES
- Perform system analysis, verification, and validation across software and data workflows supporting IV&V activities.
- Conduct software QA, functional/regression/system testing, and defect evaluation.
- Process and validate structured and semi-structured data (XML, JSON, delimited, fixed width).
- Develop SQL scripts and tests for Oracle, PostgreSQL, and Iceberg environments.
- Support data engineering processes, ETL/ELT workflows, and data quality assessments.
- Build and maintain automation and validation scripts using Python.
- Operate within AWS environments and support Data warehousing and Data-lake testing activities using Redshift, Glue and S3.
- Utilize Linux, CLI tools, and GitHub for version control and development workflows.
- Prepare formal technical documentation and communicate findings to government stakeholders.
REQUIRED SKILLS/EXPERIENCE
- Demonstrated experience in software QA, test engineering, test automation, and data engineering.
- Strong proficiency with XML, JSON, CSV, delimited, and fixed width data formats.
- Skilled in SQL and experience with Oracle, PostgreSQL, and Iceberg databases.
- Practical experience with Python for scripting and automation.
- Hands on experience with CI/CD automated deployment pipelines using Git.
- Hands on experience working within AWS environments, Redshift, Glue and S3.
- Proficiency in Linux, command line operations, and GitHub repositories.
PREFERRED SKILLS/EXPERIENCE
- Strong written and oral communication skills.
- Ability to work independently and collaborate in multidisciplinary technical environments.
- High attention to detail, strong analytical thinking, and structured problem-solving skills.
REQUIRED EDUCATION / CERTIFICATIONS
- Bachelor's degree in computer science, data science, engineering, finance, or a related quantitative field (Master's preferred)
LOCATION
- Remote – Based in National Capital Region - Preferred
CLEARANCE
- U.S. citizenship is required. Must not hold citizenship with another country.
- Ability to obtain SEC security clearance
CLIENT
- Securities and Exchange Commission (SEC), Office of Information Technology
WORK HOURS
- 40 hours per week
- 8 hours per day
EMPLOYMENT CLASSIFICATION
- Employment Classification Eligibility — W2
RELOCATION
- Not eligible for relocation benefits
COMPENSATION
- Salary range: $140,000 – $150,000
- Benefits: Benefits package includes options for health, dental, and vision insurance coverage; 401k contribution options
West 4th Strategy is an Equal Opportunity (EEO) employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, gender, sexual orientation, ancestry, national origin, age, marital status, mental disability, physical disability, medical condition, pregnancy, political affiliation, military or veteran status, or any other basis prohibited by federal or state law.
Other Considerations: applicants will be subject to a background investigation. Individual’s primary workstation is located in an office area. The noise level in this environment is low to moderate. Regularly required to sit for extended periods up to 80% of the time; frequently required to move about to access file cabinets and use office equipment such as PC, copier, fax, telephone, cell phone, etc. Occasionally required to reach overhead, bend, and lift objects of up to 10 lbs. Specific vision abilities required by this job include the use of computer monitor screens up to 80% of the time.