Azure ETL Data Engineer – Cloud Data Pipelines

Advanced American Technologies, Inc; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Job summary

OCTO in Washington, DC seeks an ETL Data Engineer to support the Cloud Data Exchange. You will build and optimize end-to-end pipelines using Azure tools, loading and transforming data from multiple sources into landing layers and SQL tables.

Responsibilities include governance, monitoring, and automation of data workflows, with strong SQL and multi-format data experience. Collaboration with agencies and stakeholders is essential.

Qualifications

• Strong knowledge of ETL design and end-to-end pipelines across multiple sources.
• Ability to document requirements for data extraction, transformation and load processes.
• Experience with data warehousing, data lake, BI concepts and standards.
• Ability to advise internal and external customers on tools for complex data processing.
• Proficiency in SQL for relational databases.
• Familiarity with data formats like Oracle, SQL Server, DB2, CSV, XML, Parquet, AVRO.
• Experience with Azure tools (ADF, Synapse, SQL DB, ADLS Gen2, Blob Storage).
• Experience with data integration tools like Informatica, NiFi, Airflow, FME.
• Experience with visualization/reporting tools such as MicroStrategy/Tableau/Esri ArcGIS.

Responsibilities

• Analyze, design, develop, implement, replicate, and support complex data projects.
• Coordinate with agencies and user departments on system requirements and constraints.
• Develop end-to-end ETL pipelines using Azure data services.
• Establish cloud and on‑premise connectivity across systems.
• Load data into landing layers or SQL tables from multiple sources.
• Create and optimize data pipelines and governance standards.
• Automate, monitor, alert, and manage data workflows.
• Evaluate system changes and provide feasible alternatives.
• Develop new systems and upgrades following approved standards.
• Develop complex programs and database queries.

Skills

ETL pipelines

Azure Data Factory

Azure Synapse

Databricks

Informatica

SQL

Data governance

Education

Bachelor's degree in IT/related field

Tools

Azure Data Factory

Synapse

Databricks

Informatica

Power BI

Job description

OCTO in Washington, DC seeks an ETL Data Engineer to support the Cloud Data Exchange. You will build and optimize end-to-end pipelines using Azure tools, loading and transforming data from multiple sources into landing layers and SQL tables.

Responsibilities include governance, monitoring, and automation of data workflows, with strong SQL and multi-format data experience. Collaboration with agencies and stakeholders is essential.