← Back to jobsJob ID col-cmv8h9ok008k9oz01hb7rranh

Information TechnologyPosted 30+ days ago

Data Engineer

Full-time
Hybrid
3+ years
$80K – $130K/yr
Posted 30+ days ago

Spatial Front, Inc. is seeking a Data Engineer to support its growing modernization team and enterprise data initiatives for Federal Government customers. The role designs, develops, modernizes, optimizes, and supports ETL processes, analytical data warehouses, data pipelines, dimensional models, data quality controls, and reporting environments.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Design, develop, test, deploy, and maintain enterprise ETL and data integration processes supporting analytical data warehouses and reporting environments
  • Analyze existing ETL workflows and recommend opportunities to redesign, simplify, consolidate, optimize, or replace legacy data-processing logic
  • Develop batch and incremental data loads that extract data from operational systems, transform data according to business and technical rules, and load analytical warehouse structures
  • Develop and maintain transformation logic using SQL, PL/SQL, ETL development tools, scripting languages, or other appropriate data-engineering technologies
  • Design and support analytical data warehouse structures including fact tables, dimension tables, star schemas, snowflake schemas, data marts, and other dimensional models
  • Implement slowly changing dimensions, surrogate keys, historical tracking, aggregation, lookup, reference-data, and other common data warehouse patterns
  • Develop and maintain source-to-target mappings, transformation specifications, load rules, dependencies, and supporting technical documentation
  • Work with application and functional teams to understand source-system data structures, business rules, code values, relationships, and downstream analytical requirements
  • Build data-validation and reconciliation processes to confirm completeness, accuracy, consistency, and integrity between source systems, ETL processing, warehouse structures, and downstream reports
  • Troubleshoot failed ETL jobs, data-quality issues, transformation errors, duplicate or missing records, schema changes, and discrepancies between operational and analytical systems
  • Optimize ETL processing for performance, scalability, reliability, and maintainability, including SQL tuning, bulk-processing techniques, parallel execution, load sequencing, and efficient data movement
  • Work with DBAs to optimize database structures, indexes, partitions, statistics, materialized views, and other physical database components supporting warehouse performance
  • Develop restart, recovery, exception-handling, logging, audit, and monitoring capabilities for production ETL processes
  • Support scheduling and orchestration of ETL workflows, dependencies, batch jobs, and downstream reporting processes
  • Assess the impact of source-system changes, application upgrades, database changes, and business-rule changes on existing ETL and warehouse processes
  • Support modernization of legacy ETL technologies and data-processing patterns to more maintainable and supportable approaches
  • Participate in testing, defect resolution, data reconciliation, release, migration, and production-validation activities
  • Create and maintain technical documentation including ETL designs, source-to-target mappings, data models, job flows, transformation rules, deployment procedures, and operational support guidance
  • Collaborate with BI developers to ensure warehouse structures and data pipelines support required 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
  • Other duties as assigned

Qualifications

  • Must be a U.S. Citizen with an active Secret security clearance or be able to obtain one
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related field; equivalent relevant experience may be considered
  • 3+ years of hands-on data engineering, ETL development, data warehousing, database development, or related enterprise data experience
  • Strong hands-on experience designing, developing, troubleshooting, and supporting ETL processes in complex enterprise environments
  • Strong SQL skills and experience working with Oracle or comparable relational databases
  • Experience developing complex data transformations, joins, aggregations, lookups, data cleansing, validation, and reconciliation logic
  • Strong understanding of analytical data warehouse concepts including facts, dimensions, star schemas, snowflake schemas, data marts, surrogate keys, and slowly changing dimensions
  • Experience developing source-to-target mappings and translating business and technical requirements into data transformation and loading logic
  • Experience with batch processing, incremental loading, scheduling, dependencies, restart/recovery, error handling, and production support of ETL processes
  • Experience troubleshooting data-quality, ETL, SQL, performance, and data-integration issues through structured root-cause analysis
  • Understanding of database performance considerations including indexing, partitioning, query optimization, bulk processing, and large-volume data movement
  • Strong written and verbal communication skills and ability to collaborate effectively with BI, database, application, infrastructure, and business teams

