• Business Intelligence and Data Warehouse Senior Analyst

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

    UL LLC is seeking results focused IT Development Senior Analyst who will assist in fulfilling project needs around business intelligence, analytics and reporting for our internal 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 Development Senior Analyst’s job duties include, but are not limited to:

    • Assist in working with business and technical teams to gather BI/DW and data integration related requirements from business users to create functional and technical requirements documents.
    • Administer and support the OBIA applications platform including system configuration, enhancements, break-fix, and deployments.
    • Assist with architecture build and solution design for the ETL 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 ETL to accommodate custom data requirements provided by the business.
    • Communicate with business users and project managers at regular project status meetings.
    • Translate 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 Informatica ETL code.
    • Develop and maintain OBIEE data models, repository, reports, and dashboards.
    • 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).
    • 6+ years job experience within the industry or consulting is preferred.
    • 4+ years of experience with Informatica Power Center 9.x or higher.
    • 4+ years using Oracle Business Intelligence Analytics Applications. Prefer experience with Finance, Supply Chain/Order Management, Project Analytics, Procure/Spend Analytics.
    • 2+ years developing in Oracle’s OBIEE 10 or later (prefer recent, hands-on 11g or 12c experience): RPD, Dashboards, Scorecards, BI Publisher, etc.
    • Experience with OBIEE installation, configuration and administration
    • Experience in performing conceptual, logical and physical data modeling in a highly complex environment.
    • Experience with Data Warehousing, Data Marts, OLAP/OLTP environments.
    • 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).
    • Experience with Oracle Database Tools/Technologies (prefer Oracle 11/12).
    • Experienced in writing and understanding complex SQL code.
    • Key skill on UNIX based operating system to administer Informatica, DAC and OBIEE.
    • Experience with full lifecycle of Business Intelligence projects.
    • Experience with Microsoft BI technologies including Power BI is a plus.
    • 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.



    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!