Senior ETL Consultant

Morph Enterprise; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Job summary

Morph Enterprise is seeking an ETL data engineer to support data operations for its Cloud Data Exchange in Washington, DC. The role focuses on ETL, data loading, and transformation using Azure tools across enterprise data systems.

The candidate will work with Azure Data Factory, Synapse, and Databricks, ensuring data governance and secure data handling while building end-to-end data pipelines and reports for decision-making.

Qualifications

• Strong knowledge of ETL processes and end-to-end pipelines.
• Experience with Azure Data Factory, Synapse, and SQL-based data loading.

Responsibilities

• Analyzes, designs, develops, implements, replicates, and supports complex enterprise data projects.
• Interacts with stakeholders to gather requirements and translate them into data solutions.
• Develops and optimizes end‑to‑end ETL pipelines across on‑premise and cloud systems.
• Establishes cloud and on‑premise connectivity across ADLS, ADF, Synapse, Databricks.
• Automates, monitors, and manages data pipelines and workflows.
• Ensures data governance, security, and reliability across systems.
• Develops complex queries and reports using SQL and BI tools.
• Familiar with data formats including CSV, XML, Parquet, AVRO.

Skills

ETL pipelines

Azure Data Factory

Azure Synapse

Databricks

Informatica PowerCenter

SQL

Data governance

Data warehousing

Azure data services

Data visualization tools

Education

Bachelor’s degree in Information Technology or related field

Tools

Azure Data Factory

Synapse

Databricks

Informatica PowerCenter

Apache NiFi

Apache Airflow

FME

MicroStrategy

Tableau

Esri ArcGIS

Job description

We are looking for an ETL data engineer to support data operations for its Cloud Data Exchange. The resource will utilize native Azure tools to perform ETL, data loading and data transformation tasks. The ETL data engineer will support the Enterprise Data team for data curation, processing, and transformation tasks. Specifically, the ETL data engineer will be responsible for the following tasks:

Responsibilities:

1. Analyzes, designs, develops, implements, replicates, and supports complex enterprise data projects.

2. Interfaces with other agencies, consult with and inform user departments on system requirements, advise on environment constraints and operating difficulties for the current state and advise and resolve problems using cloud solutions and develop and replicate future enhancements to District’s data systems.

3. Strong knowledge of Extraction, Transformation and Loading (ETL) processes using frameworks like Azure Data Factory, Synapse, Databricks, Informatica by gathering requirements from the stake holders or analyzing the existing code and perform enhancements or new development.

4. Establishing the cloud and on-premise connectivity in different systems like ADLS, ADF, Synapse, Databricks

6. Worked on creating end to end pipelines to load data by reading it from multiple sources or source systems and load to landing layer or SQL tables.

7. Familiarity/experience with data integration and data pipeline tools (e.g., Informatica, Synapse, Apache NiFi, Apache Airflow)

8. Familiarity/experience with various data formats including database specific (Oracle, SQL Server, DB2, Quickbase), text formats(CSV, XML) and Binary(Parquet, AVRO)

9. Develops, standardizes and optimizes existing data workflow/pipelines adhering to best practices.

10. Adhere and contribute to enterprise data governance standards by ensuring data accuracy, consistency, security, and reliability.

11. Automates, monitors, alerts, and manages data pipelines and workflows.

12. Analyzes and evaluates system changes to determine feasibility, provides alternative solutions, back-up, and rollback procedures.

13. Works on the development of new systems, upgrades and enhancements to existing systems and ensure systems follow approved standards and consistency after the changes.

14. Develops complex programs and reports in database query language.

15. Familiarity/experience with data visualization tools.

16. Familiarity/experience handling and securing sensitive data based on the level of the sensitivity

Minimum Education/Certification Requirements:

Bachelor’s degree in Information Technology or related field or equivalent experience

Skill Required

Strong knowledge for development of Extract-Transform-Load (ETL) processes, including end-to-end pipelines with data loading from multiple sources

Ability to gather and document requirements for data extraction, transformation and load processes

Understanding of data warehousing, data lake, business intelligence and information management concepts and standards.

Ability to advise internal and external customers on appropriate tools and systems for complex data processing challenges.

Knowledge and use of SQL for relational databases

Experience with various data formats including database specific (Oracle, SQL, Postgres, DB2), text formats (CSV, XML) and Binary (Parquet, AVRO)

Contribute to enterprise data governance standards by ensuring accuracy, consistency, security and reliability

Strong experience with Microsoft Azure tools such as Azure Data Factory, Synapse, SQL Database, Data Lake Storage Gen2, Blob Storage

Experience with data integration and data pipeline tools such as Informatica PowerCenter, Apache NiFi, Apache Airflow and FME

Experience with visualization and reporting software such as MicroStrategy, Tableau, and Esri ArcGIS

Experience performing data functions with Databricks