Preferred

  • Hands-on experience with one or more enterprise ETL technologies such as Ab Initio, Informatica PowerCenter, Oracle Data Integrator (ODI), IBM DataStage, Talend, SSIS, or comparable data integration tools
  • Strong experience with Oracle Database and PL/SQL, including packages, procedures, functions, cursors, bulk processing, and performance tuning, is a plus
  • Experience developing ETL solutions implemented primarily through SQL and stored procedures as well as through commercial ETL platforms
  • Experience modernizing, replacing, or consolidating legacy ETL processes and data warehouse workloads
  • Strong experience with dimensional data modeling, including star schemas, conformed dimensions, fact-table design, slowly changing dimensions, and analytical data marts
  • Experience supporting large enterprise data warehouses with high-volume batch loads and complex source-system dependencies
  • Experience with Oracle database performance features such as partitioning, materialized views, parallel processing, bulk operations, and query optimization
  • Experience with job scheduling or workload automation technologies used to coordinate enterprise batch and ETL processing
  • Experience with data-quality frameworks, reconciliation processes, metadata management, lineage, or data-governance practices
  • Knowledge of PeopleSoft HCM data structures, Oracle-based enterprise applications, or HR/payroll data is a plus
  • Experience working with business intelligence and analytics teams using Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), or comparable reporting platforms is a plus
  • Experience working in Agile or SAFe environments and using Azure DevOps (ADO) or a similar lifecycle-management tool
  • Experience supporting secured Federal or DoD enterprise systems is preferred
  • Oracle Database, data engineering, ETL, data warehousing, or related certification is a plus

Required skills

ETL DevelopmentSQLOracle DatabasePL/SQLData WarehousingDimensional Data ModelingData Quality and ReconciliationDatabase Performance TuningETL Scheduling and OrchestrationSecret Security ClearanceInformatica PowerCenterOracle Data Integrator (ODI)

Full job description

Spatial Front, Inc. is seeking a Data Engineer to support its growing modernization team and enterprise data initiatives for Federal Government customers. The role designs, develops, modernizes, optimizes, and supports ETL processes, analytical data warehouses, data pipelines, dimensional models, data quality controls, and reporting environments.

Responsibilities

  • Design, develop, test, deploy, and maintain enterprise ETL and data integration processes supporting analytical data warehouses and reporting environments
  • Analyze existing ETL workflows and recommend opportunities to redesign, simplify, consolidate, optimize, or replace legacy data-processing logic
  • Develop batch and incremental data loads that extract data from operational systems, transform data according to business and technical rules, and load analytical warehouse structures
  • Develop and maintain transformation logic using SQL, PL/SQL, ETL development tools, scripting languages, or other appropriate data-engineering technologies
  • Design and support analytical data warehouse structures including fact tables, dimension tables, star schemas, snowflake schemas, data marts, and other dimensional models
  • Implement slowly changing dimensions, surrogate keys, historical tracking, aggregation, lookup, reference-data, and other common data warehouse patterns
  • Develop and maintain source-to-target mappings, transformation specifications, load rules, dependencies, and supporting technical documentation
  • Work with application and functional teams to understand source-system data structures, business rules, code values, relationships, and downstream analytical requirements
  • Build data-validation and reconciliation processes to confirm completeness, accuracy, consistency, and integrity between source systems, ETL processing, warehouse structures, and downstream reports
  • Troubleshoot failed ETL jobs, data-quality issues, transformation errors, duplicate or missing records, schema changes, and discrepancies between operational and analytical systems
  • Optimize ETL processing for performance, scalability, reliability, and maintainability, including SQL tuning, bulk-processing techniques, parallel execution, load sequencing, and efficient data movement
  • Work with DBAs to optimize database structures, indexes, partitions, statistics, materialized views, and other physical database components supporting warehouse performance
  • Develop restart, recovery, exception-handling, logging, audit, and monitoring capabilities for production ETL processes
  • Support scheduling and orchestration of ETL workflows, dependencies, batch jobs, and downstream reporting processes
  • Assess the impact of source-system changes, application upgrades, database changes, and business-rule changes on existing ETL and warehouse processes
  • Support modernization of legacy ETL technologies and data-processing patterns to more maintainable and supportable approaches
  • Participate in testing, defect resolution, data reconciliation, release, migration, and production-validation activities
  • Create and maintain technical documentation including ETL designs, source-to-target mappings, data models, job flows, transformation rules, deployment procedures, and operational support guidance
  • Collaborate with BI developers to ensure warehouse structures and data pipelines support required 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
  • Other duties as assigned

