Highlights
An ETL (Extract, Transform, Load) Architect designs, builds, and oversees enterprise-grade data integration pipelines, data warehouses, and migration strategies to ensure secure and efficient data flow between systems.
Numbers & Facts
| Location | (Remote) |
| Job Type | Contractor |
| Salary | $58–$60 Per Hour |
| Company Size | 11 - 50 |
| Website | https://healthspectra.com |
Description
An ETL (Extract, Transform, Load) Architect designs, builds, and oversees enterprise-grade data integration pipelines, data warehouses, and migration strategies to ensure secure and efficient data flow between systems.
Job Responsibilities
Key Responsibilities
Architecture & Strategy: Define overall ETL/ELT standards, modernization roadmaps, and reusable integration frameworks.
Design & Modeling: Translate complex business requirements into conceptual, logical, and physical data models, data marts, and data warehouses
Pipeline Optimization: Oversee high-volume data extraction, transformation, and loading workflows while eliminating data redundancies and optimizing performance
Technology Evaluation: Discover, evaluate, and implement new cloud platforms, big data tools, and CI/CD automation pipelines.
Establish data quality rules, validation processes, security protocols, and compliance standards.
Leadership & Collaboration: Provide technical direction to developers, mentor engineering teams, and bridge gaps between technical and business stakeholders
Qualifications
Essential Requirements & Skills
Experience: 8+ years in data integration, data warehousing, or database administration, with several years in an architectural or leadership capacity
Technical Stack: Advanced SQL/PL-SQL, expertise in relational/non-relational databases, and mastery of traditional or cloud ETL tools (e.g., Informatica, IBM DataStage, Talend, Databricks Spark
Cloud & Big Data: Proficiency in cloud ecosystems (AWS, Azure, or GCP) and big data platforms (Kafka, Hadoop, Spark)
Core Competencies: Strong data modeling (dimensional and entity-relationship), performance tuning, and CI/CD deployment strategies