QA Automation Engineer / Enterprise ETL Tester

Posted 3 Days Ago
Be an Early Applicant
Washington, DC, USA
In-Office
140K-150K Annually
Mid level
Information Technology • Security
The Role
Performs software and data workflow verification, validation, QA, regression testing, defect evaluation, and ETL/data quality testing. Develops SQL tests for Oracle, PostgreSQL, and Iceberg, Python automation scripts, and validation workflows. Supports AWS data warehouse and data lake testing using Redshift, Glue, and S3, while documenting findings for government stakeholders.
Summary Generated by Built In
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
  • 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.

Skills Required

  • Bachelor’s degree in computer science, data science, engineering, finance, or a related quantitative field
  • Experience in software QA, test engineering, test automation, and data engineering
  • Proficiency with XML, JSON, CSV, delimited, and fixed-width data formats
  • Proficiency in SQL and experience with Oracle, PostgreSQL, and Iceberg databases
  • Practical experience using Python for scripting and automation
  • Hands-on experience with CI/CD automated deployment pipelines using Git
  • Hands-on experience with AWS, Redshift, Glue, and S3
  • Proficiency in Linux, command-line operations, and GitHub repositories
  • U.S. citizenship with no citizenship in another country
  • Ability to obtain SEC security clearance
  • Master’s degree
  • Strong written and oral communication skills
  • Ability to work independently and collaborate in multidisciplinary technical environments
  • High attention to detail, analytical thinking, and structured problem-solving skills
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Springfield, VA
47 Employees
Year Founded: 2016

What We Do

West 4th Strategy provides rapid response technology services to civilian, defense, and homeland security customers. We build and mobilize dynamic teams of qualified technologists who embody competence, professionalism, and a commitment to results. We excel at moving fast to find the right people to get the job done. And the best part of our technology teams? They make the government’s mission their mission. Our teams work with a sense of purpose to power the government. West 4th Strategy. Our work defines us.

Similar Jobs

PwC Logo PwC

Sanctions - Crypto & Digital Assets - Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
8 Locations
370000 Employees
124K-280K Annually

PwC Logo PwC

AML and Sanctions- AI Modeling- Director

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
8 Locations
370000 Employees
155K-410K Annually

PwC Logo PwC

Assurance Internal Communications Director

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
69 Locations
370000 Employees
123K-123K Annually

PwC Logo PwC

Consultant

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
8 Locations
370000 Employees
99K-232K Annually

Similar Companies Hiring

Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account