Job Type
Full-time
Description
We are a global leader in the branded merchandise industry, connecting people and brands to create unforgettable experiences. Our 60,000+ clients globally include over 100 Fortune 500 companies. With nearly 2,000 employees and 1,000 Account Executives in 40+ sales offices across the US, we have established ourselves as #1 in our $25B industry.
Halo Branded Solutions is seeking an experienced Data Engineer to join our team. The successful candidate will design, develop, and maintain data integrations to expand our enterprise data warehouse and integrate data in other platforms.
* Note: Must be able to work Eastern or Central time hours. Must be able to visit the Oakbrook, IL office once a quarter.
Key Responsibilities:
* Design and implement data integration solutions using tools like Apache Airflow, Informatica, Python, and Snowflake.
* Develop and maintain ETL processes to ensure accurate and efficient data loading into the data warehouse.
* Develop error handling, alerting, monitoring, and testing processes for 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.
Requirements:
* 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.
* 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.
* Experience with Apache Airflow is a plus.
Key Skills and Technologies:
* Apache Airflow
* Informatica
* Python
* Snowflake
* 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.
About Us:
We energize our clients' brands and amplify their stories to capture the attention of those who matter most. 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 promote from within and provide leadership opportunities.
* Culture: We are a culture of ingenuity, inclusion, and determination. We thrive when each of us contributes to an inclusive environment based on respect, dignity, and equity.
* Recognition: Your success is our success. You can count on us to celebrate your wins.
* Flexibility: Many of our roles offer hybrid work options, and we pride ourselves on flexible schedules that help you balance professional and personal demands.
HALO is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.