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

Date Posted: 11/25/2022

Job Snapshot

Job Description

Overview

Come work with us at Spencer's & Spirit Halloween, where you'll be working with the best and brightest colleagues as you help us deliver the most fun experience and product possible to our guests. We're fast-paced and take our work seriously, but we always have a good laugh at the end of the day. Walk through our stores or the halls of our corporate office and you'll see firsthand that we're laidback and irreverent. We're firm believers in being true to YOU, so tattoos and piercings are as common as watercooler convos. Whether it's critiquing our new exclusive costumes or quality testing newly implemented software technology, our teams understand the importance of working collaboratively to challenge status quo and achieve our goals. We keep pushing ourselves to go above and beyond and are looking for top talent to become a part of our team!


We offer the following benefits:

  • 30% discount on merchandise
  • competitive salary
  • career advancement
  • Bonus opportunity
  • an excellent benefits package including Vacation/Sick/Holiday pay, Medical/Dental/Disability/Life and AD&D insurance & 401k.

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. 

*Proof of vaccination for COVID-19 required for employment, reasonable accommodations considered for medical, pregnancy or sincerely held religious beliefs.

CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs