Simple Technology Solutions is a company that prioritizes its people and fosters a collaborative culture. They are seeking a Data Analyst/QA Engineer to ensure data accuracy and software quality on a federal data platform, supporting the Independent Verification and Validation process.

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

Senior Compensation Data Analyst

About this role