Data Warehouse Administrator Our Client, an environmental firm, is looking to recruit an experienced Data Warehouse Administrator for a permanent role to join their Data Team.
The role is hybrid and will be 3 days in their office in Dublin 24/22.
The Role: The Data Warehouse Administrator will be responsible for the entire data lifecycle, from ensuring data quality and consistency to supporting the development and deployment of reports and dashboards.
This role is critical in enabling data-driven decision making across the organization.
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.Work with business analysts and data scientists to understand their needs and develop solutions to meet their reporting and data analysis requirements.The Person: Minimum of 5 years experience in working with cloud-based data warehouse technologiesExperience with Azure technology: Synapse, Azure ML, Fabric, CosmosDB, Azure Storage (Table Storage, Blob Storage), PostgreSQL, Copilot, ADFExperienced in data warehouse architecture, design, and implementationProven experience handling high-data volumes (several TBs)Strong proficiency in SQL and data modelling techniques.Experience with ETL toolsExcellent problem-solving and analytical skills.Strong communication and interpersonal skills.
#J-18808-Ljbffr