ETL Architect

INTERVIEW: Onsite / Virtual

JOB TYPE: Onsite

Data Architect

Scope of Work / Job Characteristics

The Data Architects will serve on a modernization project Data Warehouse Team. These roles will drive enterprise-wide data design, ensuring optimized data structures that balance accessibility, performance, and resource utilization.

The Data Architects will focus on developing comprehensive logical and physical data models, defining source-to-target mappings, and establishing robust data quality and lineage standards. These roles will provide strategic guidance on data architecture best practices, establish organizational standards for data structures and metadata, and support the design of data acquisition, integration, and database optimization strategies to enable reliable, scalable, and governed data solutions across the enterprise.

Responsibilities

Enterprise Data Architecture and Modeling

Define and maintain enterprise-wide logical and physical data models, ensuring alignment with organizational standards and future scalability;Develop and document source-to-target mappings that support data integration, transformation, and reporting needs; andDesign and optimize data architectures, including Operational Data Stores (ODS), Data Warehouses, and Data Marts.Data Standards, Governance, and Quality

Establish and enforce data architecture standards, policies, and procedures for data structures, naming conventions, metadata management, and reference data;Define and maintain rigorous data quality rules to ensure the accuracy, consistency, completeness, and reliability of enterprise data assets; andDocument and maintain data lineage, capturing end-to-end data flows, business rules, and transformation logic.Data Acquisition, Analysis, and Optimization

Collaborate with Data Warehouse Analysts to understand data requirements, usage patterns, and integration points across systems;Lead data acquisition and access analysis, defining strategies for ingestion, transformation, and distribution;Provide expertise in Database Management System (DBMS) optimization, including performance tuning, indexing strategies, and resource utilization; andDesign and support batch loading strategies, ensuring efficient data movement, error handling, and recovery procedures.Architecture Guidance and Project Support

Act as a Subject Matter Expert (SME) for data architecture best practices, advising teams on modeling, integration patterns, and technology selection;Apply and promote accepted data content standards across technology projects to ensure consistency and interoperability; andPartner with developers, analysts, and stakeholders to ensure data solutions align with enterprise goals and meet functional and non-functional requirements.Documentation, Compliance, and Continuous Improvement

Produce clear documentation for models, mappings, lineage, and standards to support knowledge transfer and audit readiness;Support compliance with regulatory, security, and privacy standards by implementing data governance controls and traceability; andContinuously assess and enhance data architecture frameworks, tools, and methodologies to improve efficiency and data value.Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience in Service-Oriented Architecture (SOA) and Azure Cloud Solutions;Minimum of seven (7) years of experience managing large and complex database management systems;Minimum of seven (7) years of experience in ETL development and data engineering;Minimum of three (3) years of hands-on experience with Azure Data Factory (ADF), Azure Databricks, Azure Synapse Analytics, and Azure Purview;Proven experience building and optimizing large-scale ETL pipelines for high-performance, high-availability environments;Expertise in Spark, Python, or Scala for large-scale data transformations;Strong SQL proficiency and experience working with complex data structures;Comprehensive knowledge of data governance, security protocols, and Role-Based Access Control (RBAC) within the Azure ecosystem; andAbility to design ETL processes that are resilient, efficient, and compliant with regulatory standards.Preferred Qualifications

Experience managing AWS data warehouse environments, AWS S3, and Data Sync processes;Understanding of CJI, HIPAA, and PII compliance requirements;Microsoft certifications such as Azure Data Engineer Associate, Azure Solutions Architect Expert, and Azure Fundamentals; andDatabricks Certification as a Data Engineer Associate.