

ETL Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an ETL Architect on a contract basis in Towson, MD, offering competitive pay. Requires a Bachelor’s degree with 5+ years of ETL experience, SQL Server expertise, and K-12 industry knowledge. On-site work is mandatory.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
August 8, 2025
🕒 - Project duration
Unknown
-
🏝️ - Location type
On-site
-
📄 - Contract type
Unknown
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#SSIS (SQL Server Integration Services) #"ETL (Extract #Transform #Load)" #Security #Scala #Data Modeling #Databases #Cloud #SQL (Structured Query Language) #Azure Data Factory #Compliance #Data Mapping #Scripting #Data Warehouse #ADF (Azure Data Factory) #Azure #MS SQL (Microsoft SQL Server) #SQL Server #Data Integrity #Migration #Documentation #DBA (Database Administrator) #Business Analysis #Data Governance #Logging
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
Title: ETL Analyst / Developer - Data Warehouse Developer with ETL tools expertise
Position Type: Contract
Location: Towson, MD, United States
Need 1 good profile with 3 references.
Required Skills
Bachelor’s degree plus 5+ years exp, or 10+ years exp if no degree
5 years’ experience working with ETL
Support data analytics team in retrieving data and summarizing data, converting data from different sources
Ability to work with SQL Server DBA, system architect, and application developers to design stable, reliable, effective and optimized databases
SQL Server scripting, data modeling,
Experience knowing how to manage computers and peripherals
Ability to manage concurrent requests and multiple priorities / strong multi-tasking skills
Understands data warehousing principles, concepts and architecture
Experience and knowledge with SQL Scripting
Familiarity with MS SQL Server databases and has used an SQL instance in an Azure context
Experience in K-12 school systems is highly desired
Job Duties & Responsibilities
Design, develop, and maintain ETL workflows to extract, transform, and load data from diverse source systems into the data warehouse.
Monitor and optimize ETL job performance, ensuring efficiency, scalability, and minimal downtime.
Troubleshoot and resolve ETL-related production issues, including data integrity, performance, and scheduling problems.
Collaborate with business analysts and data owners to define data mapping, transformation rules, and quality checks.
Create and maintain technical documentation for ETL processes, data flows, and system integrations.
Implement error handling, logging, and notification mechanisms for ETL pipelines to ensure reliability.
Support the migration of legacy ETL processes to modern platforms or cloud environments (e.g., Azure Data Factory, SSIS).
Assist in the design and enforcement of data governance, security, and compliance standards.
Work closely with reporting and analytics teams to ensure timely and accurate data availability for dashboards and reports.
Participate in capacity planning, performance tuning, and database optimization for SQL Server and Azure-hosted databases.
Stay current with emerging ETL tools, cloud technologies, and best practices to recommend improvements to the existing architecture.