We are HALO! We connect people and brands to create unforgettable, meaningful, and lasting experiences that build brand engagement and loyalty for our over 60,000 clients globally, including over 100 of the Fortune 500. Our nearly 2,000 employees and 1,000 Account Executives located in 40+ sales offices across the United States are the reason HALO is #1 in our $25B industry.

Position Overview: 

Halo Branded Solutions is seeking a highly skilled Enterprise Data Architect to lead the architecture of our data engineering platforms and enterprise data solutions. This role will be pivotal in designing, implementing, and maintaining robust data architectures that support our business objectives and drives analytics and data-driven decision-making.

The ideal candidate will have deep expertise in data warehousing, data modeling, and Snowflake, with a strong ability to communicate and collaborate across technical and business teams.

Key Responsibilities:

Work directly with the VP of Data Engineering to help develop enterprise data strategy in collaboration with our business and technology partners.

Enterprise Data Architecture:

· 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.

Enterprise Data Warehousing:

· 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.

Data Engineering Platform Architecture:

· 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.

Leadership and Collaboration:

· 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.

Required Qualifications:

· 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 Qualifications:

· 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.

Compensation: The estimated salary range for this position is between $150,000 to $180,000.00 annually. Please note that this pay range serves as a general guideline and reflects a broad spectrum of labor markets across the US. While it is uncommon for candidates to be hired at or near the top of the range, compensation decisions are influenced by various factors. At HALO, these include, but are not limited to, the scope and responsibilities of the role, the candidate's work experience, location, education and training, key skills, internal equity, external market data, and broader market and business considerations.

Benefits: At HALO, we offer benefits that support all aspects of your life, helping you find a work-life balance that’s right for you. Our comprehensive benefits include nationwide coverage for Medical, Dental, Vision, Life, and Disability insurance, along with additional Voluntary Benefits. Prepare for your financial future with our 401(k) Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).

Application Information: To apply to this opportunity, click the APPLY button at the top right or very bottom of the screen to complete our online application. A resume is optional, so you may choose to upload and have the application prefill with your information.  There are 5 sections to complete in total, including General information, Work History, Education, Compliance, and optional demographic questions. Once you have successfully submitted your application, you will receive a submission confirmation email from our system.
 

Application Deadline:  Applications are reviewed and processed only when there is a specific need or opportunity, rather than on a fixed schedule or at a set deadline. Because they are reviewed on an as-needed basis, a job posting will be removed once the position has been filled or is no longer available. 

More About HALO:

At HALO, we energize our clients' brands and amplify their stories to capture the attention of those who matter most. That’s why over 60,000 small- and mid-sized businesses partner with us, making us the global leader in the branded merchandise industry.

• Career Advancement: At HALO, we’re passionate about promoting from  within. Internal promotions have been key to our exponential growth over the past few years. With so many industry leaders at HALO, you’ll have the opportunity to accelerate your career by learning from their experience, insights, and skills. Plus, you'll gain access to HALO’s influential global network, leadership opportunities, and diverse perspectives.
• Culture: We love working here, and we’re confident you will too. At HALO, you’ll experience a culture of ingenuity, inclusion, and relentless determination. We push the limits of possibility and imagination by staying curious, humble, and bold breaking through yesterday’s limits. Diversity fuels our creativity, and we thrive when each of us contributes to an inclusive environment based on respect, dignity, and equity. We hold ourselves to a high standard of excellence with a commitment to results and supporting one another with accountability, transparency, and dependability.
• Recognition: At HALO, your success is our success. You can count on us to celebrate your wins. Colleagues across the company will join in recognizing your milestones and nominating you for awards. Over time, you’ll accumulate recognition that can be converted into gift cards, trips, concert tickets, and merchandise from your favorite brands.
• Flexibility: Many of our roles offer hybrid work options, and we pride ourselves on flexible schedules that help you balance professional and personal demands. We believe that supporting our customers is a top priority and trust that you and your manager will collaborate to create a schedule that achieves this goal.

HALO is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We insist on an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law. Inclusion is a core value at HALO and we seek to recruit, develop and retain the most talented people.

HALO participates in E-Verify. Please see the following notices in English and Spanish for important information: E-Verify Participation and Right to Work.

HALO is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process – you may email us at hr@halo.com. Please do not use this as an alternative method for general inquiries or status on applications as you will not receive a response. Reasonable requests will be reviewed and responded to on a case-by-case basis.