SGS Technologie

ETL Architect / Data Architect

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for an ETL Architect / Data Architect in Tallahassee, FL, on a long-term contract with a pay rate of "unknown." Candidates should have 7+ years of ETL experience, 3+ years with Azure tools, and relevant certifications preferred.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
Unknown
-
πŸ—“οΈ - Date
October 16, 2025
πŸ•’ - Duration
Unknown
-
🏝️ - Location
On-site
-
πŸ“„ - Contract
W2 Contractor
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Tallahassee, FL
-
🧠 - Skills detailed
#Data Lake #Data Warehouse #Compliance #Scala #Microsoft Azure #Data Integration #Datasets #Cloud #Data Transformations #Leadership #Python #Spark (Apache Spark) #Azure Synapse Analytics #Data Accuracy #Databricks #Synapse #Azure Data Factory #Data Engineering #"ETL (Extract #Transform #Load)" #Security #Azure #SQL (Structured Query Language) #Documentation #Data Architecture #Azure Databricks #Azure cloud #Computer Science #ADF (Azure Data Factory) #Data Governance
Role description
Job Title: ETL Architect / Data Architect Location: Tallahassee, FL (On-site) Type: Long-Term Contract Overview: We are seeking experienced ETL Architects / Data Architects to join client's Information Technology team in Tallahassee, FL. The ETL Architects will serve as the principal technical lead for data integration initiatives, focusing on developing scalable, secure, and high-performing ETL pipelines within the Correction Information Management System (CIMS) Data Warehouse/Data Lake hosted on Azure Cloud. Key Responsibilities: ETL Pipeline Design & Development: β€’ Lead design, development, and optimization of ETL processes integrating and transforming data across multiple sources. β€’ Utilize Azure Data Factory (ADF) to automate workflows and ensure smooth data flow from source to target. β€’ Deliver efficient, reliable, and secure pipelines meeting business and compliance needs. Data Integration & Transformation: β€’ Build and manage complex ETL workflows for downstream analytics and reporting. β€’ Ensure data accuracy, timeliness, and integrity through validation and quality checks. β€’ Develop resilient ETL processes that ensure only trusted data reaches the destination. Cloud Platform Expertise: β€’ Leverage Azure ecosystem: ADF, Databricks, Synapse Analytics, and Purview for processing structured and unstructured data. β€’ Integrate large datasets into Azure Synapse to support analytics teams and enable actionable insights. Performance Optimization: β€’ Continuously optimize ETL jobs to maximize throughput and minimize latency. β€’ Ensure architecture supports fast, reliable access to data for users and systems. Security & Compliance: β€’ Embed security best practices throughout ETL processes. β€’ Ensure compliance with data governance policies using Azure Purview to track lineage and enforce standards. Collaboration & Leadership: β€’ Partner with cross-functional teams (data engineers, analysts, business stakeholders, and security experts) to design and implement ETL solutions. β€’ Provide technical leadership and mentorship to junior team members. Documentation & Best Practices: β€’ Develop and maintain clear documentation for ETL processes and workflows. β€’ Establish and enforce best practices for data handling, ETL development, and security. Required Qualifications: β€’ Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent work experience). β€’ 7+ years of ETL development and data engineering experience. β€’ 3+ years of hands-on experience with ADF, Azure Databricks, Azure Synapse Analytics, and Azure Purview. β€’ Expertise in Spark, Python, and/or Scala for large-scale data transformations. β€’ Strong SQL skills and experience with complex data structures. β€’ Knowledge of data governance, security protocols, and RBAC in Azure. β€’ Ability to design resilient, efficient, and compliant ETL processes. β€’ Successful completion of Level II Background Check required. Preferred Qualifications: β€’ Microsoft Azure certifications (Azure Data Engineer Associate, Azure Solutions Architect Expert, Azure Fundamentals). β€’ Azure Databricks Certification as Data Engineer Associate.