Note: The job is a remote job and is open to candidates in USA. Copperhead Technologies provides management consulting services to U.S. government agencies. The Data Engineer will support the Veterans Affairs Data Collection Tool program through data engineering, ETL pipeline operations, quality assurance, reporting, and system maintenance.
Responsibilities
- Operate and maintain the ETL pipeline that moves data from VA's Behavioral Health Lab (BHL) COTS product into the VA Enterprise Cloud and ultimately into VA's Power BI environment, monitoring transfer schedules, resolving disruptions, and responding to system alerts
- Track, archive, and quality-check grantee-submitted data, maintains dashboards for VA program monitoring, and supports compliance and site administration needs
- Coordinates with VA and vendors on new requirements driven by policy or Congressional changes, updates ETL processes accordingly, and supports the DCT's Authority to Operate (ATO), systems configuration, and ongoing maintenance planning
- Research and coordinate with VA to recommend processes enabling grant managers to review and monitor compliance using individualized development plans and provides guidance on how the DCT can further support this process going forward
- Manage data quality assurance protocols governing the archiving, security, and analysis of data used in monthly, quarterly, and annual reports, and analyzes grantee data to compile briefings and reports for regular dissemination to VA on those cadences
- Document new DCT requirements arising from Congressional feedback and program policy changes, coordinates with VA and other vendors on the design of new online data collection forms resulting from policy changes, and updates ETL processes accordingly to prepare data for ingestion into the analytics platform
- Recommend requirements, design, and testing approaches that reduce ongoing maintenance burden and cost to VA, helps define roles and responsibilities for data engineering, management support, and quality assurance functions over time
- Support maintenance of the DCT's enterprise cloud Authority to Operate (ATO), and assists VA with systems configuration efforts in coordination with the VA COTS vendor
Skills
- Bachelor's degree in computer science, information systems, data engineering, or a related field
- 5+ years of experience in data engineering, ETL development, or database/application administration, ideally supporting federal government programs
- Hands-on experience operating and troubleshooting ETL pipelines that move data between systems, including COTS products and cloud environments
- Experience with Power BI, including data ingestion, dataset preparation, and dashboard support
- Experience managing data archiving, retention, and filtering processes in a database environment
- Ability to monitor system logs and alerts, and to diagnose and resolve operational issues
- Experience compiling data analyses and reports on recurring (monthly, quarterly, annual) schedules
- Outstanding communication skills, influencing abilities, and client focus
- Professional proficiency in English is required
- Demonstrated proficiency in using all Microsoft Office applications
- Ability to access federal facilities in compliance with Real ID. More information about Real ID can be found here:
- Applicants must be currently authorized to work in the United States on a full-time basis. Copperhead Technologies will not sponsor applicants for work visas for this position
- Master's degree in business administration, information systems, data engineering, or a related field
- Experience supporting VA systems or other federal health/benefits data programs working with PHI data
- Experience with Behavioral Health Lab (BHL) or similar COTS clinical/grantee data collection tools
- Experience acting as a site administrator for a federal web application
Benefits
- Health, Dental, and Vision Insurance
- Flexible Spending Accounts
- Life and Disability Insurance
- 401(k)
- Paid Time Off
- Paid Holidays
- Employee Assistance Program
- Pet Insurance
Company Overview