Randstad BI Report Analyst in Gurnee, Illinois

BI Report Analyst

job details:

  • location:Gurnee, IL

  • date posted:Monday, March 12, 2018

  • job type:Permanent

  • industry:Information Technology

  • reference:606496

job description

Job Description: Under direction of the Information System Manager, the Information Systems Business Intelligence (BI) Reporting Analyst is responsible for the strategy, design, implementation and administration of the data warehousing and reporting system within a multisite environment.

This role will support and enhance existing Excel, Access, QlikView and Crystal Reports systems as well as lead the way in conversion of these multiple different systems into one aggregate cloud based data warehouse. The BI Reporting Analyst will work directly and collaboratively with end users to capture business needs while standardizing and prioritizing those requests to migrate aspects of those systems to a cloud based data BI warehouse. The position will coordinate activities with a cross functional IT/IS team and business stakeholders to ensure successful support of legacy systems as well as migration to the cloud that drives meaningful and actionable intelligence for the business.


  • Bachelor's Degree in Information Systems, Engineering, Business, or related field/equivalent experience

  • 5-10 years of relevant data reporting systems experience and toolset

  • 2+ years of cloud based data warehouse / business intelligence tools


  • Demonstrated ability to migrate data to a cloud based BI product

  • Ability to design, support and implement new versions and report enhancements of MS-excel, MS-access, QlikView, Crystal Reports

  • Demonstrated ability to perform advanced TSQL queries/joins (CRUD operations) as well as SQL database management and normalization of different databases and repositories

  • Ability to investigate data/tables/schemas and reverse engineer data dictionary mappings and relationships

  • Demonstrated ability to manage, profile and troubleshoot SQL database issues queries and performance

  • Demonstrated ability in ETL package creation/automation and data replication/shipping

  • Demonstrated ability to translate business domain subject matter and perform data analysis and reports against business databases and/or applications

  • Excellent time management skills with ability to handle multiple tasks concurrently as well as prioritization

  • Ability to think holistically to create standardized solutions from multiple different requests and datasets

  • Ability to act as a liaison between end users and technical staff to help align scope and provide solutions to address business and stakeholders data and reporting needs

  • Must be attentive to detail

  • Ability to think critically, both quantitatively and qualitatively

  • Accepts direction, coaching, and constructive feedback well.

Preferred Qualifications

  • Experience with data warehousing of ERP systems

  • Consumer product industry experience

  • Experience with multiple BI tools (Microsoft Power BI, Domo, etc)

  • Experience with Microsoft Azure

  • Experience with SQL advanced toolsets such as REDGATE SQL Toolbelt

  • Experience operating in Agile/SCRUM teams

Job Responsibilities:

  • Ensures high availability and end user self-servicing of reporting and data solutions

  • Designs and implements a migration strategy to move towards a cloud based BI data warehouse

  • Builds, supports and enhances exiting MS-Access, QlikView, Crystal Reports and excel solutions based on business requirements identified by key stakeholders and end users

  • Designs, implements and maintains all data connectors for cloud data warehouse ingestion

  • Automates report creation and push notifications / exceptions around data and business intelligence

  • Manages and maintains multiple SQL databases and cloud based databases for performance, security and quality

  • Gathers requirements needed to support report/solution creation by collaboratively engaging with local and offsite stakeholders.

  • Conducts casual and formal training on best practices with end users

  • Primary contact and ownership for data, reporting and BI in the event of after hour emergencies

  • All other duties as assigned

Reports To: Information Systems (IS) Manager

Direct Reports: None

Travel Required: Up to 10%