BI System Analyst in Egg Harbor Township, NJ at Spencer's

Job Description

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 with a functional profile to bridge the gap between Business and IT in order to deliver value-added reporting and analytics solutions to our business leaders. Lead the requirement gathering and design effort for reports and analytics solutions. Participate in the full lifecycle of an analytics or BI project: from gathering and understanding the end-user needs over creating the functional design, supervising the detailed technical design and implementation, to preparing and executing the functional and product tests before handover. 

Primary Objectives and Responsibilities: 

• Learning and fully understanding the data landscape in databases and applications 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Using and developing enterprise data integration processes 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Reviewing and validating data 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Documenting data definition and cataloging metadata requirement for enterprise BI and Analytical applications 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Gathering end user reporting and dashboard requirements using enterprise business requirement document (BRD) template 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Works with user groups to provide training, resolve questions, assess user needs, and recommend changes to data systems.  
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Develop systems test plan components and test scripts 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Developing dashboards and creating reports and supporting users with them 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Develop and maintain effective organizational working relationships and partnerships across the company to enhance enterprise utilization of data and analytical reporting. 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Acts in a collaborative function for research design, data collection, interpretation, and presentation. 

Qualifications

• Bachelor’s degree in Computer Science or any other engineering discipline 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Comprehensive understanding of current principles, practices, and techniques of Systems Analysis, Business Analysis, and Business Intelligence.  
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Proven track record of minimum Six years’ experience in executing successful, large, complex data warehouse projects with retail environments, pulling data from multiple sources 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Understanding of Kimball dimensional data modeling methodology; ability to explain and interpret conceptual, logical and physical models for operational and analytical systems 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Strong SQL query building knowledge 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Familiarity of any of Cloud (Azure, AWS) based Data Integration and Orchestration solutions 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Participated in implementation of large-scale cross enterprise MDM and/or Data Warehouse implementations  
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Solid communication, presentation and analytical skills 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Previous consulting experience is a plus 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Knowledge of: SQL, Multidimensional Modeling (Erwin or similar tool), BI toolsets (Microstrategy, Power BI, Teradata) 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Understanding of T-SQL, SSIS, SSRS, SSAS, PowerShell, Dashboard Reporting 
• ' data-font='Garamond' data-listid='2' data-list-defn-props='{'335551671':0,'335552541':1,'335559684':-2,'335559685':360,'335559991':360,'469769226':'Garamond','469769242':[8226],'469777803':'left','469777804':'
• ','469777815':'hybridMultilevel'}' aria-setsize='-1' data-aria-posinset='0' data-aria-level='1'>Familiarity of NO-SQL database and other data structures like JASON, Avro, etc.