ETL Architect

JOB TYPE: Onsite 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. 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 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.

Create an account to see the full posting, access our search engine, and more.