Job Description
Job Description
ABOUT BANNER SOLUTIONS
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!
About the Role:
We are seeking a highly analytical and data-driven Power BI Engineer to join our team. This is a newly created position that will serve as a business partner to drive data-informed decision-making across the Banner organization. The ideal candidate will have a solid foundation in data analysis, business partnering, reporting, and visualization, with a passion for uncovering actionable insights that drive business growth.
WHAT YOU WILL NEED TO SUCCEED
- Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field.
- 3+ years of experience with Power BI development and data analysis.
- Experience working with data lakes (Azure Data Lake, AWS S3, etc.).
- Strong proficiency in DAX, Power Query (M), and data modeling.
- Experience with SQL and ETL tools or scripting languages (Python, Spark, etc. is a plus).
- Understanding of cloud platforms (e.g., Azure Synapse, Data Factory, or AWS equivalents).
- Knowledge of data governance, security, and access controls in BI environments.
- Excellent communication and problem-solving skills.
Responsibilities:
- Serve as a lead collaborator with business functional leaders across the organization to centralize and drive usage of data and reporting.
- Develop and maintain Power BI datasets, reports, dashboards, and visualizations.
- Extract, transform, and load (ETL) data from a data lake (e.g., Azure Data Lake, AWS S3, or similar) into Power BI for reporting.
- Design efficient and scalable data models (star/snowflake schemas) in Power BI.
- Use Power Query (M) and DAX to manipulate, clean, and transform data for reporting needs.
- Collaborate with data engineers to optimize data lake architecture for Power BI consumption.
- Implement and manage data refresh schedules, gateway connections, and performance tuning.
- Ensure data accuracy, consistency, and governance across BI solutions.
- Work with business users to understand requirements and translate them into technical BI solutions.
- Create and maintain documentation for data sources, models, and dashboards.
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
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.