Ref No.: 17-06549
Location: Elk Grove, Illinois
Position Type:Direct Placement
Start Date: 07/21/2017
Position: Business Intelligence Lead
Type: Permanent
Location: Elk Grove Village, IL
  • Works directly with data users to create user stories that describe their reporting and analytical needs.
  • Creates database models using MS Visio and other modeling tools to build and analyze databases.
  • Creates logical models that include relationships, constraints, attributes and other modeling information.
  • Designs and creates dimensional and fact based tables on users stories and ERD models to support analytical needs. 
  • Creates designs that are compatible with analytical needs, these include snowflake and star models.
  • Creates the structure noted in the modeling tools using SQL statement and/or natively in MSSQL to create the physical database.
  • Creates SQL stored procedures and SQL triggers necessary to maintain data integrity and populate analytical tables.
  • Creates transaction SQL statements using T-SQL.
  • Works with the Application Development team to review, understand and approve transactional database designs.
  • Analyzes transactional databases from disparate operational systems and proposes designs to meet the analytical needs.
  • Creates analytical data warehouses and data marts.
  • Work with Programmer Analysts to create update programs that maybe necessary to maintain the analytical database.
  • Maintains a thorough understanding of user applications and the source of the data that populates analytical databases.
  • Works with other BI users to create reports and analyze.
  • Follows IT methodology for database design; follows published IT schedules.
  • Trains other data analysts on the content and structure of the transactional database and will be accountable for the accuracy and uniformity of reporting and analytical standards.
  • Supervises the day to day activities of the BI Analyst staff.
  • Mentors the BI Analyst staff.
  • Manages the business intelligence support queue.
  • Works with business stakeholders to define use cases for reporting needs.
  • Manages the administration of the Web Focus tool.
  • Manages Web Focus training for anyone using the tool to ensure they have been properly trained.
  • Audits and ensures that all new data in the databases is correct.
  • Coordinates maintenance such as patches and upgrades.
  • Manage projects within business intelligence, including: analysis; defining requirements; design; development; validation and implementation
  • Develops and maintains technical knowledge for the business intelligence solution.