About the Role
We are seeking an experienced Data Warehouse Administrator to join our team in a permanent capacity.
This is a hybrid role, requiring 3 days per week attendance at our office in Dublin 24/22.
-----------------------------------
Job Description
The successful candidate will be responsible for managing the entire data lifecycle, ensuring data quality and consistency, and supporting the development and deployment of reports and dashboards.
This role plays a critical part in enabling data-driven decision making across the organization.
-----------------------------------
Main Responsibilities
* Develop and maintain the overall architecture and design of the data warehouse, including data models, data marts, and data cubes.
* Create and optimize data models, schemas, and ETL processes.
* Implement data integration strategies to consolidate data from various sources.
* Establish and enforce data quality standards and procedures.
* Monitor and troubleshoot data quality issues, ensuring data accuracy and consistency within the warehouse.
* Develop and implement data cleansing and remediation processes.
* Design, develop, and maintain ETL pipelines to extract, transform, and load data into the data warehouse.
* Optimize ETL processes for performance and efficiency.
* Monitor data warehouse performance and identify bottlenecks.
* Implement performance tuning techniques to improve query response times and system efficiency.
* Ensure the security and confidentiality of data within the data warehouse.
* Implement data governance policies and procedures.
* Comply with relevant data privacy regulations (e.g., GDPR, CCPA).
* Create and maintain comprehensive documentation for data warehouse processes, procedures, and standards.
-----------------------------------
Requirements
* A minimum of 5 years experience working with cloud-based data warehouse technologies.
* Experience with Azure technology, including Synapse, Azure ML, Fabric, Cosmos DB, Azure Storage (Table Storage, Blob Storage), Postgre SQL, Copilot, and ADF.
* Strong proficiency in SQL and data modeling techniques.
* Experience with ETL tools.
* Excellent problem-solving and analytical skills.
* Strong communication and interpersonal skills.