ETL Data Engineer

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 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

• 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, 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