IT Business Systems Analyst

Location US-IL-Northbrook
Job ID
# of Openings
Job Category
Information Technology


UL LLC is seeking results focused BI Business Systems Analyst / Architect who will assist in fulfilling project needs around business intelligence, analytics and reporting for our customers. This individual will be responsible for supporting our environment and participating in projects from a technology perspective to ensure goals and objectives are met while adhering to UL’s formal system development lifecycle. The IT Business Systems Analyst/Architect’s job duties include, but are not limited to:


  • Assist in working with business and technical teams to gather BI/DW and reporting related requirements from business users to create functional and technical requirements documents..
  • Administer and support the OBIEE platform including system configuration, enhancements, break-fix, and deployments.
  • Assist with architecture build and solution design for the BI environment.
  • Assist with development of and enhancements to the ETL processes supporting data integrations for OBIEE from multiple source systems.
  • Development and delivery of extensions to the out-of-the-box data model to accommodate custom data requirements provided by the business.
  • Communicate with business users and project managers at regular project status meetings.
  • Translate the business requirements and source system understanding into technical design.
  • Troubleshooting and debugging of defects and production issues in the areas of Informatica, DAC and OBIEE.
  • Develop and maintain OBIEE repository.
  • Ensure Project deliverables are delivered on time.
  • Help in executing the Business Intelligence Vision and Strategy.
  • Develop technical documentation.





  • Bachelor's Degree or equivalency (CS, CE, CIS, IS, MIS, or engineering discipline)
  • 4+ years job experience within the industry or consulting is preferred
  • 2+ years using Oracle’s OBIEE 10 or later (prefer recent, hands-on 11g or 12c experience): Dashboards, Scorecards, BI Publisher, etc. Experience with OBIEE is a must
  • 1+ years using Oracle Business Intelligence Analytics Applications. Prefer experience with Finance; Supply Chain/Order Management; Project Analytics; Procure/Spend Analytics; Experience with OBIA is preferred
  • Experience with OBIEE installation, configuration and administration
  • Experience with Oracle Database Tools/Technologies (prefer Oracle 11/12)
  • Experienced in writing and understanding complex SQL code.
  • Experience creating or enhancing custom enterprise reports and dashboards in OBIEE.
  • Key skill on UNIX based operating system to administer Informatica, DAC and OBIEE.
  • Experience with full lifecycle of Business Intelligence projects
  • Good written & oral communication and presentation skills in English.
  • Strong decision making and problem solving skills based on strong functional and technical knowledge.
  • Ability to work independently as well as being part of a team.
  • Ability to learn quickly.
  • Experience in performing conceptual, logical and physical data modeling in a highly complex environment.
  • Experience with Data Warehousing, Data Marts, OLAP/OLTP environments.
  • Experience with Informatica Power Center 9.x or higher
  • Knowledge of Data Warehousing and master data Management and Governance practices
  • Experience developing and maintaining Informatica ETL code.
  • Knowledge of ETL processes and data management practices
  • Knowledge of Oracle E-business Suite (EBS).



Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!