Data Engineer (Data Extraction & Standardization)
Corner Alliance
·Today
- Location
- Gaithersburg, MD
- Workplace
- Remote
- Type
- Full-time
- Department
- Engineering
- Seniority
- Mid
- Experience
- 4+ years
- Clearance
- Required
- Closing date
- Today
- Source
- ApplyToJob
Description
**This role is contingent upon contract award**
Corner Alliance is a dynamic, growing consulting firm that devotes itself to providing an enriching employee experience while working in meaningful ways to create results for the government. We are currently seeking a Data Engineer with 4+ years of experience to join our team and fully embrace our commitment to deliver, grow, and thrive.
About the Role:
As a Data Engineer supporting our federal government client, you will be trusted to provide advanced data engineering and software development support to extend the client’s Controlled Vocabulary Curation System (CVCS) from a semantic metadata engine into a full data ingestion hub for CHIPS METIS research data. You will build automated pipelines that pull figures and tables out of published reports and convert messy, non-standard tabular data into standardized, schema-validated CSVs, making scientific assets machine-readable and discoverable in the METIS Discovery Portal.
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 structure and headers, and tag extracted figures and tables against CVCS ontologies
Update the CVCS user interface so domain experts can quickly validate extracted figures and correct OCR errors in table headers
Build a library of parsers that convert non-standard formats (such as Excel files with complex headers, legacy spreadsheets with merged cells, and instrument-specific ASCII dumps) into clean, machine-readable CSVs
Validate generated CSVs against METIS data schemas for column naming and data types, using heuristic cleanup for missing values, merged cells, and trailing metadata rows, and flag ambiguous cases for human review
Integrate the extraction and conversion tools as microservices or modules within the existing CVCS web application, and enable export of standardized CSVs and figure metadata to the METIS Discovery Portal
Produce design, deployment, and API documentation, and maintain documented code in the client’s public GitHub repository
Deliver demonstration presentations of the extraction and data conversion workflows
Prepare monthly progress reports covering progress, delays and mitigation, document processing statistics (such as figures extracted and OCR accuracy), CSV standardization success rates, and portal integration status
Carry out our Commitments to Deliver, Grow, and Thrive
Location:
You will work as part of a dynamic team primarily on-site at the client’s Gaithersburg, MD campus, Monday through Friday, 8:30 a.m. to 5:00 p.m. Remote work may be authorized with advance approval from the client or when the campus is closed.
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 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
Prior experience supporting NIST’s Software and Systems Division, the CHIPS program, or METIS
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.
About Us:
Corner Alliance offers a comprehensive and competitive benefits package for full-time employees including 401k matching (4%), PTO (3 weeks to start, 4 weeks (2-5 years) and 5 weeks (5 years+)), health, dental, vision, short- and long-term disability, FSA accounts, 4 weeks of paid parental leave, 11 paid holidays (including your birthday off), fitness & cell phone reimbursements, monthly all hands update meetings, annual in-person all hands team building day and evening out, regular check-ins for professional growth goals, semi-monthly one on one performance manager meetings, a social team that coordinates monthly events, use of technology like Slack to keep us connected and collaborative, and overall, a company culture dedicated to a highly engaged team.
Corner Alliance is an equal opportunity employer and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex (including pregnancy, gender identity, and sexual orientation), national origin, disability status, genetics, protected veteran status, or any other basis covered by applicable law. We are dedicated to building a talented workforce that reflects the strength of our society and our shared commitment to excellence. In compliance with the Americans with Disabilities Act Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position with Corner Alliance please call (202) 754-8120 or email [email protected]. Corner Alliance participates in the E-verify program and will provide the Federal Government with Form I-9 information to confirm work authorization in the U.S.
Visit us at www.corneralliance.com to learn more.
Securing Your Data:
Beware of fake employment opportunities using Corner Alliance’s name. Corner Alliance will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Corner Alliance ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Corner Alliance will only communicate with you through our ATS system JazzHR and/or emails that are generated by the corneralliance.com automated system – never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Corner Alliance that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected]. If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.
Salary:
Approximate Salary Estimate: $00 - $00 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.