Data Engineer (Bid Role starting in 10 weeks) – TS/SCI w/ Poly

The Data Engineer will evaluate, optimize, and implement robust data infrastructure to enable reliable, accessible, and scalable data delivery across the organization. The Contractor will work collaboratively with data consumers, technical teams, leadership, and stakeholders to assess current data pipelines, identify gaps in data accessibility and reliability, and architect solutions that establish trusted data foundations.

Requirements

• Conduct comprehensive assessments of existing data pipelines, infrastructure, and data flows
• Evaluate current data architecture against industry best practices and organizational needs
• Design, build, and maintain production-grade data pipelines
• Develop robust ETL / ELT processes from diverse sources
• Build API integrations handling authentication, rate limiting, pagination, retry logic, and error handling
• Extract data from systems not designed for export; reverse-engineer undocumented data structures and relationships
• Handle semi-structured data (JSON and XML); transform into structured datasets with consistent schemas
• Design dimensional models, data warehouses, and data marts following industry methodologies
• Implement slowly changing dimensions and other data warehousing patterns
• Establish naming conventions, data standards, and modeling best practices
• Implement comprehensive data quality checks, validation rules, and automated monitoring with alerting
• Build error handling, failure recovery, logging, and observability into all processes
• Optimize pipelines for performance, cost, and resource utilization
• Develop reusable components and frameworks; refactor legacy pipelines for reliability
• Build and maintain data infrastructure on cloud platforms (AWS, Azure, or GCP) using infrastructure-as-code
• Implement CI/CD pipelines, version control (Git), and automated testing frameworks
• Manage database performance tuning, indexing, partitioning, and capacity planning
• Establish backup, recovery, security controls, access controls, and compliance measures
• Partner with analysts, software developers, and business stakeholders to translate requirements into technical solutions
• Create comprehensive documentation for systems, processes, and integrations
• Provide technical guidance on data availability and proper usage; enable self-service access
• Troubleshoot pipeline failures, performance issues, and data discrepancies; perform root cause analysis

Benefits

• Fully paid medical/dental/vision premiums
• Generous PTO
• 11 Paid Holidays
• 6% 401K contribution
• Annual training and tuition reimbursement
• SPOT Award bonuses
• Regular team events
• Opportunities for professional growth and advancement