Data Engineer bei Banner Solutions

ABOUT BANNER SOLUTIONS – NOT JUST A HARDWARE DISTRIBUTOR

At Banner Solutions, every teammate is an owner.

Banner Solutions is more than a typical door hardware distributor – we’re obsessed with making our customers’ jobs easier through inventory availability, product findability, and top-tier customer support. 

We are Securing Every Doorway and Beyond with Trusted Solutions.

Our expertise spans commercial, electronic access control, residential hardware, and locksmith supplies, supported by an industry leading e-commerce platform featuring products from over 260 manufacturers. Banner Solutions aims to simplify and enhance customer experiences through efficient processes and personalized service, setting new standards in the industry. 

We are entering an exciting phase of growth and expansion supported by significant investments!

 JOB SUMMARY

The Data Engineer reports to the SVP of IT and their main purpose is to maintain the SQL Server footprint and integrations between systems.

PRIMARY RESPONSIBILITIES

• Responsible for the development and administration of the Banner SQL Server ecosphere
• Can create and maintain legacy SSIS packages and SSRS reports
• Supports conversion of SSRS Reports to Power BI
• Familiar with Azure Data factory and modern data lake loading methodologies 
• Designs, develops, and maintains databases by writing complex SQL queries to retrieve and manipulate data while optimizing performance
• Works in a cross functional data team across departments
• Uses DevOps to maintain code base and thrive in a modified agile project environment
• Creates and manages data integrations between systems in the Banner ecosphere and provides data access for 3^rd party solution providers
• Identifies areas where Banner can use leading edge cloud services and assists in developing the Data pillar of the IT Roadmap 
• Is a Member of the Disaster Recovery Team 

WHAT YOU WILL NEED TO SUCCEED

• Bachelor’s degree in computer science, MIS, or related field of study; an Associate’s Degree and 2 Years of Experience in a Systems Analyst/Administrator Role; or 8+ years progressive experience in a Systems Analyst/Administrator Role 

• Understands and adheres to standardized documentation methods using DevOps, Teams, and Jira
• Advanced skills in SQL Server, SSIS, SSRS
• Exposure to Azure Data Factory, Azure Data Bricks, and Power BI 
• Understands overall data systems architectural and integration methodologies  
• Has a high emotional intelligence and can communicate effectivity from the Shipping Dock to Senior Management 
• Ability to Discern problems and quickly apply solutions for any possible downtime  
• Displays Dependability and Flexibility when in a high stress situation 

We foster an inclusive and supportive team culture that values diversity and collaboration and therefore encourage qualified candidates with relevant experience to apply, even if they do not meet all the listed qualifications.

WHY JOIN BANNER?

Banner Solutions is a great fit if

• You value teamwork and are interested in helping to build an evolving high-growth company 
• You have a “roll up your sleeves” work hard play hard mentality
• You value making a difference in the world and participating in something larger than oneself
• You want to work with top quality leaders

What You’ll Gain by joining Banner 

• Ownership shares in the company
• 401K match
• Unlimited PTO
• Employee Discounts through our partners
• Health, dental and vision insurance coverage

Mentorship & Leadership Development