BI Analyst III

OverviewWe 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 GoalWe 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 environmentCareer advancementCompetitive base salaryBonus opportunityVacation, Personal, Sick and Holiday payMedical, Dental, Vision, Disability, Life and AD&D insurance401k with a company match30% merchandise discountResponsibilitiesThe 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 processesDocument data definitions and catalog metadata requirements for enterprise BI and analytical applicationsGathering end-user reporting and dashboard requirementsPartner with user groups to provide training, resolve questions, assess user needs, and recommend changes to data systemsDevelop system test plans and scriptsDevelop dashboards/reports to support business initiativesBuild strong business partnerships across the organization to enhance enterprise utilization of dataQualificationsBachelor's degree in Computer Science or any other engineering disciplineComprehensive understanding of best practices of Systems Analysis, Business Analysis, and Business IntelligenceProven track record of minimum 8 years experience in executing successful, large, complex data warehouse projects with retail environments, pulling data from multiple sourcesUnderstanding of Kimball dimensional data modeling methodology; ability to explain and interpret conceptual, logical and physical models for operational and analytical systemsFamiliarity of any of Cloud (Azure, AWS) based Data Integration and Orchestration solutionsKnowledge of: SQL, Multidimensional Modeling (Erwin or similar tool), BI toolsets (MicroStrategy, Power BI, Teradata)Understanding of T-SQL, SSIS, SSRS, SSAS, PowerShell, Dashboard ReportingFamiliarity of NO-SQL database and other data structures like JASON, Avro, etc.

#J-18808-Ljbffr