BI Analyst III

Overview

We are authentic, professional providers of fun, focused on building a Great Place To Work For All by staying true to our mission: "Life's a Party, We're Makin' It Fun!" and "So Much Fun It's Scary!"

At Spencer's and Spirit Halloween, we do the right thing always-integrity, fairness, respect, and transparency are our foundation. You will find our culture to be inclusive, passionate, resilient, and one that values differences and embraces all.

One Team / One Goal

We are leaders and owners of our business success. Whether it's developing new and exclusive costumes, quality testing products, or implementing technology solutions, our teams understand the value of working collaboratively to embrace change through innovation, curiosity, and thoughtfulness.

We offer a comprehensive benefits package that includes:

• Flexible work environment
• Career advancement
• Competitive base salary
• Bonus opportunity
• Vacation, Personal, Sick and Holiday pay
• Medical, Dental, Vision, Disability, Life and AD&D insurance
• 401k with a company match
• 30% merchandise discount

Responsibilities

The Business Intelligence System Analyst will bridge the gap between Business and IT to deliver value-added reporting and analytics solutions to our business leaders. Lead the requirement gathering and design efforts for reporting and analytical solutions. The Analyst will participate in the full lifecycle of BI projects create functional designs and implement technical solutions.

• Develop and enhance data collection processes
• Document data definitions and catalog metadata requirements for enterprise BI and analytical applications
• Gathering end-user reporting and dashboard requirements
• Partner with user groups to provide training, resolve questions, assess user needs, and recommend changes to data systems
• Develop system test plans and scripts
• Develop dashboards/reports to support business initiatives
• Build strong business partnerships across the organization to enhance enterprise utilization of data

Qualifications

• Bachelor's degree in Computer Science or any other engineering discipline
• Comprehensive understanding of best practices of Systems Analysis, Business Analysis, and Business Intelligence
• Proven track record of minimum 8 years experience in executing successful, large, complex data warehouse projects with retail environments, pulling data from multiple sources
• Understanding of Kimball dimensional data modeling methodology; ability to explain and interpret conceptual, logical and physical models for operational and analytical systems
• Familiarity of any of Cloud (Azure, AWS) based Data Integration and Orchestration solutions
• Knowledge of: SQL, Multidimensional Modeling (Erwin or similar tool), BI toolsets (MicroStrategy, Power BI, Teradata)
• Understanding of T-SQL, SSIS, SSRS, SSAS, PowerShell, Dashboard Reporting
• Familiarity of NO-SQL database and other data structures like JASON, Avro, etc.