Senior ETL & Data Warehouse Engineer

Jobtailor; Arlington (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

Jobtailor in Arlington, VA seeks a seasoned Data Engineer to design, develop, test, deploy, and maintain enterprise ETL and data integration processes for analytical workloads. You will analyze workflows, optimize performance, and implement robust data models and validation routines to ensure data quality.

The role requires strong SQL, experience with enterprise ETL tools, and collaboration with BI and business teams to support dashboards and reports across complex data environments.

Qualifications

• Experience leading enterprise ETL development efforts in complex environments.
• Strong SQL and data-quality emphasis across large data warehouses.
• Ability to translate business requirements into robust data transformation logic.

Responsibilities

• Design, develop, test, deploy, and maintain enterprise ETL and data integration processes.
• Analyze existing ETL workflows and recommend redesign, simplification, consolidation, optimization, or replacement of legacy logic.
• Develop batch and incremental data loads from operational systems into analytical warehouse structures.
• Develop and maintain transformation logic using SQL, PL/SQL, ETL tools, scripting languages, or other data-engineering technologies.
• Design and support fact tables, dimension tables, star schemas, snowflake schemas, data marts, and other dimensional models.
• Implement slowly changing dimensions, surrogate keys, historical tracking, aggregation, lookup, and reference-data patterns.
• Develop source-to-target mappings, transformation specifications, load rules, dependencies, and technical documentation.
• Work with application and functional teams to understand source data, business rules, relationships, and analytical requirements.
• Build validation and reconciliation processes for data completeness, accuracy, consistency, and integrity.
• Troubleshoot failed ETL jobs, data-quality issues, transformation errors, duplicate or missing records, schema changes, and system discrepancies.
• Optimize ETL processing and database components for performance, scalability, reliability, and maintainability.
• Develop restart, recovery, exception-handling, logging, audit, and monitoring capabilities.
• Support scheduling and orchestration of ETL workflows, batch jobs, dependencies, and reporting processes.
• Assess impacts of source-system, application, database, and business-rule changes.
• Modernize legacy ETL technologies and data-processing patterns.
• Participate in testing, defect resolution, reconciliation, release, migration, and production-validation activities.
• Collaborate with BI developers to support semantic models, reports, dashboards, and analytical use cases.
• Participate in Agile/SAFe activities including PI Planning, backlog refinement, iteration execution, demonstrations, testing, and release planning

Skills

ETL Development

SQL Skills

Data Warehousing

Data Integration

Batch Processing

Incremental Loading

Performance Optimization

Root-Cause Analysis

Dimensional Data Modeling

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or related field

Tools

Ab Initio

Informatica PowerCenter

Oracle Data Integrator

IBM DataStage

Talend

SSIS

Oracle Database

PL/SQL

Azure DevOps

BI Platforms

Job description

Jobtailor in Arlington, VA seeks a seasoned Data Engineer to design, develop, test, deploy, and maintain enterprise ETL and data integration processes for analytical workloads. You will analyze workflows, optimize performance, and implement robust data models and validation routines to ensure data quality.

The role requires strong SQL, experience with enterprise ETL tools, and collaboration with BI and business teams to support dashboards and reports across complex data environments.