Position Summary: The Senior ETL Data Engineer supports cloud data operations by designing, developing, and deploying enterprise-level Extract, Transform, Load (ETL) data pipelines. This role curates, processes, and standardizes data across cloud and on-premise platforms while maintaining enterprise data governance, security, and quality standards.
Key Responsibilities:
Designs, develops, tests, and supports complex end-to-end data pipelines to ingest data from multiple sources into target tables and landing layers.
Establishes and manages connectivity between cloud and on-premise environments using platforms such as Azure Data Lake Storage (ADLS) Gen2, Blob Storage, Azure Data Factory, Synapse, and Databricks.
Automates, monitors, and optimizes existing data workflows to ensure system performance, data accuracy, security, and scalability.
Consults with business units and technical teams to gather requirements, resolve system issues, and evaluate technical feasibility for system enhancements.
Develops database queries, complex scripts, and reporting solutions to support enterprise business requirements.
Implements system change evaluations, backup procedures, and rollback plans to ensure high data reliability.
Serves as a technical subject matter expert (SME) on enterprise-wide data architecture and data governance best practices.
Required Qualifications & Skills:
Education: Bachelor's degree in Information Technology, Computer Science, or a related field (or equivalent experience).
ETL & Data Architecture: 10 to 15 years of experience developing end-to-end ETL processes, data architecture, data warehousing, and business intelligence solutions.
Database & Querying Skills: 10+ years of hands-on experience using SQL for relational databases (e.g., Oracle, SQL Server, Postgres, DB2).
Data Formats: 10+ years of experience working with diverse data formats, including relational, text (CSV, XML), and binary formats (Parquet, AVRO).
Data Governance: 7+ years of experience maintaining data governance, data security, and data consistency standards.
Cloud Solutions: 5+ years of hands-on experience with Microsoft Azure tools, including Azure Data Factory, Synapse Analytics, SQL DB, Data Lake Storage Gen2, and Blob Storage.
Pipeline Integration: 5+ years of experience utilizing integration tools such as Informatica PowerCenter, Apache NiFi, Apache Airflow, or FME.
Core Competencies: Strong written and verbal communication skills with a proven ability to collaborate across multidisciplinary teams and support external partners.
Preferred Qualifications:
Experience performing advanced data functions using Databricks.
Familiarity with data visualization and reporting tools such as MicroStrategy, Tableau, or Esri ArcGIS.
Experience with Python scripting for data pipeline automation.
Numbers & Facts
Location
Washington, DC
Salary
$120,000–$145,000 Per Year
Skills
Apacheunmatched
Apache Avrounmatched
ArcGISunmatched
Automationunmatched
Best Practicesunmatched
Business Intelligenceunmatched
Business Solutionsunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Computer Scienceunmatched
Consultingunmatched
Cross-Functionalunmatched
Data Formatsunmatched
Data Lakeunmatched
Data Managementunmatched
Data Processingunmatched
Data Qualityunmatched
Data Storageunmatched
Data Visualization Toolsunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Database Programmingunmatched
Database Report Toolsunmatched
Feasibility Analysisunmatched
High Reliabilityunmatched
IBM DB2unmatched
Informaticaunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
MicroStrategyunmatched
Microsoft SQL Serverunmatched
Microsoft Windows Azureunmatched
Operational Supportunmatched
Oracle Databaseunmatched
PostgreSQLunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Python Programming/Scripting Languageunmatched
Quality Metricsunmatched
Relational Databases (RDBMS)unmatched
Requirements Managementunmatched
SQL Databasesunmatched
Scripting (Scripting Languages)unmatched
Software Engineeringunmatched
Systems Analysisunmatched
Tableauunmatched
Team Playerunmatched
Technical Analysisunmatched
Test Plan/Scheduleunmatched
Writing Skillsunmatched
XML (EXtensible Markup Language)unmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.