Quick Overview
Job Description
15+ Years of Experience Required
Job Description:
We are looking for a Senior ETL Data Engineer to support an enterprise data team in Washington, DC. This is a 100% onsite role focused on building, enhancing, and supporting data pipelines and data transformation processes using Microsoft Azure technologies.
- Strong hands-on experience with ETL and end-to-end data pipelines
- Azure Data Factory (ADF), Azure Synapse, Azure SQL, ADLS Gen2, and Blob Storage
- Strong SQL experience with relational databases
- Experience working with Oracle, PostgreSQL, DB2, CSV, XML, Parquet, and AVRO
- Experience with data integration tools such as Informatica, Apache NiFi, Airflow, or FME
- Experience gathering requirements and developing data extraction, transformation, and loading solutions
- Knowledge of data warehousing, data lakes, BI, and data governance
- Ability to monitor, automate, troubleshoot, and optimize data pipelines
- Strong communication skills and ability to work with business and technical stakeholders
- Databricks and Python experience is a plus
- Visualization experience with Tableau, MicroStrategy, or Esri ArcGIS is a plus
Required / Desired Skills
Skill | Required / Desired | Amount | of Experience |
Strong knowledge for development of Extract-Transform-Load (ETL) processes, including end-to-end pipelines with data loading from multiple sources | Required | 15 | Years |
Ability to gather and document requirements for data extraction, transformation and load processes | Required | 15 | Years |
Understanding of data warehousing, data lake, business intelligence and information management concepts and standards. | Required | 15 | Years |
Ability to advise internal and external customers on appropriate tools and systems for complex data processing challenges. | Required | 15 | Years |
Knowledge and use of SQL for relational databases | Required | 11 | Years |
Experience with various data formats including database specific (Oracle, SQL, Postgres, DB2), text formats (CSV, XML) and Binary (Parquet, AVRO) | Required | 11 | Years |
Contribute to enterprise data governance standards by ensuring accuracy, consistency, security and reliability | Required | 7 | Years |
Strong experience with Microsoft Azure tools such as Azure Data Factory, Synapse, SQL Database, Data Lake Storage Gen2, Blob Storage | Required | 5 | Years |
Experience with data integration and data pipeline tools such as Informatica PowerCenter, Apache NiFi, Apache Airflow and FME | Required | 5 | Years |
Experience with visualization and reporting software such as MicroStrategy, Tableau, and Esri ArcGIS | Highly desired | 3 | Years |
Strong communication skills, both oral and written | Required | 3 | Years |
Ability to provide excellent customer service to external partners | Required | 3 | Years |
Ability to work independently or as part of a larger team | Required | 3 | Years |
Experience performing data functions with Databricks | Highly desired | 3 | Years |
Similar jobs
- BA
Technical Data Engineer, Senior with Security Clearance
NewBooz Allen Hamilton
Herndon, VA🇺🇸$99k - $225k/yrOn-site22 hours agoDockerMongoDBShell+11Technology - RS
ETL Data Engineer
NewRishabh Software Pvt. Ltd
Washington, DC🇺🇸Hybrid22 hours agoOracleSQLSQL Server+8Technology - KS
Data Quality Engineer
NewKeypixel Software Solutions
United States🇺🇸Hybrid22 hours agoEngineering - MC
Palantir Foundry Engineer
Maven Companies
United States🇺🇸Hybrid5 weeks agoEngineering - BA
Mid Databricks Lakehouse Engineer and Analyst
NewBooz Allen Hamilton
McLean, VA🇺🇸$77.6k - $176k/yrOn-site22 hours agoIoTUnityEngineering - SS
senior data engineer (only former cap one contractors)
NewSpear Staffing
United States🇺🇸$90/hrRemote22 hours agoDynamoDBAWSSnowflake+4Technology