Developer, Business Intelligence

ICU Medical Inc.   •  

San Clemente, CA

5 - 7 years

Posted 280 days ago

This job is no longer available.

Position Summary
The BI Developer is responsible for the design, development and implementation of the Company’s business intelligence platforms. The BI Developer defines and managers OBIEE solutions including database designs, ETL implementations and report solutions.

Essential Duties & Responsibilities
• Maintain and enhance the BI solutions data to increase the capability, performance, maintainability, and scalability of systems
• Design Oracle queries, tables, and SQL Statements
• Develop and implement the BI architecture which includes Data Warehousing, data integration and staging
• Design and develop OBIEE
• Work with business users to understand and translate user requirements into data structures, models, and integration/extract jobs
• Map data from data sources to through the Data Warehouse layers
• Develop documentation as necessary for analysis or design
• Manage the reporting and analytics platform(s) to ensure that scheduled jobs are successfully run and analytics data aligns to timeliness and completeness of requirements
• Act as a database administrator to ensure that databases feeding the reporting platforms are tuned for optimal performance
• Determine and communicate work estimates and status as needed
• Stay current with latest BI industry trends and software versions
• Participate in 24/7 department on-call program
• Work on special assignments as they arise

Knowledge, Skills & Qualifications
• Knowledge of Oracle EBS
• Strong experience with Oracle EBS-based OBIEE, OBIA, DAC and Informatica
• Understanding of Oracle EBS modules and functions: Sales, Finance, Operations
• Experience designing and developing Oracle Database objects: Tables, View, Queries and Stored Procedures
• Excellent verbal and written communication skills
• Strong analytical and problem solving skills
• Able to work in a team environment
• Able to work quickly and effectively under pressure and to efficiently handle multiple priorities simultaneously

Education and Experience
• Bachelor’s degree from an accredited college or university in Computer Science or a related IT field
• Minimum 5 years of experience in an IT Oracle BI reporting environment including:
o Oracle 11g particularly Oracle EBS data objects
o Informatica PowerCenter with Oracle EBS data objects
o OBIEE with Oracle EBS
o OBIA and DAC
• Experience working with Oracle Business User community for testing and requirements refinement
• Experience working for a mid-sized to large organization; manufacturing experience preferred

Minimum Qualifications
• Must be 18 years of age
• Must pass pre-employment drug screen and background check

Travel Requirements

• Typically requires travel less than 5% of the time

Physical Requirements and Work Environment
• This is largely a sedentary role; however, some filing is required. This would require the ability to lift files, open filing cabinets and bend or stand on a stool as necessary.
• This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.