Job Overview
The role of a Subject Matter Expert: Data Architect involves supporting a key project in the utilities sector.
Key Responsibilities:
* Understanding business requirements relating to business data sources and integrating them effectively according to business needs.
* Defining data architecture principles in Azure, developing reference data architectures that align with modern approaches to business needs.
* Designing ETL flows according to reference data architectures in Azure, designing, developing, and deploying the migration of existing on-premises solutions to Azure environments.
* Setting standards for data modelling and applying it to data warehouse design in Azure, establishing processes and procedures for a Data Architecture discipline, and facilitating Data Architecture training.
Your Profile
Key Skills and Qualifications:
* Significant experience in Software Development and Agile methodologies.
* Experience in data engineering solutions development, extensive knowledge 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 in real-world enterprise environments.
* 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, Data Architecture experience in designing and implementing Conceptual, Logical, and Physical data models.
* Reporting, documentation/writing, and excellent organisational skills.
* Experience with a wide range of IT environments, platforms, and applications, IT qualifications – Degree or equivalent work experience, professional certifications e.g. MCSE.
Candidates should hold appropriate RTWs for Ireland.