Data Analyst/QA Engineer

Simple Technology Solutions is a company that prioritizes its team members and offers flexibility to help them thrive personally and professionally while delivering exceptional solutions to Federal Government clients. They are looking for a Data Analyst/QA Engineer to join their federal data engineering team, ensuring data accuracy and software quality across a high-stakes environment. The role involves supporting the agency's Independent Verification and Validation (IV&V) process and maintaining automated data quality checks.

Responsibilities:

• Design, develop, and maintain automated data quality checks using AWS Glue data quality tools (including Deequ) to validate completeness, accuracy, record counts, field-level integrity, and domain conformance for all datasets ingested into the platform
• Perform schema validation for applicable filings prior to ingestion; manage data load exceptions with written approval from Data Stewards; implement custom data quality checks as defined by Data Officers and Data Stewards at the dataset level
• Monitor production ETL pipelines and ensure ETL Load Reports are populated in real-time and ETL Gap Reports are updated on a weekly basis covering all gaps from the inception of the initial ingest process; ensure zero data loss and complete data transfers
• Create, maintain, and execute test cases and automated tests that verify all user-facing platform functionality; build unit and integration tests; ensure all new code achieves the minimum 90% test coverage threshold
• Conduct static code analysis and dependency analysis to identify bugs, vulnerabilities, and data quality risks early in the development lifecycle; run security scans at least once per sprint as part of the Definition of Done
• Support the agency's IV&V process: prepare IV&V Questionnaires, coordinate test submissions, and ensure all findings are fully addressed and resubmitted within required timelines
• Support User Acceptance Testing (UAT) coordination; track and report on IV&V and UAT iteration counts per reporting period
• Validate that ETL metadata, data models, data dictionaries, and all required documentation are complete, accurate, and available in the agency data catalog prior to deployment
• Support ad hoc data requests by developing and validating optimized queries, materialized views, or reports
• Maintain the team's performance metrics dashboard including velocity, sprint burn-down/burn-up, code coverage, and backlog traceability in real-time
• Collaborate with Data Officers, Data Stewards, and the IV&V team to resolve data quality findings across the platform dataset portfolio
• Participate in 2-week sprint ceremonies, quarterly PI planning, backlog refinement, and agile delivery using JIRA and GitHub

Requirements:

• US Citizenship is required
• Bachelor's Degree is required
• minimum of 3-5 years' position related experience is required
• Bachelor's degree or higher in Computer Science, Information Systems, Data Analytics, or a related field
• 3-5 years of experience in data quality engineering, QA engineering, or data analytics in a technical data-intensive environment
• Proficiency in SQL for data validation, gap analysis, record count reconciliation, and ad hoc query development
• Experience with Python for test scripting and data analysis
• Experience with AWS Glue data quality tools or equivalent frameworks (Deequ, Great Expectations)
• Hands-on experience with CI/CD-integrated automated testing frameworks; ability to build unit and integration tests achieving 90% code coverage
• Experience supporting IV&V, UAT, or formal government acceptance testing processes; direct federal program experience is strongly preferred
• Familiarity with schema validation for XML datasets
• Experience with Trino, Athena, or equivalent query engines for validation against large-scale data lake tables
• Ability to produce complete test documentation including test plans, test cases, test results, and IV&V Questionnaires
• Familiarity with FISMA, NIST 800-53, OWASP ASVS Level 2, and federal secure software development standards
• Must be able to work 8am-5pm Eastern Time regardless of home location
• Active federal public trust suitability determination or ability to obtain one required
• Experience with large-scale financial or regulatory datasets is a strong plus
• Familiarity with Section 508 accessibility compliance standards is a plus