HALO Branded Solutions · 1 day ago
Enterprise Data Architect
Illinois, United States
Full-time
Hybrid
Senior Level
$150K/yr - $180K/yrHALO Branded Solutions is a leader in the branded merchandise industry, connecting people and brands to create meaningful experiences. They are seeking a highly skilled Enterprise Data Architect to lead the architecture of data engineering platforms and enterprise data solutions, focusing on designing, implementing, and maintaining robust data architectures that drive analytics and data-driven decision-making.
AdvertisingBrand MarketingBusiness DevelopmentGift CardLogistics
No H1B
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
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
Qualification
Required
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
Preferred
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
Benefits
Nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance
Additional Voluntary Benefits
401(k) Retirement Savings Plan
Health Savings Accounts (HSA)
Flexible Spending Accounts (FSA)
Company
HALO Branded Solutions
HALO is the global leader in branded merchandise, uniform programs, and recognition and incentive solutions.
Founded in 1952
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Audax Private Equity
2018-05-17Acquired
2016-01-01Private Equity
Leadership Team
Christy Dressell
Account Executive
Recent News
Company data provided by crunchbase