ETL Data Architect

  • Baltimore, MD
  • Posted 1 day ago | Updated 1 day ago

Overview

On Site
Up to $70
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 36 Month(s)

Skills

ADF
Azure
Snowflake

Job Details

Responsibilities:

  • Data Transformation: Develop and optimize data transformations using cloud-based tools and technologies to cleanse, enrich, aggregate, and reshape data according to business requirements.
  • Load transformed data into cloud data warehouses (like Snowflake, Azure Synapse, or BigQuery) or data lakes for storage and further analysis.
  • Performance Optimization: Ensue efficient data processing and pipeline performance within on-premises and cloud environments by leveraging cloud-native services and optimizing resource utilization.
  • Utilizing cloud-specific tools and services (e.g., FiveTran, Snowpipe, Streams and Tasks, Azure Data Factory) for ETL processes.
  • Orchestration and Automation: Automate ETL workflows using orchestration tools or cloud-based workflow services.
  • Data Integration: Design and implement ETL pipelines that extract data from diverse cloud and on-premises sources (databases, APIs, files, etc.).
  • Collaborate with data analysts, systems analysts, developers and other stakeholders to understand data requirements and ensure the successful delivery of data for analytics and other business needs.
  • Create and/or update knowledge base articles regarding procedures, workflows, user guides, process run books, etc.
  • Participate within the change management process.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.