**This role is contingent upon contract award** As a Data Engineer supporting our federal government client, you will be trusted to provide advanced data engineering and software development support to enhance the client's data management and research capabilities. You will develop automated data pipelines to extract figures and tables from published research reports, transform complex and non-standard data into standardized, schema-validated formats, and improve the accessibility, searchability, and usability of scientific research data, making scientific assets machine-readable and discoverable through a centralized research data platform.
Key Responsibilities include (but are not limited to): - Develop tools to detect, crop, and extract figures and charts from PDF and DOCX documents, capturing captions and identifying axis labels and units using OCR and layout analysis
- Implement algorithms to extract embedded tables while preserving row and column structures and headers, and tag extracted figures and tables against established data ontologies.
- Enhance the existing web application's user interface to allow domain experts to validate extracted figures and correct OCR errors in table headers.
- Build a library of parsers to convert non-standard formats, including Excel files with complex headers, legacy spreadsheets with merged cells, and instrument-specific ASCII files, into clean, machine-readable CSVs.
- Validate generated CSVs against established data schemas for column naming and data types, using automated cleanup techniques to address missing values, merged cells, and trailing metadata rows, while flagging ambiguous cases for human review.
- Integrate extraction and conversion tools as microservices or modules within an existing web application, enabling the export of standardized CSVs and figure metadata to a centralized research data platform.
- Produce design, deployment, and API documentation, and maintain well-documented code in the client's public GitHub repository.
- Deliver demonstrations of data extraction and conversion workflows to stakeholders.
- Prepare monthly progress reports covering project milestones, challenges and mitigation strategies, document processing statistics, data extraction accuracy, CSV standardization success rates, and platform integration status.
- Carry out our Commitments to Deliver, Grow, and Thrive
Location: You will work onsite at our federal client's facility in Gaithersburg, MD.
Required Experience/Skills:
- Bachelor's degree (4-year) in Computer Science, Data Engineering, or a related field
- 4+ years of advanced Python programming, specifically Pandas and OCR libraries
- 4+ years of experience with OCR pipelines and table extraction logic
- 4+ years of experience with data format normalization and schema validation
- 4+ years of experience integrating microservices into web applications
- US citizenship or permanent residency and the ability to pass a public trust background investigation
Preferred Experience/Skills: - Experience supporting NIST, the Department of Commerce, or another federal research laboratory
- Experience with scientific or research data, such as instrument outputs, metadata, or ontologies
- Experience with document layout analysis and PDF parsing tools (for example, Tesseract)
- Experience building REST APIs and working in web application frameworks such as Django, with Docker and Git/GitHub
- Experience with CI/CD pipelines and open-source or public repository contributions
Don't think you have everything for this role but are still very interested? Please don't hold back from applying because you may not have it all. You can learn and grow with us. We're looking for someone who is coachable, unflappable in navigating challenges, resourceful in learning new skills, innovative in challenging the status quo, excellent in writing, analytical in thinking, skilled in prioritization, and a rapport builder with clients and colleagues.
Salary: Approximate Salary Estimate: $90,000 - $120,000 annually
The estimate displayed represents the typical salary range of candidates hired. Factors that may be used to determine your actual salary may include your specific skills, how many years of experience you have, and comparison to other employees already in this role.