Abaco Strategy LLC
ETL Developer - EPA
Abaco Strategy LLC, Jacksonville, FL
Abaco Strategy, LLC (Abaco) is an 8(a) Certified, HUBZone, Woman Owned, Small Business located in Leesburg, VA. Abaco provides Information Technology and Consulting Services to Commercial customers and the Federal Government. We deliver technology-enabled, results-oriented solutions. We build long-term business relationships by ensuring the availability of highly skilled and certified resources providing a broad range of capabilities that meet the unique needs of all customers. We leverage industry best practices and business innovations to provide measurable results. We are seeking a highly skilled and detail-oriented ETL Developer to join our team. The successful candidate will be responsible for data extraction, validation, and transfer tasks, working with a variety of national and regional databases from EPA, DOE, DoD, and other federal and state sources. The role involves ensuring data integrity, accuracy, and completeness across various systems.
Key Responsibilities:
Experience:
Additional Requirements:
Education: Bachelor's degree in computer science, Information Technology, or a related field.
Ability to obtain and maintain a public trust.
Abaco Strategy, LLC (Abaco) is an 8(a) Certified, HUBZone, Woman Owned, Small Business located in Leesburg, VA. Abaco provides Information Technology and Consulting Services to Commercial customers and the Federal Government. We deliver technology-enabled, results-oriented solutions. We build long-term business relationships by ensuring the availability of highly skilled and certified resources providing a broad range of capabilities that meet the unique needs of all customers. We leverage industry best practices and business innovations to provide measurable results.
Abaco is an EOE/Affirmative Action Employer. We understand the value of diversity and its impact on a high-performance culture. Prospective employees will receive consideration without discrimination because of race, color, religion, creed, gender, national origin, age, disability, marital or veteran status, sexual orientation, or any other legally protected status. We are a military friendly organization and veterans are encouraged to apply. Federal law requires all employers to verify the identity and eligibility of all persons hired to work in the United States.
As a HUBZone certified company, we encourage applicants who live in HUBZones, as designated by the Small Business Administration (SBA). For more information visit the SBA HUBZone map.
Key Responsibilities:
- Data Extraction: Receive and/or extract data from multiple sources, including but not limited to:
- Superfund Enterprise Management System (SEMS)
- ReportLink
- RCRA Info
- Institutional Control Tracking System (ICTS)
- COMPASS Data Warehouse (CDW)
- Facility Registry Service (FRS)
- Budget Formulation System (BFS)
- Unliquidated Obligation/Recertification Database
- Data Validation: Validate the extracted data by reviewing and cross-referencing EPA standard forms for accuracy and completeness. Compare outputs from various systems to ensure data consistency and completeness.
- Data Correction: Obtain missing data and correct errors to maintain data integrity. Submit official change requests and/or enter corrected data into the corresponding databases and systems.
- Data Transfer: Input selected validated information into various databases, ensuring accurate data entry and consistency between systems.
- Documentation: Maintain comprehensive documentation of data extraction, validation, and transfer processes. Ensure all activities are compliant with regulatory standards and internal procedures.
Experience:
- Minimum of 3-5 years of experience in ETL development and data management.
- Experience working with Oracle databases and other related technologies.
- Familiarity with federal and state data systems and standards is a plus.
- Technical Skills:
- Proficiency in ETL tools and technologies (e.g., Informatica, Talend, SSIS).
- Strong SQL skills and experience with Oracle Database.
- Knowledge of data validation techniques and tools.
- Familiarity with GIS integration and web services (SOAP/REST) is advantageous.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and commitment to data integrity.
- Effective communication skills, both written and verbal.
- Ability to work independently and as part of a team.
Additional Requirements:
Education: Bachelor's degree in computer science, Information Technology, or a related field.
Ability to obtain and maintain a public trust.
Abaco Strategy, LLC (Abaco) is an 8(a) Certified, HUBZone, Woman Owned, Small Business located in Leesburg, VA. Abaco provides Information Technology and Consulting Services to Commercial customers and the Federal Government. We deliver technology-enabled, results-oriented solutions. We build long-term business relationships by ensuring the availability of highly skilled and certified resources providing a broad range of capabilities that meet the unique needs of all customers. We leverage industry best practices and business innovations to provide measurable results.
Abaco is an EOE/Affirmative Action Employer. We understand the value of diversity and its impact on a high-performance culture. Prospective employees will receive consideration without discrimination because of race, color, religion, creed, gender, national origin, age, disability, marital or veteran status, sexual orientation, or any other legally protected status. We are a military friendly organization and veterans are encouraged to apply. Federal law requires all employers to verify the identity and eligibility of all persons hired to work in the United States.
As a HUBZone certified company, we encourage applicants who live in HUBZones, as designated by the Small Business Administration (SBA). For more information visit the SBA HUBZone map.