Senior Software Engineer (ETL-ODI)
About the role
This vacancy has now expired. Please see similar roles below...
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.
Application process
Once you find a job opening that fits your skills and interests, you can create an account, apply and check back on the progress of your application or apply for other roles. Once your application has been received, a confirmation email will be sent to your email.
Remember: this is our first time meeting you. Read the job description and highlight on your CV those experiences that we should learn about.
One of our experienced recruiters will read your profile and determine if you're fit for the role and the company. We are aware of instances where fake recruitment text messages and emails that can appear to come from ICON have been received by individuals. Always delete suspicious text messages or emails. Never give out personal financial information.
Reasonable AccomodationsDay in the life
Teaser label
Inside ICONContent type
BlogsPublish date
04/18/2024
Summary
Endometriosis Awareness: A Vital Cause In March, ICON, through its Networking Organization for Women (NOW) employee resource group, joined the global effort to raise awareness about endometriosis
Teaser label
IndustryContent type
BlogsPublish date
04/18/2024
Summary
Introduction to Data Management in Clinical Trials In the field of clinical research, data management plays a crucial role in ensuring the success and accuracy of clinical trials. Clinical trials
Teaser label
IndustryContent type
BlogsPublish date
04/12/2024
Summary
Introduction to the Clinical Research Supply Chain The clinical research supply chain plays a crucial role in the successful execution of clinical trials. It encompasses a complex network of activ
Who we are
Similar jobs at ICON
Salary
Location
Turkey
Department
Clinical Monitoring
Location
Turkey
Business Area
ICON Strategic Solutions
Job Categories
Clinical Monitoring
Job Type
Permanent
Description
ICON plc is a world-leading healthcare intelligence and clinical research organisation. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotech
Reference
2023-104179
Expiry date
01/01/0001
Salary
Location
Argentina
Department
Clinical Monitoring
Location
Argentina
Remote Working
Remote
Business Area
ICON Strategic Solutions
Job Categories
Clinical Monitoring
Job Type
Permanent
Description
As Clinical Research Associate (CRA), you will be joining the world's largest & most comprehensive clinical research organization, powered by healthcare intelligence. A CRA is a professional who cont
Reference
2023-103904
Expiry date
01/01/0001
Author
Tulio SanquizAuthor
Tulio SanquizSalary
Location
Argentina
Department
Clinical Trial Management
Location
Argentina
Remote Working
Remote
Business Area
ICON Strategic Solutions
Job Categories
Clinical Trial Management
Job Type
Permanent
Description
As a Clinical Trial Manager you will play a key role in improving the lives of patients by accelerating the development of our customers drugs and devices through innovative solutions.
Reference
2023-103323
Expiry date
01/01/0001
Author
Tulio SanquizAuthor
Tulio SanquizSalary
Location
Belgium, United Kingdom, Denmark, France, Spain, Germany, Netherlands, Switzerland
Department
Medical Affiars & Medical Writing Roles
Location
Belgium
Denmark
France
Germany
Netherlands
Spain
Switzerland
UK
Remote Working
Remote
Business Area
ICON Strategic Solutions
Job Categories
Medical Writing
Job Type
Permanent
Description
As a Principal Medical Writer you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence. As principal medical writer, you will be
Reference
2023-103952
Expiry date
01/01/0001
Author
Natalia RothAuthor
Natalia RothSalary
Location
Ireland, Europe, United Kingdom, South Africa, Poland, Bulgaria, Spain, Germany, Netherlands, Romania, Czech Republic, Slovakia
Department
Biometrics Roles
Location
Any EMEA Location
Bulgaria
Czech Republic
Germany
Ireland
Netherlands
Poland
Romania
South Africa
Spain
UK
Slovakia
Remote Working
Remote
Business Area
ICON Strategic Solutions
Job Categories
Statistics
Job Type
Permanent
Description
As a Principal Biostatistician you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence.
Reference
2023-104906
Expiry date
01/01/0001
Salary
Location
Mexico, Mexico City
Location
Mexico City
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Early Phase Services
Job Type
Permanent
Description
ICON plc is a world-leading healthcare intelligence and clinical research organisation. From molecule to medicine, we advance clinical research providing outsourced services to pharmaceutical, biotech
Reference
JR118557
Expiry date
01/01/0001
Author
Elizabeth DaviesAuthor
Elizabeth Davies