Senior Software Engineer (ETL-ODI)

At ICON, it's our people that set us apart. Our diverse teams enable us to become a better partner to our customers and help us to fulfil our mission to advance and improve patients' lives.

Our 'Own It' culture is driven by four key values that bring us together as individuals and set us apart as an organization: Accountability & Delivery, Collaboration, Partnership and Integrity. We want to be the Clinical Research Organization that delivers excellence to our clients and to patients at every touch-point. In short, to be the partner of choice in drug development.

That's our vision. We're driven by it. And we need talented people who share it.
If you're as driven as we are, join us. You'll be working in a dynamic and supportive environment, with some of the brightest and the friendliest people in the sector, and you'll be helping shape an industry.

The Business Intelligence developer will be responsible for design, development, testing, maintenance, and support of the enterprise data warehouse using Oracle Business Intelligence tools and underlying technologies

JOB FUNCTIONS/RESPONSIBILITIES

• Work with project lead and business users to gather requirements, conduct analysis and prioritize requests
• Design and implement the data loading (ETL) and publishing processes within the DW/BI environment
• Design and implement multi-dimensional models, including the construction of Dimensions and Facts (with hierarchies, attributes, and measures)
• Translate project requirements into functional and technical specifications for BI reports and applications

EXPERIENCE, SKILLS, KNOWLEDGE REQUIREMENTS

• Prior relevant experience of 4 to 6 years in delivering business intelligence solutions
• Knowledge and experience in the design, construction and management of Data Warehouse and Business Intelligence solutions.
• Experience in the design and implementation of ETL processes using Oracle ODI (would be a distinct advantage) and Informatica (would be an advantage).
• Strong foundation and understanding of Dimensional Modeling and OLAP principles.
• Familiarity with best practice methodologies such as Inmon and Kimball is highly desirable.
• Advanced knowledge and skills in SQL to run queries for data analysis and data profiling.
• Overall understanding of systems architecture & technology development lifecycle.
• Problem solving, Negotiation, presentation & communications skills.
• Ability to work with minimal supervision combined with very good organizational skills.

Preferred skills (not mandatory)

• Experience in Oracle Business Intelligence (OBIEE) would be a distinct advantage.
• Experienced in developing Business Intelligence solutions (reports, dashboards, scorecards)
• Good knowledge of Enterprise Data Model and Master Data management concepts would be advantageous.