SME (Subject Matter Expert) Data Architect / Microsoft Azure Data Engineering

2 weeks ago

Dublin, Ireland Avance Consulting Full time

The Role
TCS seek a Subject Matter Expert: Data Architect to support a key project in the utilities sector.

Key responsibilities:

  • Understanding business requirements relating to business data sources with the ability to integrate it and/ or transform it effectively in accordance with business needs.

  • Defining data architecture principles in Azure.

  • Developing reference data architectures that align a modern approach to business need.

  • Advocating for modern and effective data architecture in ESB using Azure aligned with business needs.

  • Designing ETL flows according to reference data architectures in Azure.

  • Design, develop and deploy the migration of existing on premises solutions to Azure environments.

  • Setting the standard for data modelling in ESB and applying it to data warehouse design in Azure.

  • Establishing processes and procedures for a Data Architecture discipline in ESB.

  • Facilitating Data Architecture training in ESB.

Your Profile
Key skills/knowledge/experience:

  • Significant experience in Software Development and Agile

  • Experience in data engineering solutions development.

  • Extensive experience of data architecture design patterns for Descriptive, Predictive and Prescriptive Analytics.

  • Excellent knowledge of Data Engineering best practices.

  • Excellent data modelling knowledge including relational modelling (Inmon) and dimensional modelling (Kimball).

  • Practical experience of data pipelines for Dimension and Fact data structures including SCD I and SCD II.

  • Extensive knowledge in designing best in class data pipelines balancing performance and cost.

  • Extensive knowledge and experience of working in Modern Data Architectures including Data Lakes, Delta Lakes, Data Warehouses, Data Marts, Dimensional Data Stores & Lake Houses.

  • Knowledge of setting up Azure Synapse connectors (On-prem file shares, SFTP, SQL database, HTTP, etc.)  in real world enterprise environment.

  • Significant experience in Database and Data Storage Platforms including Azure Data Lake.

  • Extensive experience in data migration planning and implementation.

  • Extensive knowledge of data modelling techniques and structures.

  • Extensive Data Architecture experience in the following:

    • Designing & implementing Conceptual, Logical, and Physical data models

    • Designing & implementing Relational data models with normalisation

    • Designing & implementing Dimensional Data Models (Dimensions, Facts, SCD I, SCD II, SCD III)

    • Designing & implementing Lakehouse and Delta Lake architectures

  • Reporting, documentation/writing.

  • Excellent Organisational skills.

  • Experience with a wide range of IT environments, platforms and applications

  • IT Qualification - Degree or equivalent work experience.

  • Professional certifications e.g. MCSE

The Role
TCS seeks a Subject Matter Expert: Microsoft Azure Data Engineering to support a key project in the Utilities sector.

Key responsibilities:

  • Understanding business requirements relating to business data sources with the ability to integrate it and/ or transform it effectively in accordance with business needs.

  • Development of Extract Transform and Load routines, modelling, queries, reports and analysis.

  • Support of existing data marts, warehouse process chains and associated models and queries.

  • Ensuring the successful delivery of all assigned Data Engineering work on projects across all ESB business units and their successful deployment to production, including use cases developed by our Data Science & Analytics team.

  • Implement changes (CR’s) or new developments relating to existing or new solutions.

  • Troubleshooting and resolving issues with any of our Azure data repositories.

  • Design, develop and deploy the migration of existing on premises solutions to Azure environments.

  • Implementing and ensuring compliance with Data Engineering best practice.

