Senior Software Engineer - ODI/AWS

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.

JOB FUNCTIONS/RESPONSIBILITIES Work with project lead and business users to gather requirements, conduct analysis and prioritize requestsDesign and implement the data loading (ETL) and publishing processes within the DW/BI environmentDesign 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 Strong team player with proactive approach, willing to take ownershipGood communication skills

AWS Recourse:Minimum 5 years of experience in AWSWorking experience in JavaExperience in working/creating AWS Lambda Functions using Java or PythonExperience in working/creating APIs using AWS API gateways (Proxy/nonProxy integration ) with AWS Lambda has backendExperience in storing / retrieving data to/from DynamoDB/Aurora RDS using AWS Lambda functions

ODI Recourse:Minimum 6 years of experience in ODI or AWSGood hands on experience in the design, construction and management of Data Warehouse and data modelingExperience in the design and implementation of ETL processes using Oracle ODIStrong foundation and understanding of Dimensional Modeling and OLAP principles.Strong Oracle SQL skills