Preferred

  • Hands-on experience with one or more enterprise ETL technologies such as Ab Initio, Informatica PowerCenter, Oracle Data Integrator (ODI), IBM DataStage, Talend, SSIS, or comparable data integration tools
  • Strong experience with Oracle Database and PL/SQL, including packages, procedures, functions, cursors, bulk processing, and performance tuning, is a plus
  • Experience developing ETL solutions implemented primarily through SQL and stored procedures as well as through commercial ETL platforms
  • Experience modernizing, replacing, or consolidating legacy ETL processes and data warehouse workloads
  • Strong experience with dimensional data modeling, including star schemas, conformed dimensions, fact-table design, slowly changing dimensions, and analytical data marts
  • Experience supporting large enterprise data warehouses with high-volume batch loads and complex source-system dependencies
  • Experience with Oracle database performance features such as partitioning, materialized views, parallel processing, bulk operations, and query optimization
  • Experience with job scheduling or workload automation technologies used to coordinate enterprise batch and ETL processing
  • Experience with data-quality frameworks, reconciliation processes, metadata management, lineage, or data-governance practices
  • Knowledge of PeopleSoft HCM data structures, Oracle-based enterprise applications, or HR/payroll data is a plus
  • Experience working with business intelligence and analytics teams using Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), or comparable reporting platforms is a plus
  • Experience working in Agile or SAFe environments and using Azure DevOps (ADO) or a similar lifecycle-management tool
  • Experience supporting secured Federal or DoD enterprise systems is preferred
  • Oracle Database, data engineering, ETL, data warehousing, or related certification is a plus
  • Enterprise ETL
  • Ab Initio
  • Informatica PowerCenter
  • Oracle Data Integrator
  • IBM DataStage
  • Talend
  • SSIS
  • Data integration tools
  • Oracle Database
  • PL/SQL
  • Packages
  • Functions
  • cursors
  • Performance tuning
  • SQL-based ETL
  • Stored procedures
  • Commercial ETL platforms
  • Legacy ETL modernization
  • Data warehouse modernization
  • Dimensional data modeling
  • Conformed dimensions
  • Fact-table design
  • Analytical data marts
  • Enterprise data warehouses
  • High-volume batch loads
  • Source-system dependencies
  • Oracle database performance
  • Materialized views
  • Parallel processing
  • Workload automation
  • Data-quality frameworks
  • Metadata management
  • Data lineage
  • Data governance
  • PeopleSoft HCM
  • Oracle enterprise applications
  • HR
  • payroll data
  • Business intelligence
  • Analytics platforms
  • Oracle Analytics Server
  • Oracle Analytics Cloud
  • Agile
  • SAFe
  • Azure DevOps
  • Lifecycle management tools
  • Federal enterprise systems
  • DoD enterprise systems
  • Oracle Database certification
  • Data engineering certification
  • ETL certification
  • Data warehousing certification

Benefits

  • Hybrid work arrangement: Crystal City, VA - On-Site/Hybrid
  • Full-time, W2 position

Company

  • Information technology solutions and business support services
  • Bethesda, Maryland, USA
  • http://www.spatialfront.com/pages/index.html
  • Founded in 2008
  • 501-1000 employees

