Data Architect

3 weeks ago


Dublin, Dublin City, Ireland Executive Edge Full time

Data Architect / Data Warehouse Developer

Our Client, a large Healthcare provider, are looking to recruit an experienced Data Architect / Darta Warehouse Developer to work on a large project. It will initially be a 4-5 month project, but could well be extended.

The aim for the contracted Data Architect is to build out a functional Enterprise data warehouse (DW) at the most granular level that can be incrementally grown over time and contains distinct Dimension and Facts that can then be presented via the chosen visualization tool. The current Data Warehouse is on an On-Premise SQL SERVER 2019 enterprise. The proposed expansion of the existing Data Warehouse build will be incorporated into the existing Data Warehouse.

Requirements of the Build:

  • The intention is to build the Fact and Dimension tables based on business driven requirements. The purpose of an Event table is to encapsulate the highest level of business requirements in terms of the key metrics from within the hospital.
  • The design is based on the use of Microsoft technologies currently available. A 2019 SQL Server instance SQL Server Enterprise Licence, along with Visual Studio using both SQL Server Integration Service (SSIS) and Store procedures is the preferred approach. SQL Agent Catalogue will be used to schedule jobs appropriately.
  • Each Fact tables should have the appropriate Event ID and Surrogate key to be linked to Event or Dimension tables where appropriate.
  • All staging and Transactional Tables should have a unique prefix. Example
  • Data Warehouse tables will also have a unique prefix Fact_ for fact Tables Dim_ for Dimensions. Event Table will be Dim_ Event and will be specifically related to high level requirement driven by the business.
  • All columns that exist in the Fact tables are prefixed uniquely when they are associated back to source Transactional Tables. This should allow for easy traceability.
  • Only business driven Facts will be present in the Data Warehouse as defined by the client. It is envisaged they will define the Facts and Dimension tables to be part of the Data warehouse Structure. They will define the Event table based on the High Level Business requirements.

The Person:

  • Proficiency in SQL Server 2019, including installation, configuration, and maintenance.
  • Strong knowledge of SQL Server Enterprise features such as partitioning, compression, and data encryption.
  • Experience with SQL Server Management Studio (SSMS) and Transact-SQL (T-SQL).
  • Extensive experience designing, developing, and deploying SSIS packages.
  • Ability to create complex data transformation tasks, ETL processes, and data workflows.
  • Familiarity with SSIS features such as containers, event handlers, and logging.
  • Extensive experience designing, developing, and deploying SSIS packages.
  • Ability to create complex data transformation tasks, ETL processes, and data workflows.
  • Familiarity with SSIS features such as containers, event handlers, and logging.
  • Excellent verbal and written communication skills.
  • Ability to effectively communicate technical concepts to non-technical stakeholders.
  • Experience working in cross-functional teams and collaborating with business analysts, project managers, and other developers.
  • Ability to mentor junior developers and provide technical guidance.

For more information, please call Keith on or email


