Overview
Data Architect-SME (Subject Matter Expert)
Job Type: Permanent, Location: Dublin, Ireland – Hybrid, 1 – 2 days onsite per week at customer office.
The Role
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 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 and applying it to data warehouse design in Azure.
* Establishing processes and procedures for a Data Architecture discipline.
* Facilitating Data Architecture training.
Your Profile
* 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, 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.
* Experience with a wide range of IT environments, platforms and applications.
* IT Qualification – Degree or equivalent work experience.
* Professional certifications e.g. MCSE.
Candidates should hold appropriate RTWs for Ireland i.e. Stamp1G, Stamp 4, Irish/British/EU passport.
eir evo talent is an equal opportunity employer who seeks to recruit and appoint the best available person for a job regardless of marital / civil partnership status, sex (including pregnancy), age, religion, belief, race, nationality and ethnic or national origin, colour, sexual orientation or disability. eir evo talent apply all relevant Data Protection laws when processing your Personal Data.If you choose to apply to this opportunity and share your CV or other personal information with eir evo talent, these details will be held by us in accordance with our privacy policy used by our recruitment team to contact you regarding this or other relevant opportunities at eir evo talent. Ref: EET