Senior Data Engineer (Analytics & Applied AI)
Job Description
System One is hiring a Senior Data Engineer (Analytics & Applied AI) for a remote Contract To Hire role in McLean, VA. This position is built for engineers who want to own end-to-end data platforms and ship production-grade Python services on AWS. If you value autonomy, strong data quality, and practical applied AI work, this role offers a direct path to impact.
- Health and welfare benefits with options including medical, dental, vision, spending accounts, life insurance, and voluntary plans
- 401(k) participation
- Public Trust eligible environment, with onboarding dependent on approved adjudication
Responsibilities
- Own data platforms end to end, from source ingestion through transformation to the analytics and application layers that consume them, with correctness, idempotency, and auditability built in.
- Write production Python and build production software, including services, APIs, tooling, and well-tested, maintainable code, not just SQL.
- Design and orchestrate cloud data pipelines on AWS using scheduling, retries, data-quality gates, and clean failure handling.
- Model data for analytics and application serving, including dimensional/fact modeling, grain decisions, slowly-changing dimensions, idempotent recompute patterns, and clear separation between an analytical warehouse and an application system-of-record.
- Implement data-quality and reconciliation checks that run every pipeline and gate publication.
- Drive architecture and technical decisions independently, evaluating tradeoffs and leading implementation with limited supervision.
- Use agentic coding assistants effectively to accelerate delivery while maintaining code quality and review discipline.
- Grow applied AI/ML capabilities over time, including entity resolution/record linkage, LLM-assisted analytics over structured and unstructured data, and anomaly or risk scoring.
Requirements
- 6+ years in data engineering and/or software engineering building and operating production systems.
- University Degree and minimum 6 years of prior relevant experience.
- Education substitution: 4 years of relevant experience may substitute for formal education.
- Strong software engineering skills: production-quality Python, clean architecture, testing, code review, and CI/CD.
- You build software, not only scripts.
- Expert SQL, including window functions, complex joins, aggregation-grain reasoning, and query performance.
- AWS data & compute stack hands-on experience with several of: Glue, Step Functions, S3, Redshift, Aurora/RDS, Lambda, EventBridge, ECS/Fargate, IAM.
- Data modeling: dimensional/analytical modeling, grain, SCD, and idempotent recompute patterns.
- Data-quality discipline: validate outputs, reconcile totals, and defend metrics.
- Infrastructure as code: Terraform or CDK in a real project.
- High autonomy: proven ability to own systems and drive delivery independently with sound architecture judgment.
- Agentic coding assistants: demonstrated, effective use of AI coding tools in a real workflow.
- Analytics fluency: profile datasets, spot anomalies, explain what metrics mean, and address discrepancies.
- Must be able to obtain and maintain a Federal or DoD Public Trust; candidates must obtain approved adjudication prior to onboarding. Active Public Trust or suitability preferred.
- Applied AI/ML: practical LLM use such as RAG, structured extraction from unstructured text, embeddings, or ML risk-scoring (strong interest counts even without deep production experience).
- Agent frameworks: AWS Strands Agents, Bedrock AgentCore, or similar for tool-using or multi-agent systems.
- Entity resolution / record linkage: probabilistic matching.
- API development: FastAPI or similar; enough front-end awareness to collaborate with UI engineers.
- Data flows: DuckDB / Parquet-based pipelines and data-lake table formats such as Iceberg/Delta.
- Experience in regulated or government data environments.
Technologies
- Python
- SQL
- AWS (Glue, Step Functions, S3, Redshift, Aurora/RDS, Lambda, EventBridge, ECS/Fargate, IAM)
- Terraform, CDK
- FastAPI
- AWS Strands Agents, Bedrock AgentCore
- LLM-assisted analytics, RAG, embeddings
- DuckDB, Parquet, Iceberg, Delta
Salary: USD 160,000 per year. Job type: contract. Work model: remote. Security clearance: Public Trust.