Qualifications

  • Must be a U.S. Citizen with an active Secret security clearance or be able to obtain one
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related field; equivalent relevant experience may be considered
  • 3+ years of hands-on data engineering, ETL development, data warehousing, database development, or related enterprise data experience
  • Strong hands-on experience designing, developing, troubleshooting, and supporting ETL processes in complex enterprise environments
  • Strong SQL skills and experience working with Oracle or comparable relational databases
  • Experience developing complex data transformations, joins, aggregations, lookups, data cleansing, validation, and reconciliation logic
  • Strong understanding of analytical data warehouse concepts including facts, dimensions, star schemas, snowflake schemas, data marts, surrogate keys, and slowly changing dimensions
  • Experience developing source-to-target mappings and translating business and technical requirements into data transformation and loading logic
  • Experience with batch processing, incremental loading, scheduling, dependencies, restart/recovery, error handling, and production support of ETL processes
  • Experience troubleshooting data-quality, ETL, SQL, performance, and data-integration issues through structured root-cause analysis
  • Understanding of database performance considerations including indexing, partitioning, query optimization, bulk processing, and large-volume data movement
  • Strong written and verbal communication skills and ability to collaborate effectively with BI, database, application, infrastructure, and business teams
  • Hands-on experience with one or more enterprise ETL technologies such as Ab Initio, Informatica PowerCenter, Oracle Data Integrator (ODI), IBM DataStage, Talend, SSIS, or comparable data integration tools
  • Strong experience with Oracle Database and PL/SQL, including packages, procedures, functions, cursors, bulk processing, and performance tuning, is a plus
  • Experience developing ETL solutions implemented primarily through SQL and stored procedures as well as through commercial ETL platforms
  • Experience modernizing, replacing, or consolidating legacy ETL processes and data warehouse workloads
  • Strong experience with dimensional data modeling, including star schemas, conformed dimensions, fact-table design, slowly changing dimensions, and analytical data marts
  • Experience supporting large enterprise data warehouses with high-volume batch loads and complex source-system dependencies
  • Experience with Oracle database performance features such as partitioning, materialized views, parallel processing, bulk operations, and query optimization
  • Experience with job scheduling or workload automation technologies used to coordinate enterprise batch and ETL processing
  • Experience with data-quality frameworks, reconciliation processes, metadata management, lineage, or data-governance practices
  • Knowledge of PeopleSoft HCM data structures, Oracle-based enterprise applications, or HR/payroll data is a plus
  • Experience working with business intelligence and analytics teams using Oracle Analytics Server (OAS), Oracle Analytics Cloud (OAC), or comparable reporting platforms is a plus
  • Experience working in Agile or SAFe environments and using Azure DevOps (ADO) or a similar lifecycle-management tool
  • Experience supporting secured Federal or DoD enterprise systems is preferred
  • Oracle Database, data engineering, ETL, data warehousing, or related certification is a plus
  • 3+ years of hands-on data engineering, ETL development, data warehousing, database development, or related enterprise data experience.

Required skills

  • ETL Development, SQL, Oracle Database, PL/SQL, Data Warehousing, Dimensional Data Modeling, Data Quality and Reconciliation, Database Performance Tuning, ETL Scheduling and Orchestration, Secret Security Clearance, Informatica PowerCenter, Oracle Data Integrator (ODI)

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 10, 2026

Work mode

Hybrid

Job source

Ethic Leaf recruiter

Company

Information Technology

Information Technology & AI

Information technology solutions and business support services

See all 55 jobs from Information Technology →
  • Bethesda, Maryland, USA
  • Information Technology & AI
  • 501-1000 employees
  • Founded 2008
  • spatialfront.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs in United States

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleData WarehousingETL Development

just now

1d ago

New

Data Engineer

Full-timeOn-siteUnited StatesCompetitive

KGS Technology Group, Inc is seeking a Junior Data Engineer to develop, maintain, and optimize data pipelines and support data integration. The role involves working with datasets, databases, and data warehouses to build reliable, scalable data solutions.

Why similarSame roleData WarehousingSQL

Spring Health

1d ago

New

Senior GTM Data Engineer

Full-timeRemoteUnited States$159K – $175K/yr

Spring Health is hiring a Senior GTM Data Engineer to build and maintain the integrated data infrastructure supporting go-to-market analytics, automation, and AI agents.

Why similarSame roleDimensional Data ModelingSQL

Get new Data Engineer jobs in United States by email

Create job alert

Data Engineer

Information Technology · $80K – $130K/yr

Apply via Ethic Leaf