Senior Data Warehouse Administrator

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 is currently seeking an experienced, hands-on Senior Data Warehouse Administrator to provide technical design, development, and administration support Business Units for various crucial databases, Business Intelligence, and ETL applications. This role involves developing processes, pipelines, and collaborating with business partners to identify data solutions for streamlining existing data processes and achieving procedural efficiencies as well as development of new processing including but not limited to data integration and data model creation for the Enterprise Data Warehouse. In this critical role, you will enable and provide enterprise-wide business intelligence, ETL data integration, and support all areas of HALO’s business, operations, and finance functions. You will learn and become intimately familiar with all aspects of HALO’s business and help to provide the tools and data necessary.

Responsibilities

• Provide administration, development and support for the cloud-based Enterprise Data Warehouse environments, including Snowflake, Informatica, and Tableau.
• Develop solutions for data problems in databases and Business Intelligence tools.
• 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 ISO and business owners to manage and monitor security access in compliance with company policies.
• Support data/BI systems along with development efforts.
• Be available for occasional on-call night/weekend work during deployments and script executions.

Requirements

• 3+ years of experience in Data Warehouse & BI implementation.
• 3+ years of experience with Snowflake.
• 3+ years of experience with administration of Informatica Cloud, both Data Integration and Cloud Application Integration
• 3+ years of experience in cloud methodologies, ideally AWS
• Experience administering Data Visualization tools, such as Tableau, or strong desire to learn.
• Very strong SQL experience.
• Ability to collaborate with team members across multiple disciplines, including data engineering, data integration, database development, and information security.
• Demonstrated knowledge of data structures, database systems/tools, related software, data management, and practices in a complex organizational environment.
• Experience with Relational Database Management is required.
• Proficient in authoring work instructions, best practice documents, and scripts that can be followed by others.
• Ability to quickly learn and adapt to new technologies.
• Excellent verbal and written communication skills with the ability to work effectively in a team environment.
• Experience and ability to thrive in a fast-paced environment with great attention to detail.
• Ability to communicate effectively with Business Users and help make influential decisions.

Additional Preferred Qualifications:

• Experience implementing DevOps in a data warehouse environment, including source control and automated deployments.
• Experience with SQL Server and Informix.
• Experience in Agile/Scrum methodologies.
• Experience with data modeling.
• Experience with Jira, ServiceNow, and familiarity with Git/Bitbucket.

Compensation range is specific to the job level and takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to: education, experience, licensure, certifications, geographic location, and internal equity. The range has been created in good faith based on information known to HALO at the time of the posting and does not include any potential benefits, however, such information will be provided separately when appropriate. The estimated base salary range for this position is between $80,000 - $140,000 USD.

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: Most roles offer hybrid work. In addition, 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.