[Remote] Enterprise Data Architect

Note: The job is a remote job and is open to candidates in USA. HALO Branded Solutions is seeking a highly skilled Enterprise Data Architect to lead the architecture of their data engineering platforms and enterprise data solutions. This role is pivotal in designing, implementing, and maintaining robust data architectures that support business objectives and drive analytics and data-driven decision-making. Responsibilities • Work directly with the VP of Data Engineering to help develop enterprise data strategy in collaboration with our business and technology partners • Lead the architecture of enterprise data solutions, including data platforms, data modeling, integrations, and data DevOps • Develop and maintain comprehensive data models that support business processes and analytics • Implement best practices for data governance, data quality, and data security across the organization • Ensure the alignment of data architecture with business goals and IT strategies • Design and implement a medallion architecture in Snowflake (Bronze, Silver, Gold layers) • Analyze raw data ingested into the Bronze layer, transform and cleanse it into the Silver layer, and consolidate it into a Gold layer as a single source of truth for enterprise analytics • Collaborate with business and technical stakeholders to understand data across various systems, including ERPs, CRMs, transactional databases, and architect a medallion architecture in Snowflake • Ensure data is appropriately cleansed, manipulated, enhanced, and transformed for analytical consumption • Use tools like dbt to manage transformations and model dependencies across layers • Develop and maintain architecture diagrams, data flow documentation, and implementation plans • Apply best practices in data warehousing, data modeling, and performance optimization • Provide guidance on data governance, quality, and security standards • Design and oversee the architecture of our data engineering platform, ensuring scalability, reliability, security, and performance • Provide architectural guidance for date engineering teams utilizing tools such as Apache Airflow, Snowflake, dbt, OpenFlow, Zapier, Postgres, SQL Server, and Tableau. Architect processes, procedures, templates, and best practices to build and manage data pipelines, ETL processes, and Dev Ops/CI/CD solutions • Work with business leaders and cross-functional tech teams on data needs • Collaborate with internal business partners to identify solutions and document functional requirements for new processes and existing issues • Work directly with teams responsible for shaping how we acquire, collect and leverage data • Work with business owners to manage and monitor security access in compliance with company policies • Provide technical leadership and mentorship to data engineering, data warehouse, and DBA teams • Collaborate with cross-functional teams, including IT, business analysts, and product managers, to understand data requirements and deliver effective solutions • Stay current with industry trends and emerging technologies to continuously improve data architecture practices • Be available for occasional on-call night/weekend support Skills • Proven experience as a Data Architect with a focus on Snowflake • Strong proficiency in SQL • Deep understanding of data warehousing concepts, dimensional and relational modeling, and ETL/ELT pipelines • Experience working with ERP, CRM, and other transactional systems • Excellent communication and collaboration skills with both technical and non-technical stakeholders • Ability to create clear and effective architecture diagrams and project plans • Familiarity with data governance, metadata management, and data quality frameworks • Experience working with Master Data Management tools • Experience with AWS • Knowledge of Python or other scripting languages • Familiarity with tools like FiveTran, OpenFlow, Airflow, Zapier, or other integration and orchestration frameworks • Experience with compliance regulations, such as GDPR and CCPA • Experience in Jira and agile development environments Company Overview • HALO is the global leader in branded merchandise, uniform programs, and recognition and incentive solutions. It was founded in 1952, and is headquartered in Sterling, Illinois, USA, with a workforce of 1001-5000 employees. Its website is Company H1B Sponsorship • HALO Branded Solutions has a track record of offering H1B sponsorships, with 4 in 2025, 1 in 2024, 3 in 2023, 1 in 2022, 4 in 2021, 7 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job