Data Warehouse Architect
Job Description:
• Conduct comprehensive assessments of existing data sources, architectures, data flows, data models and reporting.
• Collaborate with business and IT stakeholders to understand current and future data requirements and translate them into robust solutions and design.
• Evaluate data quality, consistency, and compliance with governance standards.
• Evaluate and recommend data warehouse technologies, tools, and best practices.
• Define to be a data warehouse data model as per EDW standards and high level logical and physical data models.
• Review data integration, storage, and data retrieval processes for efficiency and cost-effectiveness.
• Advise on best practices for cloud migration, data security, and compliance.
• Design and present a scalable and high-performance data warehouse architecture to business and IT stakeholders.
• Work closely with data analysts, data engineers and IT/business stakeholders to implement, and maintain scalable and high-performance data warehouse solutions.
Requirements:
• Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
• Extensive experience (8+ years) in designing and implementing data warehouse solutions.
• Strong knowledge of data modeling (star schema, snowflake schema, data vault schema) and dimensional modeling.
• Proficiency in modern ETL tools.
• Experience with SQL and database technologies (Oracle, SQL Server, Teradata, Snowflake, Databricks Redshift, BigQuery, etc.).
• Implementation experience of cloud data warehouse platforms and architectures.
• Experience evaluating and proposing future ready enterprise data warehouses roadmap.
• Familiarity with BI tools such as Tableau, Power BI, or Looker.
• Strong problem-solving, analytical, and communication skills.
Benefits:
Apply tot his job
Apply To this Job