Your Profile
Key skills/knowledge/experience:

  • Excellent knowledge of Data Engineering best practices.

  • Proven data modelling knowledge including relational modelling (Inmon) and dimensional modelling (Kimball).

  • Ability to create best in class data pipelines balancing performance and cost.

  • Practical experience in developing solutions using Azure Synapse Pipelines, Synapse pySpark Notebooks, Azure Data Lake, Synapse Dedicated SQL Pool and Serverless Pool. 

  • Practical experience of creating data pipelines for Dimension and Fact data structures including SCD I and SCD II.

  • Expert knowledge of Azure Synapse Data Connectors

  • Practical hands-on experience in successfully configuring Azure Data Connectors within Synapse in an Enterprise environment.

  • Practical experience of good housekeeping and structuring data engineering artifacts and objects in the Azure Synapse and Data Lake environment.

  • Practical experience in creating CI/CD pipelines in Azure Synapse.

  • Excellent knowledge of security configuration and access for Azure Data Lakes and Azure Synapse workspaces. Significant advisory and consultancy experience in Emerging Technology.

  • Ability to manage, co-ordinate and present to stakeholders at all levels of the organisation.

  • Extensive experience in data migration planning and implementation.

  • Excellent Reporting, documentation/writing, and presentation skills

  • Excellent Organisational skills.

  • Experience with a wide range of IT environments, platforms and applications

  • IT Qualification - Degree or equivalent work experience.

  • Professional certifications e.g. MCSE

  • Subject Matter Expert

    3 weeks ago

    Dublin, Dublin City, Ireland NTT DATA Full time

    Job DescriptionNTT DATA Services is looking for an exceptional Business Consultant/SME with experience in implementing Loan Origination Systems for Corporate Customers to join their team. The ideal candidate will be responsible for leading the implementation of a Loan Origination System for a client, leveraging their expertise in financial services to...

  • Senior Microsoft Data Architect

    3 weeks ago

    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...

  • Subject Matter Expert

    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. Summary of Role:We are seeking a knowledgeable and experienced Business Consultant/SME to join our team who has hands on experience in the...

  • Azure Data

    3 weeks ago

    Dublin, Dublin City, Ireland Microsoft Full time

    OverviewIn Sales and Digital Sales, we aim to empower our customers through the unique value of the Microsoft cloud by establishing a globally led, digital-first organization aligned with partners. Focused on the Small, Medium, Corporate (SMC) and Digital Sales sector, we are on track to becoming Microsoft's next $100 billion-dollar business. As part of...

  • Senior Microsoft Data Consultant

    1 month ago

    Dublin, Dublin City, Ireland Codec Azure Full time

    Senior Microsoft Data Consultant (Dublin) Department: Azure Employment Type: Full Time Location: Dublin Description Codec are recruiting for a Senior Microsoft Data Consultant for our Dublin team. This role will require the candidate to be knowledgeable and experienced on Business Intelligence and Data Warehouse. This is a great opportunity for a...

  • Senior Engineering Architect​

    5 days ago

    Dublin, Ireland Microsoft Full time

    Overview Azure Databases SQL Customer Success Engineering is looking for a Senior Engineering Architect who is passionate about the entire Microsoft Data Platform and its potential to enable transformational change at our customers. Azure Database Services are proven cornerstones of many of our largest customers data landscapes. We are helping...

  • Azure Data

    3 weeks ago

    Dublin, Dublin City, Ireland myGwork Full time

    This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community. Overview In SMC and Digital Sales, we have set out with the purpose of empowering our customers through the unique value of the Microsoft cloud by building a globally led, digital-first scale organization aligned with partners. Dedicated to...

  • Azure Data

    1 month ago

    Dublin, Ireland Microsoft Full time

    Overview In SMC and Digital Sales, we have set out with the purpose of empowering our customers through the unique value of the Microsoft cloud by building a globally led, digital-first scale organization aligned with partners. Dedicated to one of the fastest growing customer segments, the Small, Medium, Corporate (SMC) and Digital Sales organization...

  • Digital Technical Specialist, Azure Data

    3 weeks ago

    Dublin, Dublin City, Ireland MyGwork Full time

    This inclusive employer is a member of my Gwork – the largest global platform for the LGBTQ+ business community.Overview Join a fantastic team environment The Digital Technology Specialist, Azure Data & AI role is focused on working with Microsoft's account teams to identify and drive opportunities in the massively exciting growth area of Data and...

  • Azure Cloud Architect

    1 month ago

    Dublin, Ireland Version 1 Full time

    Job Description Architecture, Implementation, and Delivery of Enterprise Microsoft Azure projects.  Business Development, Technical Pre-Sales, and proposals. Collaboration and technical consultation with customer, Version 1, and 3rd party technical teams such as applications, databases, data analytics, security, networks etc. to define...

  • Digital Technical Specialist, Azure Data

    3 weeks ago

    Dublin, Dublin City, Ireland myGwork Full time

    This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community. Overview Join a fantastic team environment The Digital Technology Specialist, Azure Data & AI role is focused on working with Microsoft's account teams to identify and drive opportunities in the massively exciting growth area of Data and...

  • Physical Security Architect

    1 month ago

    Dublin, 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...

  • Digital Technical Specialist

    1 month ago

    Dublin, Ireland Microsoft Full time

    Overview Microsoft’s mission is to empower every person and every organization on the planet to achieve more. As employees we come together with a growth mindset, innovate to empower others, and collaborate to realize our shared goals. Each day we build on our values of respect, integrity, and accountability to create a culture of inclusion where...

  • Digital Technical Specialist

    1 month ago

    Dublin, Ireland Microsoft Full time

    Overview With continued growth in digital data and the desire to leverage data to address problems that touch all aspects of our lives, Microsoft’s is growing to meet these challenges! The Azure Data & AI team is hiring experienced Azure Technical Specialist to join agile and diverse team in Data Platform (Azure SQL, Azure Data Lake Gen2, Databricks,...

  • Azure Cloud Architect

    3 weeks ago

    Dublin, Dublin City, Ireland Version 1 Full time

    Job DescriptionArchitecture, Implementation, and Delivery of Enterprise Microsoft Azure projects. Business Development, Technical Pre-Sales, and proposals.Collaboration and technical consultation with customer, Version 1, and 3rd party technical teams such as applications, databases, data analytics, security, networks etc. to define requirements for new...

  • Solution Area Specialist

    3 weeks ago

    Dublin, Ireland Microsoft Full time

    Overview Microsoft is a company where passionate innovators come to collaborate, envision what can be, and take their careers to levels they can't achieve anywhere else. This is a world of more possibilities, more innovation, more openness, and sky's-the-limit thinking -- a cloud-enabled world. At Microsoft we have unique capabilities to meet the needs...

  • Azure Cloud Architect

    1 month ago

    Dublin, Ireland Version 1 Full time

    Job DescriptionArchitecture, Implementation, and Delivery of Enterprise Microsoft Azure projects. Business Development, Technical Pre-Sales, and proposals.Collaboration and technical consultation with customer, Version 1, and 3rd party technical teams such as applications, databases, data analytics, security, networks etc. to define requirements for new...

  • Azure Cloud Architect

    7 days ago

    Dublin, Ireland Version 1 Full time

    Job DescriptionArchitecture, Implementation, and Delivery of Enterprise Microsoft Azure projects. Business Development, Technical Pre-Sales, and proposals.Collaboration and technical consultation with customer, Version 1, and 3rd party technical teams such as applications, databases, data analytics, security, networks etc. to define requirements for new...

  • Physical Security Architect

    4 weeks ago

    Dublin, 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...

  • Digital Technical Specialist, Azure Data

    1 month ago

    Dublin, Ireland myGwork Full time

    This inclusive employer is a member of myGwork – the largest global platform for the LGBTQ+ business community. Overview Join a fantastic team environment! The Digital Technology Specialist, Azure Data & AI role is...