Junior Data Engineer – ETL, Data Quality

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist the Database Engineer Subject Matter Expert (SME) in executing ETL pipeline transformation logic, conducting data quality checks, and validating schema rules.

• Implement prototype data ingestion workflows by processing representative data through ETL pipelines and assessing results against established quality criteria.

• Record data quality issues in the Defect and Risk Log, detailing severity levels, root cause analysis, and suggestions for remediation.

• Contribute to the Prototype Ingest Results Report by capturing database-layer ingestion outcomes, data quality issues, severity classifications, and remediation suggestions for each prototype ingestion cycle.

• Create and sustain the Metadata and Authoritative Source Registry by researching and documenting attributes of data sources, refresh schedules, and contacts for data stewardship.

• Assist in database performance testing before production deployment by executing query performance benchmarks and identifying opportunities for optimization.

• Implement and verify Role-Based Access Control (RBAC) configurations on all database objects.

• Facilitate interoperability testing by supplying test datasets, executing database-layer test cases, and documenting outcomes.

• Maintain all database scripts and pipeline code within the version-controlled repository.

• Assist with post-migration data validation during the production cutover phase.

⛳️ Requirements

• Bachelor’s degree with 2 years of professional experience, a Master’s degree with no professional experience, or a high school diploma with 6 years of professional experience.

• U.S. Citizenship is mandatory.

• Capability to obtain and maintain a Public Trust clearance.

• All tasks must be completed within the United States.

• Minimum of 1 year of experience in database engineering with practical ETL development experience.

• Familiarity with Databricks, Delta Live Tables, or similar cloud ETL frameworks.

• Proficient in SQL and at least one scripting language (Python, Scala, or similar).

• Experience in data quality validation, RBAC configuration, and database performance testing.

• History of documenting prototype ingestion results and findings related to defect remediation.

• Understanding of FIPS 140 encryption requirements and NIST SP 800-171 database security controls.

• Knowledge of federal data governance and security standards.

• Preferred: Experience with AWS GovCloud or similar FedRAMP-authorized cloud environments.

• Preferred: AWS Certified Cloud Practitioner or AWS Certified Database Specialty certification.

• Preferred: Familiarity with NIST SP 800-171 database security controls.

• Preferred: Experience in supporting federal data migration initiatives.

• Preferred: Databricks Associate certification or equivalent.

🏝️ Benefits

• Potential for overtime.

• Shift differential pay.

• Discretionary bonus opportunities.