Senior ETL Data Engineer - Cloud & On-Prem Pipelines

NFF Inc; Washington (District of Columbia); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

Health Savings Account (HSA)

Flexible Spending Account (FSA)

Comprehensive 401k plan

Paid Time Off

Job summary

NFF Inc in Washington, DC seeks an experienced ETL Data Engineer to lead end-to-end data pipelines and governance across cloud and on-prem systems. The role emphasizes reliable processing, automation, and monitoring, supporting enterprise data initiatives for multiple agencies.

You will design and implement ETL architectures, collaborate with stakeholder teams to refine requirements, and ensure data quality and security across diverse data sources, formats, and platforms.

Qualifications

• Bachelor’s degree in IT or a related field or equivalent experience.
• 15+ years in ETL development and end-to-end data pipelines.
• Strong experience with data warehousing concepts and data lake environments.
• Expertise in SQL and database programming for relational systems.
• Ability to advise customers on data processing tools and architectures.
• Experience with Azure cloud services and on-prem connectivity.
• Detail-oriented with a focus on data accuracy, security, and governance.
• Excellent communication skills with internal and external partners.

Responsibilities

• Analyze, design, develop, implement, and support complex enterprise data projects across the ETL lifecycle.
• Gather requirements, review code, and deliver enhancements for district data systems.
• Collaborate with agencies to define system requirements and operational constraints.
• Design ETL pipelines loading data from multiple sources into landing layers and SQL tables.
• Establish cloud and on-prem connectivity (ADLS, ADF, Synapse, Databricks).
• Develop standardized data workflows with a focus on accuracy and reliability.
• Automate, monitor, alert, and manage pipeline execution and operations.
• Define backup and rollback procedures and handle sensitive data securely.

Skills

ETL Development

SQL

Data Governance

Azure Data Factory

Azure Synapse

Databricks

Python

Data Warehousing

Stakeholder Communication

Education

Bachelor’s degree

Tools

Informatica PowerCenter

Apache NiFi

Apache Airflow

FME

Databricks

SQL Server

Azure Data Lake Storage Gen2

Azure SQL DB

Job description

NFF Inc in Washington, DC seeks an experienced ETL Data Engineer to lead end-to-end data pipelines and governance across cloud and on-prem systems. The role emphasizes reliable processing, automation, and monitoring, supporting enterprise data initiatives for multiple agencies.

You will design and implement ETL architectures, collaborate with stakeholder teams to refine requirements, and ensure data quality and security across diverse data sources, formats, and platforms.