AL
Data / ETL Engineer (O&M)
Artech LLC
- 🇺🇸 United States
- Remote
- 20 hours ago
- $80 – $85 / hour
- ETL
- ELT
- SQL
- PL/SQL
- Oracle
- triage
20 hours ago
Duration – 8 Months
Location – 100% Remote EST
Project Focus: Operations & Maintenance Support for ADW Data Pipelines and Transformations
Job Description
Experience Level: 3–5+ years
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:
– Materialized views
– Star schemas (fact/dimension tables)
– 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:
• 3–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.
Data / ETL Engineer (O&M) · Artech LLC