Data Engineer (Remote)

Job Type Full-time Description

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.

***Note: Must be able to work Eastern or Central time hours*******Must be able to the go to the Oakbrook, IL office once a Qtr.****

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.

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.

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.

Compensation: The estimated base salary range for this position is between $90,000 and $130,000 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 Disabi