Data Engineer

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. 

Halo Branded Solutions is seeking a highly skilled and experienced Data Engineer to join our team. The successful candidate will be responsible for designing, developing, and maintaining data integrations to expand our enterprise data warehouse and integrate data in other platforms. This role requires a strong background in data/software engineering, DevOps, and Agile methodologies. 

Key Responsibilities: 

• Design and implement data integration solutions using tools such as Apache Airflow, Informatica, Python, and Snowflake. 
• Develop and maintain ETL processes to ensure data is accurately and efficiently loaded into the data warehouse. 
• Develop error handling, alerting, monitoring, and testing processes into data pipelines. 
• Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs. 
• Manage and optimize data pipelines for performance and scalability. 
• Implement and manage DevOps practices in the Data Engineering environment, including version control with BitBucket and continuous integration/continuous deployment (CI/CD) with Jenkins. 
• Develop and manage branching strategies to support multiple development streams. 
• Ensure data quality and integrity through rigorous testing and validation. 
• Work with databases and SQL to extract, transform, and load data. 
• Integrate data from various APIs into the data warehouse and other data platforms. 
• Participate in Agile development processes, including sprint planning, daily stand-ups, and retrospectives. 
• Use Jira for task management and tracking progress. 
• Be available for occasional on-call night/weekend support. 

• Bachelor’s degree in Computer Science, Information Technology, or a related field. 
• Proven experience as a Data Engineer or in a similar role. 
• Strong understanding of data warehousing concepts and best practices, especially with Snowflake. 
• Experience with ETL tools and processes. 
• Proficiency in Python and SQL. Experience with Apache Airflow is a plus. 
• Hands-on experience with DevOps tools and practices. 
• Familiarity with Agile methodologies and tools like Jira. 
• Excellent problem-solving skills and attention to detail. 
• Strong communication and collaboration skills. 
• Experience with AWS. 

Preferred Qualifications: 

• Experience with data modeling of data warehouses 

Key Skills and Technologies: 

• Apache Airflow 
• Informatica 
• Python 
• Snowflake 
• DevOps Tools:?BitBucket, Jenkins 
• AWS 
• Databases and SQL 
• API Integrations 
• Agile Methodologies 
• Jira/ServiceNow 

Why Join Us: 

• Opportunity to work with cutting-edge technologies and shape the future of data architecture in our organization. 
• Collaborative and innovative work environment. 
• Competitive salary and benefits package. 
• Professional development and growth opportunities. 

If you are a visionary data engineer with a passion for building scalable and efficient data solutions, we would love to hear from you. Apply now to join our team and make a significant impact on our data-driven journey. 

The estimated base salary range for this position is between $90,000 - $130,000 USD.  Please note that the pay range information provided is a general guideline and combines all of the distinct labor markets within the US. It is uncommon for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on a variety of factors. HALO's factors include but are not limited to:  scope and responsibilities of the position, candidate’s work experience, candidate’s work location, education/training, key skills, internal peer equity, external market data, as well as, market and business considerations when making compensation decision. 

More about HALO

At HALO, we unleash the energy of our client's brands and amplify their stories to capture the attention of those who matter most. For that reason, more than 60,000 small- and mid-sized businesses work with HALO and have made us the global leader of the branded merchandise industry.

• Career Advancement: At HALO, we love promoting from within. Internal promotions have been the key to our exponential growth in the last 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 and gain access to HALO's influential global network, leadership experiences, and diverse thinking.
• Culture: We love working here and know that you will too. You can expect a positive culture of ingenuity, inclusion, and relentless determination. We push the limits of possibilities and imagination by staying curious, humble, and provocative in order to break through yesterday's limit. Diversity is the source of our creativity and we thrive when each of us contributes to an inclusive culture of respect, dignity, and equity mindset in everything we do. We keep our promise for excellence with an unrelenting commitment to achieving results and supporting one another to stay accountable, transparent, and dependable.
• Recognition: You're going to succeed here, and you can count on us to celebrate your wins. Colleagues across the company will join in recognizing your big milestones and nominate you for awards. Over time, you'll earn so much recognition that you can convert into gift cards, trips, concerts, and merchandise at your favorite brands.
• Flexibility: We pride ourselves on flexible schedules that help you find a balance between professional and personal demands. We believe that supporting our customers is the priority and trust that you and your manager will find a schedule to achieve that priority.
• Stay well at HALO: At HALO, we have benefits that support all parts of your life and to find a work-life balance custom to you. We offer nationwide coverage for Medical, Dental, Vision, Life and Disability insurance, and additional Voluntary Benefits. Prepare your financial future with our 401K Retirement Savings Plan, Health Savings Accounts (HSA), and Flexible Spending Accounts (FSA).

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.