#J-18808-Ljbffr
  • Senior Data Architect

    3 weeks ago


    Dublin, Dublin City, Ireland Data Spree GmbH Full time

    Senior Data ArchitectIf selected, you will be required to work on a full-time basis on-site or remotely (as required) with our client in Central Dublin. Estimated Start October 2024Our client in the government sector is seeking to establish a multi-year contract for a Data Architect.Our client engages with the business on the design, development, procurement...


  • Dublin, Dublin City, Ireland IRC Full time

    Data Solutions ArchitectApplications Solutions ArchitectPermanent position - Hybrid working environment (2 days in-office per week)We are seeking a Data Solution Architect OR Applications Solutions Architect with a focus on Corporate Business Applications rather than Infrastructure. The suitable candidate will have a mixture of business and Technical skills...

  • Data Architect

    3 weeks ago


    Dublin, Dublin City, Ireland Test Triangle Full time

    Job DescriptionJob Title: Data Architect (SQL Server) Location: West Dublin, Ireland Contract: This role is for a 6-month engagement (probably 12 months +), with the first 4 weeks requiring the person to be onsite. After that, the position transitions to a hybrid model, with 2 days per week in the office in West Dublin. Garda vetting is required before...

  • Technical Architect

    3 weeks ago


    Dublin, Dublin City, Ireland NTT DATA Full time

    Job Description At NTT DATA Services, we are always on the lookout for exceptional, creative, and driven professionals who are eager to progress with us. If you are interested in joining an inclusive, flexible, and forward-looking company, this could be the perfect opportunity for you. Summary As the Core Banking Technical Architect, you will have a key role...

  • Technical Architect

    3 weeks ago


    Dublin, Dublin City, Ireland NTT DATA Services Full time

    NTT DATA Services strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.SummaryAs the Core Banking Technical Architect, you will play a crucial role in providing strategic and technical guidance to our clients in the banking...


  • Dublin, Dublin City, Ireland Codec Azure Full time

    Senior Microsoft Data ArchitectDepartment: AzureEmployment Type: PermanentLocation: DublinDescriptionCodec are recruiting for a Microsoft Data Architect required who is knowledgeable and experienced on Business Intelligence and Data Warehouse. This is a great opportunity for an Architect to grow and develop their career in BI and Data Warehousing.Codec...

  • Technical Architect

    3 weeks ago


    Dublin, Dublin City, Ireland NTT DATA, Inc. Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert NTT DATA Services strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. Summary As the Core Banking Technical...

  • Lead Data Architect

    3 weeks ago


    Dublin, Dublin City, Ireland ARDAGH GROUP Full time

    Lead Data ArchitectMember of the Strategy & Architecture function. Responsible for reviewing and analysing the data infrastructure of Ardagh, plan future databases, and implement solutions to store and manage data for the organization and their users. Key Responsibilities:Select and implement the appropriate tools, software, applications, and systems to...

  • Solution Architect

    3 weeks ago


    Dublin, Dublin City, Ireland NTT DATA, Inc. Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert NTT DATA Services strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. Summary of role: The successful candidate...

  • Solution Architect

    1 week ago


    Dublin, Dublin City, Ireland NTT DATA, Inc. Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert NTT DATA Services strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. Summary of role: The successful...

  • Senior Data Architect

    1 month ago


    Dublin, Dublin City, Ireland Eolas Recruitment Full time

    Dublin Permanent Hybrid Negotiable Ref: Job Description Leading corporate client in Dublin City is looking for a Senior Data Architect / Head of Data who had lead their Advisory/ Integration services . Job Responsibilities The person will be responsible for leading a data engineering practice in a consulting environment They will have experience in large...


  • Dublin, Dublin City, Ireland Hadfieldgreen Full time

    Join a leading Financial Services Asset Management firm headquartered in Dublin, Ireland, where technology innovation thrives at the heart of operations.Location:Dublin, Ireland (Initially 6 months onsite at IFSC, transitioning to 3 days in office per week)The Business:A dynamic and forward-thinking company at the forefront of the financial services...


  • Dublin, Dublin City, Ireland Veda Data Full time

    Veda helps patients get the care they need by untangling complex data management problems using advanced scientific approaches and in-depth collaboration. Our technology reflects what our people provide: quality without ego, honesty backed by science, and warmth in an industry not known for having much heat. Veda is made up of talented professionals that...

  • Solution Architect

    3 weeks ago


    Dublin, Dublin City, Ireland Version 1 Full time

    Job Description Version 1 are one of a handful of AWS Premier Consulting Partners, which is the highest tier of AWS Partnership available. You will be working for the AWS Practice which consists of some of the best Architects, DevOps Engineers and Consultants. The customer engagements are varied and the exposure to cutting-edge technologies is always...


  • Dublin, Dublin City, Ireland Amazon Data Services Ireland Limited Full time

    AWS Infrastructure Services owns the design, planning, delivery, and operation of all AWS global infrastructure. In other words, we're the people who keep the cloud running. We support all AWS data centers and all of the servers, storage, networking, power, and cooling equipment that ensure our customers have continual access to the innovation they rely on....

  • Solutions Architect

    3 weeks ago


    Dublin, Dublin City, Ireland Ergo Full time

    Ergo are seeking a Solutions Architect with previous experience in Big Data / Machine Learning for an initial 6 month contract role that can be worked remotely from anywhere in the EU. As the Telecoms Solutions Architect you will be responsible for optimisation modelling and "traffic steering" of big data within an international telecoms environment. ...

  • Solution Architect

    3 weeks ago


    Dublin, Dublin City, Ireland NTT DATA Full time

    Job Description NTT DATA Services strives to hire exceptional, innovative, and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.Summary of role:The successful candidate will be a valued member of the Core Banking Platform Design COE responsible for the oversight...

  • Lead Architect

    3 weeks ago


    Dublin, Dublin City, Ireland Salesforce, Inc. Full time

    What if you were empowered to solve the most complex business problems that Fortune 500 companies face today? What if you had the best social and mobile cloud technology stack to achieve that goal? What if you could work for a company that believes that top line growth is as important as giving back to the community? What if you could work alongside the best...


  • Dublin, Dublin City, Ireland Veda Data Solutions Full time

    Veda helps patients get the care they need by untangling complex data management problems using advanced scientific approaches and in-depth collaboration. Our technology reflects what our people provide: quality without ego, honesty backed by science, and warmth in an industry not known for having much heat.Veda is made up of talented professionals that are...


  • Dublin, Dublin City, Ireland Amazon Data Services Ireland Limited Full time

    Amazon Web Services (AWS) Design Engineering team is looking for a highly talented and motivated Physical Security Architect (PSA) / Engineer to work with our enterprise data centre design team, designing the data centres of tomorrow to maximize the effectiveness of the physical security program. The duties include extra-low voltage system design and...