Previous Job
Business Intelligence Analyst
Ref No.: 18-03241
Location: Naperville, Illinois
Position Type:Full Time
Pay Rate : $ 60,000.00 - 65,000.00 /Year
Primary Responsibilities
The Business Intelligence Analyst is a highly cross functional role at the intersection of business analytics and technical dashboard and report development. He/she will collaborate closely with business groups (e.g. Merchandising, Sales, Supply Chain) as well as other BI & IT functional groups (e.g. BI, Data Architecture/ETL) to enable truly data-driven decision making and insights. Key focus areas include Excel data modeling, Power BI dashboard development, and SQL-style report creation. We're looking for someone with both solid business analytics skills as well as the technical acumen and passion for turning data into actionable information. This role will leverage our key technologies and data to provide critical insights to the organization.

Essential Functions
  • Ability to utilize Excel to combine (VLOOKUP) and manipulate (PIVOT TABLE) data into formats suitable for analysis
  • Ability to analyze data and translate data into information and insights
  • Ability to define software requirements and create requirements documentation
  • Ability to gather/query data from Excel, AS 400, SQL Server, Cognos, or other external data sources
  • Ability to create Power BI business intelligence and insights dashboards
  • Employee must be able to work independently and prioritize workload based on project plans and time lines

Minimum Requirements, Qualifications, Additional Skills, Aptitude
  • Bachelor's Degree or Equivalent
  • Business, Finance, Business Analytics, Computer Science
  • Business Experience
  • Requires 1-2 years related experience
  • Client or Retail Industry preferred
  • Microsoft Excel
  • Assemble data from multiple sources using the vlookup function
  • Create flexible data aggregations using pivot tables
  • Analyze data and translate findings into information and insights
  • Microsoft Power BI
  • Develop Power BI dashboards
  • Support the definition and documentation of Power BI project requirements
  • Liaison to IT Business Intelligence and Data Architecture teams
  • Microsoft SQL Server Reporting
  • SQL query expertise
  • High degree of self-motivation and dependability
  • Time management skills to prioritize multiple tasks
  • Clear and concise communications skills; ability to work cross-functionally across IT and business units
Qualifications / Additional Skills / Aptitude:
  • Microsoft Excel
  • Develop and utilize macros to format and manipulate data
  • R Programming Language
  • Cognos Report Studio
  • Cognos report development
  • SQL