Job Title: Data Warehouse Administrator
The role of a Data Warehouse Administrator is crucial in enabling data-driven decision making across an organization. This position involves the entire data lifecycle, from ensuring data quality and consistency to supporting the development and deployment of reports and dashboards.
Key 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.
* Work with business analysts and data scientists to understand their needs and develop solutions to meet their reporting and data analysis requirements.
Requirements:
* Minimum of 5 years of experience in working with cloud-based data warehouse technologies.
* Experience with Azure technology: Synapse, Azure ML, Fabric, CosmosDB, Azure Storage (Table Storage, Blob Storage), PostgreSQL, Copilot, ADF.
* Experienced in data warehouse architecture, design, and implementation.
* Proven experience handling high-data volumes (several TBs).
* Strong proficiency in SQL and data modeling techniques.
* Experience with ETL tools.
* Excellent problem-solving and analytical skills.
* Strong communication and interpersonal skills.