We are seeking to hire a O&M 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: Operations & Maintenance Support for ADW Data Pipelines and Transformations
Role Summary:
The Data / ETL Engineer (mid-level) supports the Operations & Maintenance (O&M) team by maintaining existing ELT pipelines, documenting data flows, and assisting the client in creating new datasets and data transformations. This role focuses on troubleshooting issues, applying enhancements, developing new curated datasets (materialized views, star schemas), and ensuring reliable day-to-day operation of the data environment. The engineer collaborates closely with platform developers, OAC developers, and business users to sustain a stable and high-quality analytics ecosystem.
Key Responsibilities:
Pipeline Maintenance & Support
· Maintain and troubleshoot existing ADW SQL/PLSQL-based transformations and ELT pipelines.
· Resolve service tickets related to data quality issues, pipeline errors, performance problems, or schema changes.
· Monitor recurring jobs, validate outputs, and ensure timely and accurate data availability.
· Perform root-cause analysis for incidents and implement corrective and preventive actions.
Dataset & Transformation Enhancements
· Help design and build new data flows and curated datasets for client needs, including:
o Materialized views
o Star schemas (fact/dimension tables)
o Aggregations, snapshots, and summary logic
· Optimize existing queries, transformations, and materialized views for speed and cost efficiency.
· Support schema evolution, indexing strategies, partition tuning, and structural refinements as needed.
Documentation & Operational Readiness
· Document current-state transformations, lineage, data logic, and pipeline dependencies.
· Update and improve runbooks, data dictionaries, and operational SOPs.
· Ensure all enhancements and fixes follow established standards and are easily maintainable by future support teams.
Client Collaboration & Continuous Improvement
· Work with business stakeholders and OAC developers to validate dataset accuracy and resolve upstream issues.
· Assist the client in defining and refining new data flows based on business requirements.
· Participate in regular O&M review cycles, backlog discussions, and prioritization activities.
· Recommend incremental improvements to stability, monitoring, and data quality.
Required Qualifications:
· 5+ years of experience as a Data Engineer, ETL/ELT Developer, or comparable analytics data role.
· Strong to advanced SQL/PLSQL experience, including tuning, debugging, and working with complex transformations.
· Experience maintaining and enhancing pipelines in Oracle ADW or similar cloud data warehouses.
· Ability to build and optimize star schemas, materialized views, and analytic datasets.
· Understanding of dimensional modeling, relational modeling, and data quality concepts.
· Experience troubleshooting data issues in production or quasi-production environments.
Preferred Qualifications:
· Familiarity with GoldenGate or other replication technologies.
· Experience documenting data flows, lineage, and transformation logic in a structured manner.
· Exposure to Oracle Data Integration tools (ODI, ODI-C) or other ETL/ELT environments.
· Experience supporting ticket-based O&M workflows or Tier-2/Tier-3 data issue triage.
· Knowledge of OAC semantic layer dependencies and upstream impact considerations.
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.
