We are seeking to hire a Data / ETL Engineer, to join our teams working on a new multi-year award we have within a Federal Gov’t Agency. This role is 100% remote.
Being a US Cit or Permanent Resident is required for passing the security clearance to work on this program.
This position pays a strong salary package with full benefits (including choice of healthcare plans, dental, vision, life insurance, 3 weeks PTO, 11 Paid Federal Holidays, and a matching 401k).
An option for working on an hourly rate is also available for those not needing a full benefits package.
Role Title: Data / ETL Engineer
Experience Level: 5+ years
Project Focus: Data Platform Build — ADW Pipelines, Dataset Creation, and GoldenGate Integration
Role Summary:
· The Data / ETL Engineer (mid-level) contributes to the design and build of a modern data platform on Oracle Autonomous Data Warehouse (ADW).
· The engineer develops performant SQL-driven ELT pipelines, creates new curated datasets (including materialized views and star schemas), and assists with replication flows leveraging GoldenGate.
· This role focuses on high-quality build execution, strong data modeling capability, and iterative delivery within a collaborative project team.
· The engineer works under the guidance of senior developers and the Data Architect to deliver scalable, maintainable, production-ready data assets.
Key Responsibilities:
Data Pipeline & Dataset Development
· Develop, enhance, and optimize SQL/PLSQL-based ELT pipelines for loading and transforming data into ADW.
· Build new curated datasets, including:
o Materialized views for analytical consumption
o Star schemas (fact and dimension tables)
o Summary, snapshot, and conformed data structures
· Conduct performance tuning across queries, transformations, and materialized views.
· Implement data quality checks, automated validations, and reconciliation logic as part of each pipeline.
GoldenGate & Data Integration Support
· Assist in configuring and updating GoldenGate replication flows for new data sources and schema changes.
· Validate replicated data and troubleshoot replication delays, failures, or out-of-sync conditions.
Modeling, Quality & Documentation
· Work with the Data Architect to translate business requirements into logical and physical data models.
· Support data modeling activities such as partitioning strategies, indexing, and schema design.
· Produce documentation, data dictionaries, technical flows, and runbooks to support long-term maintainability.
Collaboration & Delivery
· Participate in sprint ceremonies, provide task estimates, and deliver iterative improvements.
· Work closely with OAC developers to ensure datasets support semantic layer and reporting requirements.
· Collaborate with QA, platform engineering, and analysts to validate data outputs.
Required Qualifications:
· 5+ years of experience as a Data Engineer, ETL/ELT Developer, or similar role.
· Advanced SQL proficiency including complex joins, window functions, query optimization, and performance tuning.
· Hands-on experience with Oracle ADW, Oracle Database, or similar cloud data warehouse technologies.
· Experience designing and building star schemas, materialized views, and analytical data models.
· Familiarity with data replication concepts (GoldenGate preferred).
· Strong understanding of relational and dimensional modeling.
Preferred Qualifications:
· Experience with automated data quality frameworks or test-driven data development.
· Exposure to Oracle Data Integration tools (ODI, ODI-C) or other ETL/ELT platforms (Informatica, Talend, DataStage).
· Experience building cloud-based data platforms or pipelines (OCI preferred).
· Background in agile delivery, DevOps for data, or ELT orchestration frameworks.
· Ability to profile data, assess data quality, and recommend structural improvements.
If qualified and interested, please send an updated resume along with rate/salary requirement and we will follow up quickly to discuss further details and move forward with your interview process.
ec3 Federal Services is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. ec3 Federal Services is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at ec3 are based on business needs, job requirements and individual qualifications, without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV Status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. ec3 Federal Services will not tolerate discrimination or harassment based on any of these characteristics.
