ETL Data Architect (Informatica Intelligent Cloud Services - IICS)

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, biotechnology, medical device and government and public health organisations.

With our patients at the centre of all that we do, we help to accelerate the development of drugs and devices that save lives and improve quality of life.

Our people are our greatest strength, are at the core of our culture, and the driving force behind our success. ICON people have a mission to succeed and a passion that ensures what we do, we do well.


What do you need to have?
  • 10+ years' experience in the architecture, design and development of Data Warehouse, Data Integration and ETL.
  • Strong Knowledge of IICS - Cloud Data Integration (and related tools on the platform) and ETL Architecture.
  • Hands-on design and development with tools such as IICS - Cloud Data Integration, Cloud Data Quality, Replication.
  • Design and Data Modeling experience using ER/Studio.
  • In-depth experience with Data Warehousing and Data Mart with strong SQL required.
  • Conduct requirements analysis, design and implementation of business process changes.
  • Excellent knowledge of Snowflake, Oracle, Database design, and SQL.
  • Strong problem solving and analytical skills.
  • Knowledge of query, reporting, database, and analytic business intelligence tools.
  • Lead a development pod in execution of multiple projects.
  • Read, write and speak English; fluent in host country language required.
  • BS in computer science or equivalent or working towards a BS degree.
Preferred Qualifications:
  • Informatica Certification, preferred.
  • MS in computer science or equivalent preferred
Benefits of Working in ICON:Our success depends on the knowledge, capabilities and quality of our people. That's why we are committed to developing our employees in a continuous learning culture - one where we challenge you with engaging work and where every experience adds to your professional development.At ICON, our focus is to provide you with a comprehensive and competitive total reward package that comprises, not only an excellent level of base pay, but also a wide range of variable pay and recognition programs. In addition, our best in class employee benefits, supportive policies and wellbeing initiatives are tailored to support you and your family at all stages of your career - both now, and into the future.ICON, including subsidiaries, is an equal opportunity and inclusive employer and is committed to providing a workplace free of discrimination and harassment. All qualified applicants will receive equal consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or in order to perform the essential functions of a position, please let us know.


What will you be doing?We're taking a fresh approach at ways that technology and analytics can empower those working in the clinical lifecycle and shape the future of clinical development. Develop, implement, and maintain systems that align to PRA's IT architecture and strategies. Participate in design sessions and provide input on software solutions. Act as technical lead for one or more projects, providing oversight and guidance on technical and design issues and mentor junior team members. Act as a liaison between software engineers and architecture. Be proactive in software design and architecture, working closely with architects and software engineers to come up with the right solutions to the problem. Be an active participant and lead code reviews. Keep up to date with the latest developments in the software field.

United States-Remote