Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Flexibility to help them thrive personally and professionally
- Special incentives for team members living in qualified HUBZones
Company Overview